mailbcdao.java

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

package com.comingnet.bean;
import com.db.*;
import java.sql.*;
public class MailBcDAO {
    Connection conn=null;
    PreparedStatement stmt=null;
    ResultSet rs=null;
    int yjid;
    
    
	public int getYjid() {
		return yjid;
	}
	public void setYjid(int yjid) {
		this.yjid = yjid;
	}
	public MailBcDAO() 
	{
		try{
			conn=DBUtils.getConnection();
		}catch(Exception e){
			System.out.println("MailBcDAo.construtors--------------->"+e) ;
		}
	}
	public boolean MailBC(EmailInfor mailinfor,UserInfor userinfor)
	{
		try
		{
			yjid=KeyGenerator.getInstance().getNextKey("yjxx");
			setYjid(yjid);
			System.out.println("daoYjid------------------------------------->"+yjid) ;
			stmt=conn.prepareStatement("insert into yjxx(yjid,yjryxm,yjwbzs,yjwbcs,yjwbms,yjfssj,yjsj,yjbt,yjnr,yjfjdz) values(?,?,?,?,?,getdate(),getdate(),?,?,?)");
			stmt.setInt(1,yjid);
			System.out.println("daoYjid1------------------------------------->"+yjid) ;
			stmt.setString(2,"");
			stmt.setString(3,mailinfor.getYjwbzs());
			stmt.setString(4,mailinfor.getYjwbcs());
			stmt.setString(5,mailinfor.getYjwbms());
			stmt.setString(6,mailinfor.getYjbt());  
			stmt.setString(7,mailinfor.getYjnr());
			stmt.setString(8,mailinfor.getYjfjdz());
			int i=stmt.executeUpdate();
			DBUtils.closeStatement(stmt);
			
			
			if(i>0)
			{
			  
			  stmt=conn.prepareStatement("insert into yjsj(sjid,yjid,ryid,ryclass,xxbh,rywjj,rylx) values(?,?,?,?,?,?,?)");
			  stmt.setInt(1,KeyGenerator.getInstance().getNextKey("yjsj"));
			  stmt.setInt(2,yjid);
			  System.out.println("daoYjid2------------------------------------->"+yjid) ;
			  stmt.setInt(3,userinfor.getUserid());
			  stmt.setString(4,userinfor.getUserclass());
			  stmt.setInt(5,userinfor.getUserxxbh());
			  stmt.setInt(6,2);                             //保存于发件箱
			  stmt.setInt(7,0);
			  stmt.executeUpdate();
			  DBUtils.closeStatement(stmt) ;
			}
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		return true;
	}
	
	public EmailInfor getEmailInfor(int sjid)
	{
		EmailInfor emailinfor=new EmailInfor();
		try
		{
			stmt=conn.prepareStatement("update yjsj set ryydbz=1 where sjid=?");
			stmt.setInt(1,sjid);
			stmt.executeUpdate();
			DBUtils.closeStatement(stmt);
			
			stmt=conn.prepareStatement("select b.yjid,yjbt,yjnr,CONVERT(varchar(20),yjfssj,120) as yjfssj,yjfjdz,yjwbzs,yjwbcs from yjsj a,yjxx b where a.yjid=b.yjid and a.sjid=?");
			//stmt=conn.prepareStatement("select b.yjid,yjbt,yjnr,CONVERT(varchar(20),yjfssj,120) as yjfssj,yjfjdz,yjwbzs,yjwbcs ,fjoldname,fjnewname from yjsj a,yjxx b ,yjfj c where a.yjid=b.yjid and c.yjid = ? and a.sjid=?;");
			stmt.setInt(1,sjid);
			rs=stmt.executeQuery();
			if(rs.next())
			{
				emailinfor.setYjid(rs.getInt("yjid"));
				emailinfor.setYjbt(rs.getString("yjbt"));
				emailinfor.setYjnr(rs.getString("yjnr"));
				emailinfor.setYjfssj(rs.getString("yjfssj"));
				emailinfor.setYjfjdz(rs.getString("yjfjdz"));				   
				emailinfor.setYjwbzs(rs.getString("yjwbzs"));
				emailinfor.setYjwbcs(rs.getString("yjwbcs"));
			}
		}catch(Exception e)
		{
			System.out.println(e);
		}finally
		{
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
		}
		return emailinfor;
	}
}