1.导入Jar包
2.创建一个接口dao类,一个实现类,一个服务功能类,一个测试类,一个主配置文件
3.主配置文件中需要添加命名空间util、aop、context。开启组件扫描,因为创建对象是通过注解方式,配置好数据库连接池,配置好jdbctemplate
<?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"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:util="http://www.springframework.org/schema/util"
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/util http://www.springframework.org/schema/util/spring-util.xsd
http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">
<!--开启组件扫描-->
<context:component-scan base-package="com"></context:component-scan>
<!--配置数据库连接池-->
<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" >
<property name="driverClassName" value="com.mysql.jdbc.Driver"></property>
<property name="url" value="jdbc:mysql://localhost:3306/six"></property>
<property name="username" value="root"></property>
<property name="password" value="123456"></property>
</bean>
<!--配置JDBCtemplate-->
<bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
<!--注入datesource-->
<property name="dataSource" ref="dataSource"></property>
</bean>
</beans>
4.服务器类的配置
package com.service;
import com.dao.UserDao;
import com.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
//创建对象
@Service
public class UserService {
//自动填充
@Autowired
private UserDao userDao;
//添加的方法
public void addUser(User u){
userDao.add(u);
}
//删除的方法
public void deleteUser(int id ){
userDao.delete(id);
}
//修改的方法
public void updateUser(User u){
userDao.updata(u);
}
}
5.dao接口的配置
package com.dao; import com.entity.User; public interface UserDao { void add(User u); void delete(int id); void updata(User u); }
6.实现类的配置
package com.impl;
import com.dao.UserDao;
import com.entity.User;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Repository;
//创建持久层对象
@Repository
public class UserDaoImpl implements UserDao{
@Autowired
private JdbcTemplate jdbcTemplate;
//新增的方法
@Override
public void add(User u) {
//创建sql语句
String sql = "insert into user values(?,?,?)";
//调用方法实现
int insert = jdbcTemplate.update(sql, u.getId(), u.getName(), u.getSex());
System.out.println("添加" +
"了"+insert+"行数据");
}
//删除的方法
@Override
public void delete(int id) {
//创建sql语句
String sql = "delete from user where id = ?";
//调用方法
int delete = jdbcTemplate.update(sql, id);
System.out.println("删除了"+delete+"行数据");
}
//修改的方法
@Override
public void updata(User u) {
//创建sql语句
String sql = "UPDATE USER SET name = ? ,sex = ? where id = ?";
//调用方法实现
int update = jdbcTemplate.update(sql, u.getName(), u.getSex(),u.getId() );
System.out.println("修改了"+update+"行数据");
}
}
7.测试类进行测试
package com.test;
import com.service.UserService;
import com.entity.User;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;
public class Test {
public static void main(String[] args) {
ApplicationContext context = new ClassPathXmlApplicationContext("bean.xml");
UserService userService = context.getBean("userService", UserService.class);
//执行新增方法
User u = new User(111,"张三","男");
userService.addUser(u);
//执行修改方法
u = new User(111,"张三","女");
userService.updateUser(u);
//执行删除方法
userService.deleteUser(111);
}
}
8. 结果
七月 12, 2022 10:26:25 上午 com.alibaba.druid.pool.DruidDataSource info
信息: {dataSource-1} inited
添加了1行数据
修改了1行数据
删除了1行数据