tsinfor.java

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

package com.comingnet.bean;
import java.sql.*;
import com.db.*;
import com.comingnet.bean.*;
public class TSInfor {
	Connection conn=null;
	PreparedStatement stmt=null;
	ResultSet rs=null;
	public TSInfor() throws Exception
	{
		conn=DBUtils.getConnection();
	}
	
	public teacherInfor getTeacherInfor(int jsid)
	{
		teacherInfor tinfor=new teacherInfor();
		try
	    {
	 	  stmt=conn.prepareStatement("select jsxm,jsbyxx,jsbz,CONVERT(varchar(12),jscsrq,102)as jscsrq,jsid,jskcjc,CONVERT(varchar,jsrzsj,20) as jsrzsj,jssfz,jssjhm,jsxb,jsxl,jsyj,jszdkc,jszh,xxbh    from m_teacher where jsid=?");
		  stmt.setInt(1,jsid);
		  rs=stmt.executeQuery();
		  if(rs.next())
		  {
			 tinfor.setJsxm(rs.getString("jsxm"));
			 tinfor.setJsbyxx(rs.getString("jsbyxx"));
			 tinfor.setJsbz(rs.getString("jsbz"));
			 tinfor.setJscsrq(rs.getString("jscsrq"));
			 tinfor.setJsid(rs.getInt("jsid"));
			 tinfor.setJskcjc(rs.getString("jskcjc"));
			 tinfor.setJsrzsj(rs.getString("jsrzsj"));
			 tinfor.setJssfz(rs.getString("jssfz"));
			 tinfor.setJssjhm(rs.getString("jssjhm"));
			 tinfor.setJsxb(rs.getString("jsxb"));
			 tinfor.setJsxl(rs.getString("jsxl"));
			 tinfor.setJsyj(rs.getString("jsyj"));
			 tinfor.setJszdkc(rs.getString("jszdkc"));
			 tinfor.setJszh(rs.getString("jszh"));
			 tinfor.setXxbh(rs.getInt("xxbh"));
 	      }
	    }catch(Exception e)
	     {
		    System.out.println("TSInfor.java取到教师信息:"+e);
	     }finally
	      {
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);
	      }
	    return tinfor;
	} 
	public studentInfor getStudentInfor(int xsid)
	{
		studentInfor sinfor=new studentInfor();
		try
		{
			stmt=conn.prepareStatement("select xxbh,xszh,xsyj,xsxh,xsxm,xsxb,xssfz,CONVERT(varchar,xsrxsj,10) as xsrxsj,xsjtdz,xsjg,xsid,xsfmxx,xsdh,xsbjbh,xsbjmc,xsbz,CONVERT(varchar(12),xscsrq,102) as xscsrq from m_student where xsid=?");
			stmt.setInt(1,xsid);
			rs=stmt.executeQuery();
			if(rs.next())
			{
			  sinfor.setXsbjbh(rs.getInt("xsbjbh"));
			  sinfor.setXsbjmc(rs.getString("xsbjmc"));
			  sinfor.setXsbz(rs.getString("xsbz"));
			  sinfor.setXscsrq(rs.getString("xscsrq"));
			  sinfor.setXsdh(rs.getString("xsdh"));
			  sinfor.setXsfmxx(rs.getString("xsfmxx"));
			  sinfor.setXsid(rs.getInt("xsid"));
			  sinfor.setXsjg(rs.getString("xsjg"));
			  sinfor.setXsjtdz(rs.getString("xsjtdz"));
			  sinfor.setXsrxsj(rs.getString("xsrxsj"));
			  sinfor.setXssfz(rs.getString("xssfz"));
			  sinfor.setXsxb(rs.getString("xsxb"));
			  sinfor.setXsxh(rs.getString("xsxh"));
			  sinfor.setXsxm(rs.getString("xsxm"));
			  sinfor.setXsyj(rs.getString("xsyj"));
			  sinfor.setXszh(rs.getString("xszh"));
			  sinfor.setXxbh(rs.getInt("xxbh"));
			}
		}catch(Exception e)
		{
			System.out.println("TSInfor.java取到学生信息:"+e);
		}finally
		{
			DBUtils.closeResultSet(rs);
			DBUtils.closeStatement(stmt);
			DBUtils.closeConnection(conn);		
		}
		return sinfor;
	}
}