JdbcTmplate中的update方法(代码)基础操作

User.java实体类：

package com.liu.jdbc.update;public class User {private Integer id;private String username;private String password;public Integer getId() {return id;}public void setId(Integer id) {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;}@Overridepublic String toString() {return "User [id=" + id + ", username=" + username + ", password=" + password + "]";}}

UserDao.java接口：

package com.liu.jdbc.update;public interface UserDao {public int addUser(User user);public int updateUser(User user);public int deleteUser(int id);}

UserDaoImpl.java实现类：

package com.liu.jdbc.update;import org.springframework.jdbc.core.JdbcTemplate;public class UserDaoImpl implements UserDao {//声明JdbcTemplate属性及其setter方法private JdbcTemplate jdbcTemplate;public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {this.jdbcTemplate = jdbcTemplate;}//添加方法@Overridepublic int addUser(User user) {// TODO Auto-generated method stub//定义SQL语句String sql = "insert into user(username,password) values(?,?)";//定义数组来存放SQL中的参数Object[] obj = new Object[] {user.getUsername(),user.getPassword()};//执行添加操作 返回的是受影响的行数int i = this.jdbcTemplate.update(sql, obj);return i;}//更新方法@Overridepublic int updateUser(User user) {// TODO Auto-generated method stub//定义SQL语句String sql = "update user set username = ?,password = ? where id = ?";//定义数组 存放SQL中的参数Object[] obj = new Object[] {user.getUsername(),user.getPassword(),user.getId()};//执行更新操作 返回的是受影响的行数int i = this.jdbcTemplate.update(sql, obj);return i;}//删除方法@Overridepublic int deleteUser(int id) {// TODO Auto-generated method stub//定义SQL语句String sql = "delete from user where id = ?";//执行删除操作 返回的是受影响的行数int i = this.jdbcTemplate.update(sql, id);return i;}}

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"xsi:schemaLocation="http://www.springframework.org/schema/beanshttp://www.springframework.org/schema/beans/spring-beans-4.3.xsd"><!-- 配置数据源 --><bean id = "dataSource" class = "org.springframework.jdbc.datasource.DriverManagerDataSource"><!-- 数据库驱动 --><property name="driverClassName" value = "com.mysql.jdbc.Driver"></property><!-- 数据库url --><property name="url" value = "jdbc:mysql://localhost:3306/test"></property><!-- 数据库用户名 --><property name="username" value = "root"></property><!-- 数据库密码 --><property name="password" value = "root"></property></bean><!-- 配置jdbc模板类 --><bean id = "jdbcTemplate" class = "org.springframework.jdbc.core.JdbcTemplate"><!-- 默认必须使用数据源 --><property name="dataSource" ref = "dataSource"></property></bean><!-- 定义ID为userDdao的bean --><bean id = "userDao" class = "com.liu.jdbc.update.UserDaoImpl"><property name="jdbcTemplate" ref ="jdbcTemplate"></property></bean></beans>

Test.java测试类：

package com.liu.jdbc.update;import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext;public class Test {public static void main(String args[]) {Test test = new Test();test.add(); // test.update(); // test.delete();}//添加操作public void add() {String xmlpath = "com/liu/jdbc/update/ApplicationContext.xml";ApplicationContext applicationContext = new ClassPathXmlApplicationContext(xmlpath);UserDao userDao = (UserDao) applicationContext.getBean("userDao");User user = new User();user.setUsername("张三");user.setPassword("123456");int i = userDao.addUser(user);if(i>0) {System.out.println("添加操作成功，影响了"+i+"条数据");}else {System.out.println("添加操作失败");}}//更新操作public void update() {String xmlpath = "com/liu/jdbc/update/ApplicationContext.xml";ApplicationContext applicationContext = new ClassPathXmlApplicationContext(xmlpath);UserDao userDao = (UserDao) applicationContext.getBean("userDao");User user = new User();user.setUsername("李四");user.setPassword("111111");user.setId(1);int i = userDao.updateUser(user);if(i>0) {System.out.println("更新操作成功，影响了"+i+"条数据");}else {System.out.println("更新操作失败");}}//删除操作public void delete() {String xmlpath = "com/liu/jdbc/update/ApplicationContext.xml";ApplicationContext applicationContext = new ClassPathXmlApplicationContext(xmlpath);UserDao userDao = (UserDao) applicationContext.getBean("userDao");int i = userDao.deleteUser(1);if(i>0) {System.out.println("删除操作成功，影响了"+i+"条数据");}else {System.out.println("删除操作失败");}}}

总结

以上是生活随笔为你收集整理的JdbcTmplate中的update方法(代码)基础操作的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。