13518219792
1、创建好项目之后在
配置端口号（也可以不用配置，默认端口8080）
东丰ssl适用于网站、小程序/APP、API接口等需要进行数据传输应用场景，ssl证书未来市场广阔！成为成都创新互联公司的ssl证书销售渠道，可以享受市场价格4-6折优惠！如果有意向欢迎电话联系或者加微信：028-86922220（备注：SSL证书合作）期待与您的合作！
#server server.port=8080 server.tomcat.uri-encoding=utf-8
2、配置MySQL
#MySQL spring.datasource.driver-class-name=com.mysql.jdbc.Driver spring.datasource.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8 spring.datasource.username=***** spring.datasource.password=*****
3、配置jpa以及视图层
#Spring Data JPA spring.jpa.database=MYSQL spring.jpa.show-sql=true spring.jpa.hibernate.ddl-auto=update # Naming strategy spring.jpa.hibernate.naming-strategy = org.hibernate.cfg.ImprovedNamingStrategy # stripped before adding them to the entity manager) spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQL5Dialect #视图层控制 spring.mvc.view.prefix=classpath:/templates/ spring.mvc.view.suffix=.html spring.mvc.static-path-pattern=/static/**
4、在pom中加入springboot需要的依赖
org.springframework.boot spring-boot-starter-web mysql mysql-connector-java 5.1.39 org.springframework.boot spring-boot-starter-thymeleaf 1.4.0.RELEASE org.springframework.boot spring-boot-starter-data-jpa 1.5.1.RELEASE com.alibaba fastjson 1.2.46
整个包结构
Controller
package com.song.configuration.controller;
import com.alibaba.fastjson.JSONObject;
import com.song.configuration.entity.User;
import com.song.configuration.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import java.util.List;
/**
*
* User控制层
*/
@Controller
@RequestMapping(value = "/user")
public class UserController {
@Autowired
private UserService userService;
@RequestMapping(value = "/index")
public String index(){
return "user/index";
}
@RequestMapping(value = "/show",method = RequestMethod.GET)
@ResponseBody
public String show(@RequestParam(value = "name")String name){
User user = userService.findUserByName(name);
if(null != user)
return user.getId()+"/"+user.getName()+"/"+user.getPassword();
else return "null";
}
@RequestMapping("/showlist")
@ResponseBody
public JSONObject showList(){
List list = userService.find();
JSONObject jo = new JSONObject();
if(list!=null){
jo.put("code",0);
jo.put("msg",true);
jo.put("count",list.size());
jo.put("data",list);
}
return jo;
}
@RequestMapping("/delete")
@ResponseBody
public String deleteUserById(@RequestParam(value = "id")Integer id){
return userService.deleteUserById(id);
}
@RequestMapping("/update")
@ResponseBody
public String queryUserById(@RequestParam(value = "id")Integer id,@RequestParam(value = "name")String name){
return userService.queryUserById(id,name);
}
@RequestMapping("/add")
@ResponseBody
public String countUserBy(@RequestParam(value = "id")Integer id,@RequestParam(value = "name")String name,@RequestParam(value = "password")String password){
return userService.countUserBy(id,name,password);
}
} service
package com.song.configuration.service;
import com.song.configuration.entity.User;
import com.song.configuration.repository.UserRepositoty;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
/**
*
* User业务逻辑
*/
@Service
public class UserService {
@Autowired
private UserRepositoty userRepositoty;
public User findUserByName(String name) {
User user = null;
try {
user = userRepositoty.findByUserName(name);
} catch (Exception e) {
}
return user;
}
public List find() {
List list = null;
try {
list = userRepositoty.find();
} catch (Exception e) {
}
return list;
}
public String deleteUserById(Integer id){
int a = userRepositoty.deleteUserById(id);
return "chenggong";
}
public String queryUserById(Integer id ,String name){
int a = userRepositoty.queryUserById(id,name);
return "成功";
}
public String countUserBy(Integer id ,String name ,String password){
int a = userRepositoty.countUserBy(id,name,password);
return "成功";
}
} Repository
