文章目录
前言:当控制台报
Unsupported class file major version 61
错误时,建议更换JDK版本,换成JDK16以前的版本
父文章:Spring对数据持久化的支持
JdbcTemplate概述
Spring提供了工具类JdbcTemplate,该类对jdbc的操作进行了轻量级别的封装,包含了操作数据库的各种方法。该类包含一个dataSource属性(数据源),只有在初始化数据源的情况下才能调用JdbcTemplate的方法。
-
数据源:数据源为主流连接池的数据源对象(例如C3P0,DBCP数据库连接池),因此在使用JdbcTemplate前,要创建数据源对象。
-
JdbcTemplate的优点:
优点:运行期:高效、内嵌Spring框架中、支持基于AOP的声明式事务,可节省大量的冗余代码(创建连接,关闭连接,处理异常),只关注业务逻辑即可。
一、导入坐标
- 这边呢有用的没用的我都导了几个,之前有bug的时候加入的
<dependencies>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>3.8.1</version>
<scope>test</scope>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.17</version>
</dependency>
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.28</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>5.2.10.RELEASE</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.0.2.RELEASE</version>
</dependency>
</dependencies>
二、在resource资源包下新建applicationContext.xml并配置
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd http://www.springframework.org/schema/aop https://www.springframework.org/schema/aop/spring-aop.xsd">
<context:property-placeholder location="jdbc.properties"/>
<context:component-scan base-package="com.wk"></context:component-scan>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="${jdbc.driver}"/>
<property name="jdbcUrl" value="${jdbc.url}"/>
<property name="user" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<constructor-arg index="0" ref="dataSource"></constructor-arg>
</bean>
</beans>
在resource资源包下新建jdbc.properties存入MySQL的连接数据
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/test
jdbc.username=root
jdbc.password=123
三、建包测试一下
1、在pojo包下建User类
public class User {
private String username;
private String password;
private String email;
private String phone;
private String birth;
private Integer id;
public User() {
}
public User(String username, String password, String email, String phone, String birth, Integer id) {
this.username = username;
this.password = password;
this.email = email;
this.phone = phone;
this.birth = birth;
this.id = id;
}
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public String getEmail() {
return email;
}
public void setEmail(String email) {
this.email = email;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public String getBirth() {
return birth;
}
public void setBirth(String birth) {
this.birth = birth;
}
public Integer getId() {
return id;
}
public void setId(Integer id) {
this.id = id;
}
@Override
public String toString() {
return "User{" +
"username='" + username + '\'' +
", password='" + password + '\'' +
", email='" + email + '\'' +
", phone='" + phone + '\'' +
", birth='" + birth + '\'' +
", id=" + id +
'}';
}
}
2、在UserDao接口下定义增删改查方法
public interface UserDao {
//插入一条用户信息
void adduser(User user);
//查找用户信息
List<User> queryuser(String username);
//修改用户信息
int updateuser(String username,int id);
//删除用户
int deleteuser(String username);
}
3、在UserDaoImpl中实现Dao接口中的方法
public class UserDaoImpl implements UserDao {
@Autowired
private JdbcTemplate jdbcTemplate;
@Override
public void adduser(User user) {
String sql="insert into user(username,password) value(?,?)";
int update = jdbcTemplate.update(sql, user.getUsername(), user.getPassword());
System.out.println(update);
}
@Override
public List<User> queryuser(String username) {
String sql = "select * from user where username=?";
//创建一个新的BeanPropertyRowMapper对象
RowMapper<User> rowMapper = new BeanPropertyRowMapper<User>(User.class);
//将id绑定到SQL语句中,并通过RowMapper返回一个Object类型的单行记录
List<User> query = jdbcTemplate.query(sql, rowMapper, username);
return query;
}
@Override
public int updateuser(String username,int id) {
String sql="update user set username=? where id=?";
int update = jdbcTemplate.update(sql, username,id);
return update;
}
@Override
public int deleteuser(String username) {
String sql = "delete from user where username=?";
int update = jdbcTemplate.update(sql, username);
return update;
}
}
4、编写测试类
public class Test {
public static void main(String[] args) {
ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");
UserDao userDao= (UserDao) ctx.getBean("userDaoImpl");
User user = new User();
user.setUsername("北条");
user.setPassword("123123");
userDao.adduser(user);
// List<User> queryuser = userDao.queryuser("史蒂夫");
// System.out.println(queryuser);
// int ikun = userDao.updateuser("ikun", 2);
// if (ikun==0){
// System.out.println("信息修改失败");
// }else {
// System.out.println("修改成功");
// }
//
// int kun = userDao.deleteuser("小黑子");
// if (kun==0){
// System.out.println("删除失败");
// }else {
// System.out.println("删除成功");
// }
}
}