1.数据源使用的是druid,maven地址
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.31</version>
</dependency>
2.配置application.properties的数据源配置
spring.datasource.name:test
spring.datasource.url:jdbc:mysql://localhost:3306/sys?useUnicode=true&characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull
spring.datasource.username:root
spring.datasource.password:
#\u4F7F\u7528druid\u6570\u636E\u6E90
spring.datasource.type:com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name:com.mysql.jdbc.Driver
spring.datasource.filters:stat
spring.datasource.maxActive:20
spring.datasource.initialSize:1
spring.datasource.maxWait:60000
spring.datasource.minIdle:1
spring.datasource.timeBetweenEvictionRunsMillis:60000
spring.datasource.minEvictableIdleTimeMillis:300000
spring.datasource.validationQuery:select 'x'
spring.datasource.testWhileIdle:true
spring.datasource.testOnBorrow:false
spring.datasource.testOnReturn:false
spring.datasource.poolPreparedStatements:true
spring.datasource.maxOpenPreparedStatements:20
springboot会自动加载spring.datasource.*相关配置,数据源就会自动注入到sqlSessionFactory中.
3.在启动类中添加对mapper包扫描@MapperScan
@MapperScan("com.java.llkj.dao")
4.编写实体类
public class Area {
private int id;
private String name;
private String code;
private String remark;
private int prentid;
private String fullname;
getset...
}
5.编写Mapper类,
public interface AreaDao {
//查询列表
@Select("SELECT * FROM Area")
List<Area> getAll();
//按id查询
@Select("SELECT * FROM Area WHERE ID = #{id}")
Area getAreaById(long id);
//新增
@Insert("INSERT INTO Area(name) VALUES(#{name})")
int insert(Area area);
//按id修改
@Update("UPDATE Area SET name=#{name} WHERE id =#{id}")
int update(Area user);
//按id删除
@Delete("DELETE FROM Area WHERE id =#{id}")
int delete(Long id);
}
6.使用
@Autowired
private AreaDao areaDao;
@RequestMapping("/")
String home() {
List<Area> list= areaDao.getAll();
Area area=new Area();
area.setName("测试");
int res= areaDao.insert(area);
Area area2=areaDao.getAreaById(26);
area2.setName("测试2");
res=areaDao.update(area2);
res=areaDao.delete(area2.getId());
return "index";
}
这种方式全部使用注解的方式,比较简洁。注意点是实体类中的字段都是一一对应数据库中的字段,当数据库中的字段和实体类的字段不一致时需要使用下面这个注解标识
@Select("SELECT * FROM Area")
@Results({@Result(property="remark",column="remark_s")})
List<Area> getAll();