studentdao.java

来自「郭克华j2ee高级框架实战教学视频源代码 这个是比较值得一看的 由郭克华博士」· Java 代码 · 共 52 行

package dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.util.ArrayList;

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(Exception ex){ex.printStackTrace();}
		finally{
			this.closeConnection();
		}
		return stus;
	}
	
	public void closeConnection(){
		try{
			if(conn!=null){
				conn.close();
				conn = null;
			}
		}catch(Exception ex){ex.printStackTrace();}
	}
}