studentabilitydao.java

来自「功能是公安和学校的管理系统,用struts+hibernate+spring等匡」· Java 代码 · 共 42 行

package com.comingnet.bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

import com.db.DBUtils;

public class StudentAbilityDAO {
	private Connection conn ;
	private PreparedStatement pstmt ;
	private ResultSet rs ;
	
	public StudentAbility queryById(int stuid){
		String sqlStr = "select * from stu_ability where stuid=?" ;
		StudentAbility sa = new StudentAbility() ;
		try{
			conn = DBUtils.getConnection() ;
			pstmt = conn.prepareStatement(sqlStr) ;
			pstmt.setInt(1, stuid) ;
			rs = pstmt.executeQuery() ;
			while (rs.next()){
				sa.setAbid(rs.getInt("abid")) ;
				sa.setStuid(rs.getInt("stuid")) ;
				sa.setAbdy(rs.getString("abdy")) ;
				sa.setAbmy(rs.getString("abmy")) ;
				sa.setAbty(rs.getString("abty")) ;
				sa.setAbzh(rs.getString("abzh")) ;
			}
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(pstmt) ;
		}catch(Exception e){
			System.out.println("StudentAbilityDAO.exception------------->"+e) ;
		}finally{
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(pstmt) ;
			DBUtils.closeConnection(conn) ;
		}
		return sa ;
	}
}