在Sybase数据库中应用DBUtils

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.List;

import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;

import com.thtf.common.util.DBUtil;

import com.test.Person;

public class TestDBUtils {


public static void main(String[] args) {

try {

DBUtil.loadDriver("com.sybase.jdbc3.jdbc.SybDriver");
Connection conn = DriverManager.getConnection( "jdbc:sybase:Tds:10.2.128.2:6688/database?charset=cp936", "name", "pass" );
//database为数据源，我开始把他弄成了数据库服务器的名字，导致一直找不到Person表。所以database一定要写成你的数据源

// DBUtil.loadDriver("com.mysql.jdbc.Driver");
// Connection conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","root");

QueryRunner run=new QueryRunner();

BeanListHandler<Person> h= new BeanListHandler<Person>(Person.class);

List<Person> list=run.query(conn, "select * from Person", h);

for(Person s:list){
System.out.println(s.getName()+":"+s.getSex());
}

System.out.println(list.size());

DBUtil.close(conn);

} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}


}

}