schoolinfordao.java

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

package com.comingnet.bean;
import com.comingnet.bean.*;
import com.db.*;
import java.sql.*;
public class SchoolInforDAO {
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;
	public SchoolInforDAO()
	{
		
	}
	public boolean InsertSchoolData(SchoolInfor scinfor)
	{
		boolean flag=false;
		try
		{
			conn=DBUtils.getConnection();
			stmt=conn.prepareStatement("insert into ms_school(ms_xxid,ms_xxmc,ms_xxdz,ms_xxfzr,ms_xxdh,ms_xxgk,ms_xxzt) values(?,?,?,?,?,?,?)");
			stmt.setInt(1,KeyGenerator.getInstance().getNextKey("ms_school"));
			stmt.setString(2,scinfor.getSmc());
			stmt.setString(3,scinfor.getSdz());
			stmt.setString(4,scinfor.getSfzr());
			stmt.setString(5,scinfor.getSdh());
			stmt.setString(6,scinfor.getSgk());
			stmt.setString(7,scinfor.getSzt());
			stmt.executeUpdate();
			flag=true;
		}catch(Exception e)
		{
			System.out.println("异常:"+e);
			flag=false;
		}finally
		{
			  DBUtils.closeResultSet(rs);
			  DBUtils.closeStatement(stmt);
			  DBUtils.closeConnection(conn);
		}
		
		return flag;
	}
	public boolean UpdateSchoolData(SchoolInfor scinfor)
	{
		boolean flag=false;
		try
		{
           conn=DBUtils.getConnection();
           stmt=conn.prepareStatement("update ms_school set ms_xxmc=?,ms_xxdz=?,ms_xxfzr=?,ms_xxdh=?,ms_xxgk=?,ms_xxzt=? where ms_xxid=?");
           stmt.setString(1,scinfor.getSmc());
           stmt.setString(2,scinfor.getSdz());
           stmt.setString(3,scinfor.getSfzr());
           stmt.setString(4,scinfor.getSdh());
           stmt.setString(5,scinfor.getSgk());
           stmt.setString(6,scinfor.getSzt());
           stmt.setInt(7,scinfor.getSid());
           stmt.executeUpdate();
           flag=true;
		}catch(Exception e)
		{
		   System.out.println("异常:"+e);
 		   flag=false;	
		}finally
		{
		   DBUtils.closeStatement(stmt);
		   DBUtils.closeConnection(conn);
		}
		return flag;
	}
	
	
	

}