package one.two;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
public class AUserDao {
/*DriverManagerDataSource ds;
public AUserDao(DriverManagerDataSource ds) {
super();
this.ds = ds;
}
public AUserDao() {
super();
}
public DriverManagerDataSource getDs() {
return ds;
}
public void setDs(DriverManagerDataSource ds) {
this.ds = ds;
}*/
BasicDataSource bs;
public AUserDao() {
super();
}
public AUserDao(BasicDataSource bs) {
super();
this.bs = bs;
}
public BasicDataSource getBs() {
return bs;
}
public void setBs(BasicDataSource bs) {
this.bs = bs;
}
public void find(){
try{
Connection conn=bs.getConnection();
Statement stmt=conn.createStatement();
String strSql="select * from AUser";
ResultSet rs=stmt.executeQuery(strSql);
while(rs.next()){
int id=rs.getInt(1);
System.out.println(id);
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.Statement;
import org.apache.commons.dbcp.BasicDataSource;
import org.springframework.jdbc.datasource.DriverManagerDataSource;
public class AUserDao {
/*DriverManagerDataSource ds;
public AUserDao(DriverManagerDataSource ds) {
super();
this.ds = ds;
}
public AUserDao() {
super();
}
public DriverManagerDataSource getDs() {
return ds;
}
public void setDs(DriverManagerDataSource ds) {
this.ds = ds;
}*/
BasicDataSource bs;
public AUserDao() {
super();
}
public AUserDao(BasicDataSource bs) {
super();
this.bs = bs;
}
public BasicDataSource getBs() {
return bs;
}
public void setBs(BasicDataSource bs) {
this.bs = bs;
}
public void find(){
![微笑](http://static.blog.csdn.net/xheditor/xheditor_emot/default/smile.gif)
try{
Connection conn=bs.getConnection();
Statement stmt=conn.createStatement();
String strSql="select * from AUser";
ResultSet rs=stmt.executeQuery(strSql);
while(rs.next()){
int id=rs.getInt(1);
System.out.println(id);
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e){
System.out.println(e.getMessage());
e.printStackTrace();
}
}
}