studentdao.java

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

package com.comingnet.bean;
import com.db.ProxoolAction;
import com.db.KeyGenerator;
import java.sql.*;

import com.comingnet.bean.studentInfor;
public class studentDAO {
   Connection conn=null;
   PreparedStatement stmt=null;
   ResultSet rs=null; 

	public studentDAO() throws Exception
	{
		conn=ProxoolAction.getConnection();
	}
	public boolean studentDel(int xsid)
	{
		boolean flag=false;
	    try
	    {
	    	stmt=conn.prepareStatement("delete from m_student where xsid=?");
	    	stmt.setInt(1,xsid);
	    	stmt.executeUpdate();
	    	flag=true;
	    }catch(Exception e)
	    {
	    	
	    }finally
	    {
	    	ProxoolAction.closeStatement(stmt);
	    	ProxoolAction.closeConnection(conn);
	    }
		return flag;
	}
	 
	public boolean studentInsert(studentInfor stuinfor)
	{
		boolean flag=false;
        try
        {
            stmt=conn.prepareStatement("insert into m_student(xsid,xszh,xsxh,xsmm,xsxm,xscsrq,xssfz,xsyj,xsdh,xsxb,xsjg,xsjtdz,xsfmxx,xsbjbh,xsbz,xslrr,xxbh) values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
            stmt.setInt(1,KeyGenerator.getInstance().getNextKey("m_student"));
            stmt.setString(2,stuinfor.getXszh());
            stmt.setString(3,stuinfor.getXsxh());
            stmt.setString(4,stuinfor.getXsmm());
            stmt.setString(5,stuinfor.getXsxm());
            stmt.setString(6,stuinfor.getXscsrq());
            stmt.setString(7,stuinfor.getXssfz());
            stmt.setString(8,stuinfor.getXsyj());
            stmt.setString(9,stuinfor.getXsdh());
            stmt.setString(10,stuinfor.getXsxb());
            stmt.setString(11,stuinfor.getXsjg());
            stmt.setString(12,stuinfor.getXsjtdz());
            stmt.setString(13,stuinfor.getXsfmxx());
            stmt.setInt(14,stuinfor.getXsbjbh());
            stmt.setString(15,stuinfor.getXsbz());
            stmt.setString(16,stuinfor.getXslrr());
            //stmt.setString(17,stuinfor.getXsbjmc());
            stmt.setInt(17,stuinfor.getXxbh());
            stmt.executeUpdate();
            flag=true;
        }catch(Exception e)
	    {
	    	System.out.println("studentDAO--->2:"+e);
	    }finally
	    {
	    	ProxoolAction.closeStatement(stmt);
	    	ProxoolAction.closeConnection(conn);
	    }
		return flag;
	}
	
	public boolean studentUpdate(studentInfor stuinfor)
	{
		boolean flag=false;
		try
		{
			stmt=conn.prepareStatement("update  m_student set xszh=?,xsxh=?,xsxm=?,xscsrq=?,xssfz=?,xsyj=?,xsdh=?,xsxb=?,xsjg=?,xsjtdz=?,xsfmxx=?,xsbjbh=?,xxbh=? where xsid=?");
            stmt.setString(1,stuinfor.getXszh());
            stmt.setString(2,stuinfor.getXsxh());
            stmt.setString(3,stuinfor.getXsxm());
            stmt.setString(4,stuinfor.getXscsrq());
            stmt.setString(5,stuinfor.getXssfz());
            stmt.setString(6,stuinfor.getXsyj());
            stmt.setString(7,stuinfor.getXsdh());
            stmt.setString(8,stuinfor.getXsxb());
            stmt.setString(9,stuinfor.getXsjg());
            stmt.setString(10,stuinfor.getXsjtdz());
            stmt.setString(11,stuinfor.getXsfmxx());
            stmt.setInt(12,stuinfor.getXsbjbh());
            //stmt.setString(13,stuinfor.getXsbjmc());
            stmt.setInt(13,stuinfor.getXxbh());
            stmt.setInt(14,stuinfor.getXsid());
            int i=stmt.executeUpdate();
            System.out.println(i+"项修改成功-------------------------------->:"+stuinfor.getXszh());
            
            flag=true;
		}catch(Exception e)
		{
			System.out.println("studentDao:2---->"+e);
		}finally
		{
			ProxoolAction.closeStatement(stmt);
			ProxoolAction.closeConnection(conn);
		}
		return flag;
	}

}