Spring使用JdbcTemplate操作数据库
首先,假设如下SQL表中有数据username=test1,passwd=test1,address=test1
CREATE TABLE `login` (
? `username` varchar(10) default NULL,
? `passwd` varchar(10) default NULL,
? `address` varchar(10) default NULL
) ENGINE=InnoDB DEFAULT CHARSET=gb2312;
?
配置文件:
package SpringJDBCSupport.ReadData;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+"ReadData"+File.separator+"hello.xml"; factory=new XmlBeanFactory(new FileSystemResource(filePath)); PersonDAO personDAO=(PersonDAO)factory.getBean("personDAO"); /**//* * 准备数据 */ Person p1=new Person("test1","test1","test1"); Person p2=new Person("test2","test2","test2"); Person p3=new Person("test3","test3","test3"); Person p4=new Person("test4","test4","test4"); Person p5=new Person("test5","test5","test5"); List persons=new ArrayList(); persons.add(p3); persons.add(p4); persons.add(p5); //使用jdbcTemplate.update方式 // personDAO.insertPersonUseUpdate(p1); //使用jdbcTemplate.execute方式 // personDAO.insertPersonUseExecute(p2); // //使用jdbcTemplate批处理方式 // personDAO.updatePersonUseBatchUpdate(persons); //使用RowCallbackHandler执行一次查询,并打印person信息 System.out.println(personDAO.getPersonByRowCallbackHandler("test1")); } }
?
运行结果:
test1-test1-test1