티스토리 뷰
CorsConfig.java
1
2
3
4
5
6
7
8
9
10
11
12
13
|
package com.parksrazor.web;
import org.springframework.web.servlet.config.annotation.CorsRegistry;
import org.springframework.web.servlet.config.annotation.WebMvcConfigurer;
public class CorsConfig implements WebMvcConfigurer{
@Override
public void addCorsMappings(CorsRegistry registry) {
registry.addMapping("/**")
.allowedOrigins("http://127.0.0.1:8080")
.allowedOrigins("http://localhost:8080");
}
}
|
cs |
HomeController.java
1
2
3
4
5
6
7
8
9
10
11
12
13
|
package com.parksrazor.web;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
@RestController
public class HomeController {
@GetMapping("/")
public String home(){
return "Hello Spring Boot !!";
}
}
|
cs |
MybatisConfig.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
package com.parksrazor.web;
import javax.sql.DataSource;
import org.apache.ibatis.session.SqlSessionFactory;
import org.mybatis.spring.SqlSessionFactoryBean;
import org.mybatis.spring.SqlSessionTemplate;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;
import org.springframework.transaction.annotation.EnableTransactionManagement;
import org.springframework.core.io.support.PathMatchingResourcePatternResolver;
@Configuration
@MapperScan(basePackages= {"com.parksrazor.web.mappers"})
@EnableTransactionManagement
public class MybatisConfig {
@Bean
public SqlSessionFactory sqlSessionFactory(DataSource dataSource) throws Exception {
final SqlSessionFactoryBean sessionFactory = new SqlSessionFactoryBean();
sessionFactory.setDataSource(dataSource);
PathMatchingResourcePatternResolver resolver = new PathMatchingResourcePatternResolver();
sessionFactory.setMapperLocations(resolver.getResources("classpath:com/parksrazor/web/mappers/*.xml"));
return sessionFactory.getObject();
}
@Bean
public SqlSessionTemplate sqlSessionTemplate(SqlSessionFactory sqlSessionFactory ) throws Exception {
final SqlSessionTemplate sqlSessionTemplate = new SqlSessionTemplate(sqlSessionFactory);
return sqlSessionTemplate;
}
}
|
cs |
ServletInitializer.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
package com.parksrazor.web;
import org.springframework.boot.builder.SpringApplicationBuilder;
import org.springframework.boot.web.servlet.support.SpringBootServletInitializer;
public class ServletInitializer extends SpringBootServletInitializer {
@Override
protected SpringApplicationBuilder configure(SpringApplicationBuilder application) {
return application.sources(WebApplication.class);
}
}
|
cs |
WebApplication.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
package com.parksrazor.web;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class WebApplication {
public static void main(String[] args) {
SpringApplication.run(WebApplication.class, args);
}
}
|
cs |
application.properties
1
2
3
4
5
6
|
server.port=3000
spring.datasource.url=jdbc:mariadb://127.0.0.1:3306/mariadb
spring.datasource.username=mariadb
spring.datasource.password=mariadb
spring.datasource.driverClassName=org.mariadb.jdbc.Driver
|
cs |
PlayerController.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
package com.parksrazor.web.controllers;
import com.parksrazor.web.domains.PlayerDTO;
import com.parksrazor.web.services.PlayerService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
@CrossOrigin(origins="*", allowedHeaders = "*")
@RestController
@RequestMapping("/players")
public class PlayerController {
@Autowired PlayerService playerService;
@Autowired PlayerDTO player;
@GetMapping("")
public List<PlayerDTO> list(){
return playerService.retrieve();
}
@PostMapping("/{playerId}/access")
public Map<String, Object> login(
@PathVariable String playerId,
@RequestBody PlayerDTO params){
Map<String,Object> map = new HashMap<>();
player = playerService.login(params);
if(player != null){
System.out.println("로그인 정보 "+ player.toString());
map.put("result", true);
}else{
map.put("result", false);
}
map.put("player", player);
return map;
}
}
|
cs |
PlayerService.java
1
2
3
4
5
6
7
8
9
10
11
12
13
|
package com.parksrazor.web.services;
import com.parksrazor.web.domains.PlayerDTO;
import org.springframework.stereotype.Component;
import java.util.List;
@Component
public interface PlayerService {
public List<PlayerDTO> retrieve();
public PlayerDTO findOne(String searchWord);
public PlayerDTO login(PlayerDTO params);
}
|
cs |
PlayerServiceImpl.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
package com.parksrazor.web.serviceImpls;
import com.parksrazor.web.domains.PlayerDTO;
import com.parksrazor.web.mappers.PlayerMapper;
import com.parksrazor.web.services.PlayerService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class PlayerServiceImpl implements PlayerService {
@Autowired PlayerMapper playerMapper;
@Override
public List<PlayerDTO> retrieve() {
return playerMapper.selectAll();
}
@Override
public PlayerDTO findOne(String searchWord) {
return playerMapper.selectOne(searchWord);
}
@Override
public PlayerDTO login(PlayerDTO params) {
return playerMapper.login(params);
}
}
|
cs |
PlayerMapper.java
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
package com.parksrazor.web.mappers;
import com.parksrazor.web.domains.PlayerDTO;
import org.springframework.stereotype.Repository;
import java.util.List;
@Repository
public interface PlayerMapper {
public List<PlayerDTO> selectAll();
public PlayerDTO selectOne(String searchWord);
public PlayerDTO login(PlayerDTO params);
}
|
cs |
PlayerMapper.xml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
|
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.parksrazor.web.mappers.PlayerMapper">
<select id="selectAll" resultType="com.parksrazor.web.domains.PlayerDTO">
select
player_id playerId, player_name playerName, e_player_name ePlayerName,
nickname, join_yyyy joinYyyy, position, back_no backNo, nation,
birth_date birthDate, solar, height, weight, team_id teamId
from player
</select>
<select id="selectOne" resultType="com.parksrazor.web.domains.PlayerDTO"
parameterType="string">
select
player_id playerId, player_name playerName, e_player_name ePlayerName,
nickname, join_yyyy joinYyyy, position, back_no backNo, nation,
birth_date birthDate, solar, height, weight, team_id teamId
from player
where player_id like #{value}
</select>
<select id="login" resultType="com.parksrazor.web.domains.PlayerDTO"
parameterType="com.parksrazor.web.domains.PlayerDTO">
select
player_id playerId, player_name playerName, e_player_name ePlayerName,
nickname, join_yyyy joinYyyy, position, back_no backNo, nation,
birth_date birthDate, solar, height, weight, team_id teamId
from player
where player_id like #{playerId} and back_no like #{backNo}
</select>
</mapper>
|
cs |
'3. 스크립트' 카테고리의 다른 글
JS/노드/2020-05-22/ Yarn 실행시 에러가 발행하는 경우 해결방법 (0) | 2020.05.22 |
---|---|
뷰/2020--/하이파/ 스포츠플젝 Login.vue (1) | 2020.05.21 |
[뷰JS] 계산기 예제 (0) | 2020.05.18 |
[뷰JS] 카운터 예제 (0) | 2020.05.18 |
[뷰JS] 축구 메인 - 홈버튼 처리하기 #40 (0) | 2020.05.15 |
댓글
공지사항
최근에 올라온 글
최근에 달린 댓글
- Total
- Today
- Yesterday
링크
TAG
- database
- maven
- Algorithm
- mariadb
- Eclipse
- AWS
- ERD
- Oracle
- jQuery
- JUnit
- docker
- Django
- tensorflow
- Git
- React
- intellij
- terms
- KAFKA
- SpringBoot
- vscode
- springMVC
- FLASK
- Mlearn
- JPA
- Python
- COLAB
- Mongo
- nodejs
- Java
- SQLAlchemy
일 | 월 | 화 | 수 | 목 | 금 | 토 |
---|---|---|---|---|---|---|
1 | ||||||
2 | 3 | 4 | 5 | 6 | 7 | 8 |
9 | 10 | 11 | 12 | 13 | 14 | 15 |
16 | 17 | 18 | 19 | 20 | 21 | 22 |
23 | 24 | 25 | 26 | 27 | 28 |
글 보관함