SpringBoot+MybatisPlus+Mysql+JSP实战

create databse student;
use student;
CREATE TABLE `student` (
 `stu_id` bigint(20) NOT NULL,
 `stu_name` varchar(45) DEFAULT NULL,
 `stu_sex` varchar(6) DEFAULT NULL,
 `date` varchar(45) DEFAULT NULL,
 `room` int(2) DEFAULT NULL,
 `acadimy` varchar(45) DEFAULT NULL,
 PRIMARY KEY (`stu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

spring:
 #配置 数据库
 datasource:
  username: root #用户名
  password: akbar #密码
  #下一行中student 改为 自己建的database 
  url: jdbc:mysql://localhost:3306/student&＃63;useSSL=false&serverTimezOne=UTC&&characterEncoding=utf-8
  driver-class-name: com.mysql.cj.jdbc.Driver
#  配置JSP 路径
 mvc:
  view:
   prefix: /   
   suffix: .jsp

#mybatis-plus 打印日志 不需要手写sql 可查看把我们完成的sql 
mybatis-plus:
 configuration:
  log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
# 设置端口号
server:
 port: 8001

    
      org.springframework.boot
      spring-boot-starter-web
    

    
      mysql
      mysql-connector-java
    

    
      com.baomidou
      mybatis-plus-boot-starter
      3.0.5
    


    
    
      org.apache.velocity
      velocity-engine-core
      2.0
    

    
      org.freemarker
      freemarker
    
    
      org.apache.tomcat.embed
      tomcat-embed-jasper
    
    
    
      javax.servlet
      javax.servlet-api
    
    

    
    
      javax.servlet.jsp
      javax.servlet.jsp-api
      2.3.1
    
    

    
    
      javax.servlet
      jstl
    
    
      org.springframework.boot
      spring-boot-starter-test
      test
      
        
          org.junit.vintage
          junit-vintage-engine
        
      
    
  

set global time_zOne='+8:00';

pg.setParent("com.example.xxxx");

 gc.setAuthor("艾科"); 

dsc.setUrl("jdbc:mysql://localhost:3306/studentuseSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezOne=GMT%2B8");`

dsc.setDriverName("com.mysql.cj.jdbc.Driver"); //8.0
dsc.setDriverName("com.mysql.jdbc.Driver"); //8.0以下

 dsc.setUsername("root");
 dsc.setPassword("root"); 

strategy.setInclude("student");

public class GenerateCode {

  public static void main(String[] args) {

    AutoGenerator ag=new AutoGenerator();

//     全局配置
    GlobalConfig gc=new GlobalConfig();
    String projectPath=System.getProperty("user.dir"); //获取项目根目录
    gc.setOutputDir(projectPath+"/src/main/java"); //设置输出目录
    gc.setAuthor("艾科"); //代码注解
    gc.setOpen(false); 
    gc.setFileOverride(false); //是否覆盖（选否）不然会覆盖掉写过的代码
    gc.setServiceName("%sService"); 
    gc.setIdType(IdType.ID_WORKER); // 可以根据需求改成IdType.AUTO 或者其他
    gc.setDateType(DateType.ONLY_DATE); //Date 类型 只使用 java.util.date 代替
    ag.setGlobalConfig(gc);
//     设置数据源
    DataSourceConfig dsc=new DataSourceConfig(); //不要忘了修改数据库名称
    dsc.setUrl("jdbc:mysql://localhost:3306/student&＃63;useSSL=false&useUnicode=true&characterEncoding=utf-8&serverTimezOne=GMT%2B8");
    dsc.setDriverName("com.mysql.cj.jdbc.Driver");//8.0用com.mysql.cj.jdbc.Driver 5.7用com.mysql.jdbc.Driver
    dsc.setUsername("root");
    dsc.setPassword("root");
    dsc.setDbType(DbType.MYSQL); //数据库类型
    ag.setDataSource(dsc);

//   包的配置

    PackageConfig pg=new PackageConfig();
//     pg.setModuleName("")
    pg.setParent("com.example.xxxx"); //把xxx 改成你自己的
    pg.setEntity("entity"); //实体类创建目录
    pg.setMapper("mapper");//mapper
    pg.setController("controller");//controoler
    ag.setPackageInfo(pg);

    StrategyConfig strategy = new StrategyConfig();
    strategy.setNaming(NamingStrategy.underline_to_camel); //代码风格驼峰结构
    strategy.setColumnNaming(NamingStrategy.underline_to_camel);
    strategy.setEntityLombokModel(false);
    strategy.setRestControllerStyle(true);
    strategy.setInclude("student");   // table 名称 ，根据table 名称生成 实体类，controller,service, mmapper 
   //  strategy.setInclude("student，user,class");   // 多个表用都逗号分开
    strategy.setControllerMappingHyphenStyle(true);
    ag.setStrategy(strategy);
    ag.execute();
  }

@MapperScan("com.example.student.mapper")
@SpringBootApplication
public class StudentApplication {

  public static void main(String[] args) {
    SpringApplication.run(StudentApplication.class, args);

  }
}

 		@Autowired
  	StudentMapper studentMapper;
  
  //    Mybatis plus 查询 student 表中的数据 返回List 类型
//  相当于：  SELECT stu_id,stu_name,stu_sex,date,room,acadimy FROM student
    List list = studentMapper.selectList(null);
    list.forEach(System.out::println);

//    通过id 查询 相当于：SELECT stu_id,stu_name,stu_sex,date,room,acadimy FROM student WHERE stu_id=1
    Student student1 = studentMapper.selectById(1);
//    条件查询 查询单个 相当于：SELECT stu_id,stu_name,stu_sex,date,room,acadimy FROM student WHERE stu_name = &＃63; AND stu_sex = &＃63;
    QueryWrapper wrapper = new QueryWrapper<>();
    wrapper.eq("stu_name", "小明");
    wrapper.eq("stu_sex", "男");
    Student student2 = studentMapper.selectOne(wrapper);

    //    条件查询 查询列表 相当于：SELECT stu_id,stu_name,stu_sex,date,room,acadimy FROM student WHERE stu_id > 1

    QueryWrapper wrapper1 = new QueryWrapper<>();

    wrapper1.gt("stu_id", 1);

    Student student3 = studentMapper.selectOne(wrapper1);

    SimpleDateFormat simpleDateFormat=new SimpleDateFormat("yyyy-MM-dd");
    String date=simpleDateFormat.format(System.currentTimeMillis());
//    insert 相当于 ：
//    INSERT INTO student ( stu_id, stu_name, stu_sex, date, room, acadimy ) VALUES ( &＃63;, &＃63;, &＃63;, &＃63;, &＃63;, &＃63; ) 
//==> Parameters: 1280830334286217217(Long), aike(String), 男(String), 2020-07-08(String), 226(Integer), 计算机(String)
    Student student=new Student();
    student.setStuName("aike");
    student.setStuSex("男");
    student.setDate(date);
    student.setRoom(226);
    student.setAcadimy("计算机");
    studentMapper.insert(student);

<%@ page language="java" cOntentType="text/html; charset=utf-8"
     pageEncoding="utf-8" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>



  
  
  
  






  

    
        
          

      

        
ID
        
姓名
        
性别
        
学院
        
入学时间
        
宿舍号
        
新增学生
        
新增宿舍
      
      

            
${stu.stuId}
            
${stu.stuName}
            
${stu.stuSex}
            
${stu.acadimy}
            
${stu.date}
            
${stu.room}
            
修改宿舍
            
查询记录

          
        
      

    
  





到此这篇关于SpringBoot+MybatisPlus+Mysql+JSP实战的文章就介绍到这了,更多相关SpringBoot MybatisPlus Mysql JSP内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持！