原项目链接
所学知识
springboot层次
-
书写yml文件 `
spring:
datasource:
name: berry #数据库名
url: jdbc:mysql://localhost:3306/test #url
username: root #用户名
password: berry2003mysql #密码
driver-class-name: com.mysql.jdbc.Driver #数据库链接驱动mybatis:
mapper-locations: classpath:com/example/test/mapper/UserMapper.xml #配置映射文件
type-aliases-package: com.example.test.bean #配置实体类
server:
port: 8080` 功能: -
链接数据库
-
配置mybatis映射文件和实体类 //存储和管理系统内部的信息
- 书写usermapper.xml文件`<?xml version="1.0" encoding="UTF-8"?>
<select id="getInfo" parameterType="String" resultType="com.example.test.bean.UserBean">
SELECT * FROM user WHERE name = #{name} AND password = #{password}
</select>
3. 书写对应的bean
package com.example.test.bean;
public class UserBean {
private int id;
private String name;
private String password;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
}4. 书写usermapper/userservice文件
package com.example.test.mapper;
import com.example.test.bean.UserBean;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface UserMapper {
UserBean getInfo(String name,String password);
}
package com.example.test.service;
import com.example.test.bean.UserBean;
public interface UserService {
UserBean loginIn(String name,String password);
}
-
书写html文件
package com.example.test;import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping;
@Controller
public class HelloController {
@RequestMapping("/index")
public String sayHello(){
return "test";
}
}`package com.example.test;
import com.example.test.bean.UserBean;
import com.example.test.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;
@Controller
public class LoginController {
//将Service注入Web层
@Autowired
UserService userService;
@RequestMapping("/login")
public String show(){
return "login";
}
@RequestMapping(value = "/loginIn",method = RequestMethod.POST)
public String login(String name,String password){
UserBean userBean = userService.loginIn(name,password);
if(userBean!=null){
return "success";
}else {
return "error";
}
}
}`
6. 书写testapplication
package com.example.test;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.example.test.mapper")
public class TestApplication {
public static void main(String[] args) {
SpringApplication.run(TestApplication.class, args);
}
}
总结
这次项目主要靠复制代码和同学的帮助下完成,自己对于项目的理解和知识点的理解需要大力加强,建议去补充漏下的知识点后再去吃透一个完整的项目,利用思维导图和typora笔记、文档建立知识框架。
是勇敢的第一步,加油!