java-JDBCtemplate

用maven导入jar包

<dependencies>
     <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-web</artifactId>
      <version>4.0.2.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-webmvc</artifactId>
      <version>4.0.2.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-core</artifactId>
      <version>4.0.2.RELEASE</version>
    </dependency>
    <dependency>
      <groupId>org.springframework</groupId>
      <artifactId>spring-test</artifactId>
      <version>4.0.2.RELEASE</version>
    </dependency>
    
    <dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-aspects</artifactId>
  		<version>4.0.2.RELEASE</version>
	</dependency>
    
    <dependency>
  		<groupId>org.springframework</groupId>
  		<artifactId>spring-jdbc</artifactId>
  		<version>4.0.2.RELEASE</version>
	</dependency>
    
    <dependency>
  		<groupId>commons-dbcp</groupId>
  		<artifactId>commons-dbcp</artifactId>
  		<version>1.2.2</version>
  	</dependency>
    <dependency>
  		<groupId>mysql</groupId>
  		<artifactId>mysql-connector-java</artifactId>
  		<version>5.1.41</version>
  	</dependency>
    <dependency>
  		<groupId>org.slf4j</groupId>
  		<artifactId>slf4j-log4j12</artifactId>
  		<version>1.7.7</version>
  	</dependency>
    
    <dependency>
      <groupId>junit</groupId>
      <artifactId>junit</artifactId>
      <version>4.9</version>
    </dependency>
  </dependencies>

编写实体类

package com.aop;

import org.springframework.stereotype.Repository;


public class User1 {
   
	private int id;
	private String name;
	private Integer password;
	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 Integer getPassword() {
		return password;
	}
	public void setPassword(Integer password) {
		this.password = password;
	}
	@Override
	public String toString() {
		return "User1 [id=" + id + ", name=" + name + ", password=" + password
				+ "]";
	}
	
	
	
	
}

数据库配置文件

jdbc.Driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/student
jdbc.username=root
jdbc.password=123456789

配置文件

<?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/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
        " 
        xmlns:context="http://www.springframework.org/schema/context"    
        >
         <context:property-placeholder location="classpath:jdbc.properties"/> 
        
         <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
             <property name="driverClassName" value="${jdbc.Driver}"></property>
             <property name="url" value="${jdbc.url}"></property>
             <property name="username" value="${jdbc.username}"></property>
             <property name="password" value="${jdbc.password}"></property>
         </bean>
        
        <bean id="jdbcTemplate" class="org.springframework.jdbc.core.JdbcTemplate">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
        
        <!-- <bean id="user1" class="com.aop.User1"></bean> -->
        
        <bean id="userDao1" class="com.aop.UserDao1">
           <property name="jdbc" ref="jdbcTemplate"></property>
        </bean>
        
        </beans>

封装sql

package com.aop;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import org.springframework.jdbc.core.JdbcOperations;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.jdbc.core.RowMapper;
import org.springframework.jdbc.core.support.JdbcDaoSupport;
import org.springframework.stereotype.Service;



public class UserDao1<T>{
      
	
	private JdbcTemplate jdbc;
	
	public void create(){
		String sql="create table rm_user ( id int not null auto_increment primary key,name varchar(20),password int)";
		jdbc.update(sql);
		
	}
	
	public void add(Object... obj){
		String sql= "insert into rm_user(name,password) value(?,?)";
		jdbc.update(sql,obj);
	}
  
	public void update (Object... objects){
		String sql="update rm_user set password=? where id=?";
		jdbc.update(sql,objects);
	}
	
	public void delete (Object...obj){
		String sql="delete from rm_user where id=?";
		jdbc.update(sql, obj);
	}
	
	public void findNameById(Object...objects){
		String sql="select * from rm_user where id=?";
		User1 user = (User1) jdbc.queryForObject(sql, new RowCallbackHandler(),objects);
		System.out.println(user);
	}
	
	public void excute(String sql,Object...objects){
		jdbc.update(sql,objects);
	}
	
	public List<T> queryreturnlist(String sql,Object...objects){
		List<T> list = jdbc.query(sql,new RowCallbackHandler(),objects);
		return list;
	}
	
	public JdbcTemplate getJdbc() {
		return jdbc;
	}

	public void setJdbc(JdbcTemplate jdbc) {
		this.jdbc = jdbc;
	}
	
	class RowCallbackHandler implements RowMapper{
		
		@Override
		public User1 mapRow(ResultSet rs, int rowNum) throws SQLException {
			User1 user = new User1();
			user.setId(rs.getInt("id"));
			user.setName(rs.getString("name"));
			user.setPassword(rs.getInt("password"));
			return user;
		}
	}
}

测试类

package worlkDemo;

import java.util.List;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;





import com.aop.User1;
import com.aop.UserDao1;


@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration("classpath:springJdbc.xml")
public class TestJdbc {
   
	@Autowired
	
	private UserDao1 userDao1;
	
	
	@Test
	public void test1(){
		userDao1.create();
	}
	
	@Test
	public void test2(){
		User1 user = new User1();
		
		user.setName("li");
		user.setPassword(1234567);
		userDao1.add(user.getName(),user.getPassword());
	}
	
	@Test
	public void test3(){
		userDao1.update(12312,1);
	}
	
	@Test
	public void test4(){
		userDao1.findNameById(1);
	}
	
	@Test
	public void test5(){
		userDao1.delete(1);
	}
	
	@Test
	public void test6(){
		String sql="select * from rm_user where id=?";
		List<User1> list = userDao1.queryreturnlist(sql,2);
		System.out.println(list);
	}
}