013. Spring JdbcTemplate访问数据库
来源:互联网 发布:网络部主要职责 编辑:程序博客网 时间:2024/05/21 22:38
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.JdbcTemplate;import org.springframework.jdbc.core.RowCallbackHandler;import com.spring.dao.UserDao;import com.spring.model.UserModel;public class UserDaoImp implements UserDao{ private JdbcTemplate jdbcTemplate; public void setJdbcTemplate(JdbcTemplate jdbcTemplate) { this.jdbcTemplate = jdbcTemplate; } @Override public UserModel getUser(int id) { String sql = "select id, name, pswd from tb_user where id=?"; UserModel user = new UserModel(); jdbcTemplate.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"; jdbcTemplate.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 jdbcTemplate.update(sql, params); } @Override public int updateUser(UserModel user) { String sql = "update tb_user set name=?, pswd=? where id=?"; return jdbcTemplate.update(sql, user.getName(), user.getPswd(), user.getId()); } @Override public int deleteUser(int id) { String sql = "delete from tb_user where id=?"; return jdbcTemplate.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="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate"> <property name="dataSource" ref="dataSource"></property> </bean> <bean id="userDao" class="com.spring.dao.imp.UserDaoImp"> <property name="jdbcTemplate" ref="jdbcTemplate"></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
- 013. Spring JdbcTemplate访问数据库
- Spring Boot 配置JdbcTemplate访问数据库
- Spring Boot中使用JdbcTemplate访问数据库
- Spring Boot中使用JdbcTemplate访问数据库
- spring boot(6)-JdbcTemplate访问数据库
- Spring Boot中使用JdbcTemplate访问数据库
- Spring Boot中使用JdbcTemplate访问数据库
- spring boot(6)-JdbcTemplate访问数据库
- Spring Boot中使用JdbcTemplate访问数据库
- spring 事务管理 1(使用spring的JdbcTemplate访问数据库)
- 使用jdbctemplate访问数据库
- Spring访问数据库--DataSource方式和JdbcTemplate方式
- Spring 数据源连接池 数据库访问哲学jdbcTemplate
- spring boot 教程(五)使用JdbcTemplate访问数据库
- spring jdbcTemplate连接数据库
- Spring 之数据访问 JdbcTemplate
- Spring使用JdbcTemplate操作数据库
- Spring使用JdbcTemplate操作数据库
- js基础知识
- 阿里百川SDK初始化失败,SecurityGuard init error
- Darwin 框架概述
- RFCOMM
- Windows Socket 编程_ 简单的服务器/客户端程序
- 013. Spring JdbcTemplate访问数据库
- Linq一些方法整理
- 阿里云centos系统安装svn,tomcat,mysql外网连接不上问题解决
- 读书笔记-大型网站系统与Java中间件9
- UVa 725(简单枚举)
- chromium中的GN构建系统
- 下拉框中使用json格式数据并且支持模糊搜索
- vue脚手架项目打包后路由视图不显示问题
- INTP