//b

// 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