新建springboot项目
添加依赖
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>springdemo</artifactId>
<version>0.0.1-SNAPSHOT</version>
<packaging>jar</packaging>
<name>springdemo</name>
<description>Demo project for Spring Boot</description>
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<!--<version>2.0.4.RELEASE</version>-->
<version>1.5.6.RELEASE</version>
<relativePath/> <!-- lookup parent from repository -->
</parent>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
<java.version>1.8</java.version>
</properties>
<dependencies>
<!--jpa依赖-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-jdbc</artifactId>
</dependency>
<!--mysql依赖-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<!--thymeleaf依赖 begin-->
<!--<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>-->
<!--end-->
<!--freemarker模板引擎依赖-->
<!--<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-freemarker</artifactId>
</dependency>-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!--jsp页面需要的依赖 begin-->
<!--servlet 依赖 -->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>javax.servlet-api</artifactId>
</dependency>
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>jstl</artifactId>
</dependency>
<!--<!– tomcat 的支持.–>-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-tomcat</artifactId>
</dependency>
<dependency>
<groupId>org.apache.tomcat.embed</groupId>
<artifactId>tomcat-embed-jasper</artifactId>
</dependency>
<!--end-->
<!--集成mybatis依赖 begin-->
<!--<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.2</version>
</dependency>-->
<!--end-->
</dependencies>
- application.properties文件也可以为(application.yml格式)
#修改端口号
server.port=8089
#加载驱动
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF8&useSSL=true
spring.datasource.username=root
spring.datasource.password=root
#显示sql语句
spring.jpa.show-sql=true
#mysql数据库方言
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL5Dialect
#自动更新(最好用update)
spring.jpa.hibernate.ddl-auto=update
#配置视图的前缀和后缀
spring.mvc.view.prefix=/WEB-INF/jsp/
spring.mvc.view.suffix=.jsp
- jsp页面好像必须要放在src下面的webapp文件夹下。要用jsp视图必须添加jsp的依赖。上面依赖有添加
- 操作数据库需要添加jpa依赖,第二步骤中有。想自定义方法请参考:https://www.cnblogs.com/ityouknow/p/5891443.html
public interface LoginDao extends JpaRepository<Admin,Integer> {
Admin findByUsernameAndPassword(String username,String password);
}
6.控制器层。这里省略service层
@Controller
public class LoginController {
@Autowired
private LoginService loginService;
@RequestMapping("/toHello")
public String hello(){
return "hello";
}
@RequestMapping("/save")
public ModelAndView save(Admin admin,ModelAndView model){
return model;
}
@RequestMapping("/login")
public String login(Admin admin, HttpServletRequest request){
admin = loginService.login(admin);
if(admin!=null){
request.getSession().setAttribute("admin",admin);
return "redirect:list";
}
return "redirect:hello.html";
}
@RequestMapping("/list")
public String findAll(Map map){
/**
* page:当前页
* pageSize:每页显示条数
*/
Page<Admin> adminList = loginService.findAll(0,3);
List<Admin> list = new ArrayList<>();
for (Admin a:adminList
) {
list.add(a);
}
map.put("adminList",list);
return "list";
}
@RequestMapping("/{id}/delete")
public String delete(@PathVariable("id") int id){
loginService.delete(id);
return "redirect:/list";
}
@RequestMapping("/{id}/toUpdate")
public String toUpdate(@PathVariable("id") int id,Map<String,Admin> map){
map.put("map",loginService.findById(id));
return "update";
}
@RequestMapping("/updated")
public String update(Admin admin){
loginService.update(admin);
return "redirect:list";
}
}
“`
7. 运行访问
http://localhost:8089/toHello
谢谢阅读!!!