// b
package dao;
import java.sql.*;
import java.util.*;
import po.Student;
public class StudentDao {
private Connection conn = null;
public void initConnection(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn = DriverManager.getConnection("jdbc:odbc:School","scott","tiger");
}catch(Exception ex){ex.printStackTrace();}
}
public ArrayList queryStuByName(String sname){
ArrayList stus = new ArrayList();
String sql = "SELECT ѧۅ,ѕĻ,єҰ,ԶʺŪՂ,ݒͥסַ FROM ѧܮ WHERE ѕĻ LIKE '%"+sname+"%'";
try {
this.initConnection();
ResultSet rs = conn.createStatement().executeQuery(sql);
while(rs.next()){
Student stu = new Student();
stu.setStuId(rs.getString("ѧۅ"));
stu.setStuName(rs.getString("ѕĻ"));
stu.setStuSex(rs.getString("єҰ"));
stu.setStuBir(rs.getString("ԶʺŪՂ"));
stu.setStuAdd(rs.getString("ݒͥסַ"));
stus.add(stu);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} finally{
this.closeConnection();
}
return stus;
}
public void closeConnection(){
try{
if(conn!=null){
conn.close();
conn=null;
}
}catch(Exception ex){ex.printStackTrace();}
}
}
// - -b