<? xml?version="1.0"?encoding="UTF-8" ?>
<! DOCTYPE?beans?PUBLIC?"-//SPRING//DTD?BEAN//EN"?"http://www.springframework.org/dtd/spring-beans.dtd"? >
< beans >
? < bean? id ="dataSource" ?class ="org.apache.commons.dbcp.BasicDataSource" >
??? < property? name ="driverClassName" >
????? < value > com.mysql.jdbc.Driver </ value >
??? </ property >
??? < property? name ="url" >
????? < value > jdbc:mysql://localhost:3306/javaee </ value >
??? </ property >
??? < property? name ="username" >
????? < value > root </ value >
??? </ property >
??? < property? name ="password" >
????? < value > 1234 </ value >
??? </ property >
? </ bean >
? < bean? id ="jdbcTemplate" ?class ="org.springframework.jdbc.core.JdbcTemplate" >
??? < property? name ="dataSource" >
????? < ref? local ="dataSource" />
??? </ property >
? </ bean >

< bean? id ="personDAO" ?class ="SpringJDBCSupport.WriteData.PersonDAO" >
?? < property? name ="jdbcTemplate" >
???? < ref? local ="jdbcTemplate" />
?? </ property >
</ bean > ?
</ beans >

package ?SpringJDBCSupport.WriteData;
import ?com.mysql.jdbc.Driver;
public ? class ?Person? ... {
?? private ?String?name;
?? private ?String?password;
?? private ?String?address;
?? public ?Person(String?name,String?password,String?address) ... {
?????? this .name = name;
?????? this .password = password;
?????? this .address = address;
??}
public ?String?getAddress()? ... {
???? return ?address;
}
public ? void ?setAddress(String?address)? ... {
???? this .address? = ?address;
}
public ?String?getName()? ... {
???? return ?name;
}
public ? void ?setName(String?name)? ... {
???? this .name? = ?name;
}
public ?String?getPassword()? ... {
???? return ?password;
}
public ? void ?setPassword(String?password)? ... {
???? this .password? = ?password;
}
}

package ?SpringJDBCSupport.WriteData;

import ?java.sql.PreparedStatement;
import ?java.sql.SQLException;
import ?java.sql.Types;
import ?java.util.List;

import ?org.springframework.jdbc.core.BatchPreparedStatementSetter;
import ?org.springframework.jdbc.core.JdbcTemplate;

public ? class ?PersonDAO? ... {
?? private ?JdbcTemplate?jdbcTemplate;

public ?JdbcTemplate?getJdbcTemplate()? ... {
???? return ?jdbcTemplate;
}

public ? void ?setJdbcTemplate(JdbcTemplate?jdbcTemplate)? ... {
???? this .jdbcTemplate? = ?jdbcTemplate;
}

public ? int ?insertPersonUseUpdate(Person?person) ... {
????String?sql = " insert?into?login?values(?,?,?) " ;
????Object[]?params = new ?Object[] ... {
????????????person.getName(),
????????????person.getPassword(),
????????????person.getAddress()
????} ;
???? return ? this .getJdbcTemplate().update(sql,params);
}
public ? int ?insertPersonUseExecute(Person?person) ... {
????String?sql = " insert?into?login?values(?,?,?) " ;
????Object[]?params = new ?Object[] ... {
????????????person.getName(),
????????????person.getPassword(),
????????????person.getAddress()
????} ;
???? int []?types = new ? int [] ... {
????????????Types.VARCHAR,
????????????Types.VARCHAR,
????????????Types.VARCHAR
????} ;
???? return ? this .getJdbcTemplate().update(sql,params,types);
}
public ? int []?updatePersonUseBatchUpdate(? final ?List?persons) ... {
????String?sql = " insert?into?login?values(?,?,?) " ;
????BatchPreparedStatementSetter?setter = null ;
????setter = new ?BatchPreparedStatementSetter() ... {
???????? public ? int ?getBatchSize() ... {
???????????? return ?persons.size();
????????}
???????? public ? void ?setValues(PreparedStatement?ps, int ?index)? throws ?SQLException ... {
????????????Person?person = (Person)persons.get(index);
????????????ps.setString( 1 ,person.getName());
????????????ps.setString( 2 ,person.getPassword());
????????????ps.setString( 3 ,person.getAddress());
????????}
????} ;
???? return ? this .getJdbcTemplate().batchUpdate(sql,setter);
}
??
}

package ?SpringJDBCSupport.WriteData;

import ?java.io.File;
import ?java.util.ArrayList;
import ?java.util.List;

import ?org.springframework.beans.factory.BeanFactory;
import ?org.springframework.beans.factory.xml.XmlBeanFactory;
import ?org.springframework.core.io.FileSystemResource;

public ? class ?TestJDBCTemplate? ... {

???? public ? static ?String?filePath = "" ;
???? public ? static ?BeanFactory?factory = null ;
???? public ? static ? void ?main(String[]?args)? ... {
????????filePath = System.getProperty( " user.dir " ) + File.separator + " SpringJDBCSupport " + File.separator + " WriteData " + File.separator + " hello.xml " ;
????????factory = new ?XmlBeanFactory( new ?FileSystemResource(filePath));
????????PersonDAO?personDAO = (PersonDAO)factory.getBean( " personDAO " );
???????? /**/ /*
?????????*?準備數據
????????? */
????????Person?p1 = new ?Person( " test1 " , " test1 " , " test1 " );