resourcetypedao.java

功能是公安和学校的管理系统,用struts+hibernate+spring等匡架组成,在eclepse就能编译

package com.comingnet.bean;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import com.db.DBUtils;
import com.db.KeyGenerator;


public class ResourceTypeDAO {
	Connection conn = null ;
	PreparedStatement stmt = null ;
	ResultSet rs = null ;
	 
	
	public ArrayList<ResourceType> queryAll(int pageno, int recordPerPage){
		ResourceType rt = null ;
		ArrayList<ResourceType> resultList = new ArrayList<ResourceType>() ;
		String sqlStr ; 
		sqlStr  ="select top "+recordPerPage+" * from m_zylb where lbid not in (select top "+(pageno-1)*recordPerPage+" lbid from m_zylb order by lbid) order by lbid" ;
		Statement stmt1 = null ;
		
		try {
			conn = DBUtils.getConnection() ;
			stmt1 = conn.createStatement() ;
			rs = stmt1.executeQuery(sqlStr) ;
			
			while(rs.next()){
				rt = new ResourceType() ;
				rt.setLbid(rs.getInt("lbid")) ;
				rt.setXxbh(rs.getInt("xxbh"))  ;
				rt.setLbmc(rs.getString("lbmc")) ;
				
				resultList.add(rt) ;
			}
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			
		} catch (Exception e) {
			System.out.println("ResourceTypeDAO.queryAll---->"+e) ;
		}finally{
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;	
		}
		
		return resultList ;	
	}
	
	public boolean deleteResType(int lbid,int xxbh){
		boolean flag = false ;
		String sqlStr = "delete from m_zylb where lbid = ? and xxbh = ?"  ;
		
		try {
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr) ;
			stmt.setInt(1,lbid) ;
			stmt.setInt(2,xxbh) ;
			stmt.executeUpdate() ;
			DBUtils.closeStatement(stmt) ;			
		} catch (Exception e) {
			System.out.println("ResourceTypeDAO.deleteResType"+e) ;
			return flag ;
		}finally{
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;
		}
		flag = true ;
		return flag ;
	}
	
	public boolean EditResType(ResourceType rt){
		boolean flag = false ;
		String sqlStr = "update m_zylb set lbmc =? where xxbh = ? and lbid = ?" ;
		
		try {
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr) ;
			stmt.setString(1,rt.getLbmc()) ;
			stmt.setInt(2,rt.getXxbh()) ;
			stmt.setInt(3,rt.getLbid()) ;
			stmt.executeUpdate() ;
			
			DBUtils.closeStatement(stmt) ;
			
		} catch (Exception e) {
			System.out.println("ResourceTypeDAO.EditResType"+e) ;
			return flag ;	
		} finally{
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;
		}
		flag = true ;
		return flag ;
	}
	
	public boolean AddResType(ResourceType rt){
		boolean flag = false ;
		String sqlSrt ="insert into m_zylb (lbid,xxbh,lbmc) values(?,?,?)"  ;
		
		try {
			int lbid = KeyGenerator.getInstance().getNextKey("m_zylb");
		
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlSrt) ;
			stmt.setInt(1,lbid) ;
			stmt.setInt(2,rt.getXxbh()) ;
			stmt.setString(3,rt.getLbmc()) ;
			stmt.executeUpdate() ;
			
			DBUtils.closeStatement(stmt) ;
		} catch (Exception e) {
			System.out.println("ResourceTypeDAO.AddResType"+e) ;
			return flag ;
		}finally{
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ; 
		}
		flag = true ;
		return flag ;
	}
	
	public ResourceType queryById(int lbid,int xxbh){
		String sqlStr = " select * from m_zylb where lbid = ? and xxbh = ?" ;
		ResourceType rt = null ;
 		try {
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr) ;
			stmt.setInt(1,lbid) ;
			stmt.setInt(2,xxbh) ;
			rs = stmt.executeQuery() ;
			
			if(rs.next()){
				rt = new ResourceType() ;
				rt.setLbid(rs.getInt("lbid")) ;
				rt.setXxbh(rs.getInt("xxbh")) ;
				rt.setLbmc(rs.getString("lbmc")) ;
			}
			
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
 		} catch (Exception e) {
 			System.out.println("ResourceTypeDAO.queryById"+e) ;
		} finally{
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;
		}
		return rt ;
	}
	
	public int getCountsOfAll(){
		String sqlStr = "select count(*) from m_zylb" ;
		int count = 0 ;
		try {
			conn = DBUtils.getConnection() ;
			stmt = conn.prepareStatement(sqlStr) ;
			rs = stmt.executeQuery() ;
			if(rs.next()){
				count = rs.getInt(1) ;
			}
			
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
		} catch (Exception e) {
			System.out.println("ResourceTypeDAO----->"+e) ;
		} finally{
			DBUtils.closeResultSet(rs) ;
			DBUtils.closeStatement(stmt) ;
			DBUtils.closeConnection(conn) ;
		}
		System.out.println("count-------------------------->"+count) ;
 		return count ;
 		
	}
}