java jdbc dao层_spring dao层使用jdbcTemplte

一、实现步骤

(1)配置c3p0链接池

image.png

(2)创建service和dao配置service对象，在service注入到对象

image.png

(3)创建JdbcTemplate对象，把模版对象注入dao里面

创建模版对象

创建模版对象

把模版对象注入进dao

把模版对象注入进去

(4)向模版对象里注入dataSource

向模版对象里注入dataSource

二、代码

1、c3p0连接池配置

db.properties

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc\:mysql\://localhost\:3306/person

jdbc.user=root

jdbc.password=root

2、UserBean.java

package work.zhangdoudou.bean;

public class UserBean {

private String uname;

private String upwd;

private String uquestion;

private String uanswer;

private int u_type;

public String getUname() {

return uname;

}

public void setUname(String uname) {

this.uname = uname;

}

public String getUpwd() {

return upwd;

}

public void setUpwd(String upwd) {

this.upwd = upwd;

}

public String getUquestion() {

return uquestion;

}

public void setUquestion(String uquestion) {

this.uquestion = uquestion;

}

public String getUanswer() {

return uanswer;

}

public void setUanswer(String uanswer) {

this.uanswer = uanswer;

}

public int getU_type() {

return u_type;

}

public void setU_type(int u_type) {

this.u_type = u_type;

}

@Override

public String toString() {

// TODO Auto-generated method stub

return super.toString();

}

}

3、UserService.java

package work.zhangdoudou.Service;

import work.zhangdoudou.Dao.UserDao;

import work.zhangdoudou.bean.UserBean;

public class UserService {

private UserDao userDao;

public void setUserDao(UserDao userDao) {

this.userDao = userDao;

}

//添加操作

public void addUser(UserBean userBean) {

userDao.addUser(userBean);

}

}

4、UserDao.java

package work.zhangdoudou.Dao;

import org.springframework.jdbc.core.JdbcTemplate;

import work.zhangdoudou.bean.UserBean;

public class UserDao {

//得到jdbcTemplate对象

private JdbcTemplate jdbcTemplate;

public void setJdbcTemplate(JdbcTemplate jdbcTemplate) {

this.jdbcTemplate = jdbcTemplate;

}

public void addUser(UserBean userBean) {

String sql="INSERT INTO users(u_name,u_pwd) VALUES(?,?)";

Object []date = {userBean.getUname(),userBean.getUpwd()};

jdbcTemplate.update(sql,date);

}

}

5、applicationContext.xml

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-4.0.xsd">

6、TestUser.java

package work.zhangdoudou.Test;

import static org.junit.Assert.*;

import org.junit.Test;

import org.springframework.context.ApplicationContext;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import work.zhangdoudou.Service.UserService;

import work.zhangdoudou.bean.UserBean;

public class TestUset {

@Test

public void test() {

ApplicationContext context=new ClassPathXmlApplicationContext("applicationContext.xml");

UserService userService=(UserService)context.getBean("userService");

UserBean userBean=(UserBean)context.getBean("userBean");

userBean.setUname("zhangsan");

userBean.setUpwd("123");

userService.addUser(userBean);

}

}

三、运行结果

image.png