两种方法测试spring中的jdbc

2008-02-23 10:04:23来源：互联网阅读 ()

两种方法测试spring中的JDBC

JDBC是一个非常基础的数据存取API,spring对其进行简单的封装,
下面以sqlserver中自带的pubs数据库Authors表进行测试.

1):编写Authors.Java，其每个对象对应于数据库中的一条记录

package jdbc;
public class Authors {
String lname=null;
String fname=null;
String phone=null;
String address=null;
public String getAddress() {
return address;
}
public String getFname() {
return fname;
}
public String getLname() {
return lname;
}
public String getPhone() {
return phone;
}
public void setPhone(String phone) {
this.phone = phone;
}
public void setLname(String lname) {
this.lname = lname;
}
public void setFname(String fname) {
this.fname = fname;
}
public void setAddress(String address) {
this.address = address;
}
}

2):编写AuthorsQuery类

package jdbc;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.springFramework.jdbc.object.MappingSqlQuery;
import javax.sql.DataSource;

/**
* Title: 测试spring中的jdbc
* Description: 
* Copyright: Copyright (c) 2004
* Company: 
* @author hanker
* @version 1.0
*/

public class AuthorsQuery extends MappingSqlQuery {

public AuthorsQuery(DataSource ds) {
this.setDataSource(ds);
this.setSql("SELECT * FROM authors");
compile();
}

protected Object mapRow(ResultSet rs, int rownum) throws SQLException {

Authors po = new Authors();
po.setLname(rs.getString("au_lname"));
po.setFname(rs.getString("au_fname"));
po.setPhone(rs.getString("phone"));
po.setAddress(rs.getString("address"));
return po;
}

}

3:写spring的配置文件

<?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.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName"><value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value></property>
<property name="url"><value>jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=pubs;SelectMethod=Cursor</value></property>
<property name="username"><value>sa</value></property>
<property name="password"><value></value></property>
</bean>

4:写junit进行测试

package jdbc;

import junit.framework.*;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import java.util.List;
import java.util.Map;
/**
* Title: 测试spring中的jdbc
* Description: 
* Copyright: Copyright (c) 2004
* Company: 
* @author hanker
* @version 1.0
*/

public class TestAuthorsQuery extends TestCase {
ApplicationContext ctx=null;
protected void setUp() throws Exception {
ctx
= new FileSystemXmlApplicationContext("D:\\work\\jpetstore\\src\\jdbc\\Context-jdbc.xml");
}
public void testQuery(){
System.out.println("[Test1....");
AuthorsQuery qry=(AuthorsQuery)ctx.getBean("AuthorsQuery");
List list = qry.execute();
if(list!=null&&list.size()>0){
for(int i=0;i<list.size();i ){
Authors author=(Authors)list.get(i);
StringBuffer buf=new StringBuffer();
buf.append(author.getLname())
.append("|")
.append(author.getFname())
.append("|")
.append(author.getPhone())
.append("|")
.append(author.getAddress());
System.out.println(buf.toString());
}
}