014. Spring JdbcDaoSupport访问数据库
来源:互联网 发布:java获取进程端口号 编辑:程序博客网 时间:2024/06/05 03:10
1、创建Java项目:File -> New -> Java Project
2、项目结构
3、必要jar包
4、创建数据库,使用MySQL数据库
SET NAMES GBK;CREATE DATABASE IF NOT EXISTS `db_spring`;USE `db_spring`;DROP TABLE IF EXISTS `tb_user`;CREATE TABLE `tb_user`( `id` INTEGER PRIMARY KEY NOT NULL, `name` VARCHAR(16) NOT NULL, `pswd` VARCHAR(32) NOT NULL)ENGINE=InnoDB DEFAULT CHARSET=utf8;INSERT INTO `tb_user`(`id`, `name`, `pswd`) VALUES(146, '吴腾辉', '105032014146'), (148, '吴钟灯', '105032014148');
5、创建UserModel实体类UserModel.java
package com.spring.model;public class UserModel { private int id; private String name; private String pswd; public UserModel() { super(); } public UserModel(int id, String name, String pswd) { super(); this.id = id; this.name = name; this.pswd = pswd; } public int getId() { return id; } public void setId(int id) { this.id = id; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPswd() { return pswd; } public void setPswd(String pswd) { this.pswd = pswd; } @Override public String toString() { return "UserModel [id=" + id + ", name=" + name + ", pswd=" + pswd + "]"; }}
6、创建UserDao接口UserDao.java
package com.spring.dao;import java.util.List;import com.spring.model.UserModel;public interface UserDao { public UserModel getUser(int id); public List<UserModel> getUsers(); public int insertUser(UserModel user); public int updateUser(UserModel user); public int deleteUser(int id);}
7、创建UserDaoImp实现类UserDaoImp.java
package com.spring.dao.imp;import java.sql.ResultSet;import java.sql.SQLException;import java.util.LinkedList;import java.util.List;import org.springframework.jdbc.core.RowCallbackHandler;import org.springframework.jdbc.core.support.JdbcDaoSupport;import com.spring.dao.UserDao;import com.spring.model.UserModel;public class UserDaoImp extends JdbcDaoSupport implements UserDao{ @Override public UserModel getUser(int id) { String sql = "select id, name, pswd from tb_user where id=?"; UserModel user = new UserModel(); this.getJdbcTemplate().query(sql, new RowCallbackHandler(){ @Override public void processRow(ResultSet rs) throws SQLException { user.setId(rs.getInt("id")); user.setName(rs.getString("name")); user.setPswd(rs.getString("pswd")); } }, id); return user; } @Override public List<UserModel> getUsers() { List<UserModel> userList = new LinkedList<UserModel>(); String sql = "select id, name, pswd from tb_user"; this.getJdbcTemplate().query(sql, new RowCallbackHandler(){ UserModel user = null; @Override public void processRow(ResultSet rs) throws SQLException { user = new UserModel(); user.setId(rs.getInt("id")); user.setName(rs.getString("name")); user.setPswd(rs.getString("pswd")); userList.add(user); } }); return userList; } @Override public int insertUser(UserModel user) { String sql = "insert into tb_user(id, name, pswd) values(?,?,?)"; Object params[] = new Object[]{user.getId(), user.getName(), user.getPswd()}; return this.getJdbcTemplate().update(sql, params); } @Override public int updateUser(UserModel user) { String sql = "update tb_user set name=?, pswd=? where id=?"; return this.getJdbcTemplate().update(sql, user.getName(), user.getPswd(), user.getId()); } @Override public int deleteUser(int id) { String sql = "delete from tb_user where id=?"; return this.getJdbcTemplate().update(sql, id); }}
8、创建UserService接口UserService.java
package com.spring.service;import java.util.List;import com.spring.model.UserModel;public interface UserService { public UserModel getUser(int id); public List<UserModel> getUsers(); public int insertUser(UserModel user); public int updateUser(UserModel user); public int deleteUser(int id);}
9、创建UserServiceImp实现类UserServiceImp.java
package com.spring.service.imp;import java.util.List;import com.spring.dao.UserDao;import com.spring.model.UserModel;import com.spring.service.UserService;public class UserServiceImp implements UserService { private UserDao userDao; public void setUserDao(UserDao userDao) { this.userDao = userDao; } @Override public UserModel getUser(int id) { return userDao.getUser(id); } @Override public List<UserModel> getUsers() { return userDao.getUsers(); } @Override public int insertUser(UserModel user) { return userDao.insertUser(user); } @Override public int updateUser(UserModel user) { return userDao.updateUser(user); } @Override public int deleteUser(int id) { return userDao.deleteUser(id); }}
10、创建数据库配置文件jdbc.properties
jdbc.driverClassName=com.mysql.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/db_springjdbc.username=rootjdbc.password=
11、创建spring配置文件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"> <context:property-placeholder location="jdbc.properties"/> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="${jdbc.driverClassName}"/> <property name="url" value="${jdbc.url}"/> <property name="username" value="${jdbc.username}"/> <property name="password" value="${jdbc.password}"/> </bean> <bean id="userDao" class="com.spring.dao.imp.UserDaoImp"> <property name="dataSource" ref="dataSource"></property> </bean> <bean id="userService" class="com.spring.service.imp.UserServiceImp"> <property name="userDao" ref="userDao"></property> </bean></beans>
12、创建Spring测试类SpringUnit.java
package com.spring.junit;import java.util.List;import org.junit.After;import org.junit.Before;import org.junit.Test;import org.springframework.context.support.ClassPathXmlApplicationContext;import com.spring.model.UserModel;import com.spring.service.UserService;public class SpringUnit { private ClassPathXmlApplicationContext ctx = null; private UserService userService = null; @Before public void setUp() throws Exception { ctx = new ClassPathXmlApplicationContext("applicationContext.xml"); userService = (UserService) ctx.getBean("userService"); } @After public void tearDown() throws Exception { ctx.close(); } @Test public void test() { testInsert(); testUpdate(); testDelete(); testGetUsers(); } private void testInsert() { userService.insertUser(new UserModel(147, "吴志祥", "105032014140")); System.out.println(userService.getUser(147).toString()); } private void testUpdate() { userService.updateUser(new UserModel(147, "吴志祥", "105032014147")); System.out.println(userService.getUser(147).toString()); } private void testDelete() { userService.deleteUser(147); System.out.println(userService.getUser(147).toString()); } private void testGetUsers() { List<UserModel> userList = userService.getUsers(); for(UserModel user: userList) { System.out.println(user.toString()); } }}
13、测试结果
... 省略Spring日志信息 ...UserModel [id=147, name=吴志祥, pswd=105032014140]UserModel [id=147, name=吴志祥, pswd=105032014147]UserModel [id=0, name=null, pswd=null]UserModel [id=146, name=吴腾辉, pswd=105032014146]UserModel [id=148, name=吴钟灯, pswd=105032014148]... 省略Spring日志信息 ...
阅读全文
0 0
- 014. Spring JdbcDaoSupport访问数据库
- Spring+JdbcDaoSupport
- Spring JdbcDaoSupport
- Spring + JdbcTemplate + JdbcDaoSupport examples
- Spring JdbcDaoSupport的使用
- Spring + JdbcTemplate + JdbcDaoSupport
- Spring中的JdbcDaoSupport
- Spring + JdbcTemplate + JdbcDaoSupport
- Spring + JdbcTemplate + JdbcDaoSupport examples
- Spring + JdbcTemplate + JdbcDaoSupport examples
- Spring - JdbcTemplate 和 JdbcDaoSupport
- Spring JdbcDaoSupport Tutorial
- spring使用JdbcTemplate、JdbcDaoSupport模板类的数据源配置及db访问
- Spring + JdbcTemplate + JdbcDaoSupport + HibernateDaoSupport examples
- Spring + JdbcTemplate + JdbcDaoSupport。JdbcTemplate 和 JdbcDaoSupport的不同
- Spring中JdbcDaoSupport的DataSource注入问题
- Spring JdbcDaoSupport的注入问题JdbcTemple
- Spring 和JdbcTemplate 和 JdbcDaoSupport方式对比
- Android拖动,缩放,自定义内容,控件制作(可拖动缩放RelativeLayout定制)
- mycat实现mysql读写分离
- "mkimage" command not found
- MAC 上安装LibSVM的python接口
- 欢迎使用CSDN-markdown编辑器
- 014. Spring JdbcDaoSupport访问数据库
- window 安装anaconda(内置numpy与scipy) 可以作为科学计算使用
- javabean
- Linux下安装多版本的Opencv
- 列车售票的可线性化编程-Java
- C语言——数组与指针进阶(二)
- linux部署服务器遇到的问题(四)
- RadioButton和CheckBox用法及监听
- 消息队列activemq整合spring发送端和接收端配置