以webService为客户端获取List泛型结果集

 

首先搭建好webService，添加XFire1.2Core Libraries 和XFire1.2HTTP Client Libraries，连接上数据库，下例以oracle为数据库。

连接Oralce，连接类为DBConnection.java

package com.xtgd.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class DBConnection {
	
	private String driver="oracle.jdbc.driver.OracleDriver";
	
	private String url="jdbc:oracle:thin:@localhost:1521:orcl";
	
	private String username="scott";
	
	private String pwd="tiger";
	
	private Connection conn=null;
	
	
	public Connection getConn(){
		try {
			Class.forName(driver);
			conn=DriverManager.getConnection(url,username,pwd);
		} catch (Exception e) {
			e.printStackTrace();
		}
		return conn;
	}
	
	
	public void closeConn(ResultSet rs,PreparedStatement ps,Connection conn){
		try {
			if(rs!=null){
				rs.close();
			}
			if(rs!=null){
				rs.close();
			}
			if(rs!=null){
				rs.close();
			}
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
	
		
		
	

}

 

写好UserDao方法 UserDao.java

 

package com.xtgd.test;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.List;

public class UserDao
{
	DBConnection b = new DBConnection();

	private PreparedStatement pre = null;

	private ResultSet rs = null;

	private Connection conn = null;

	/*
	 * 全查询
	 */

	public List<TUser> getAll()
	{
		List<TUser> ar = new ArrayList<TUser>();
		try
		{
			String sql = "select * from t_user";
			conn = b.getConn();
			pre