📄 webexam.java
字号:
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
//指明所有发送了的数据的字节数
response.setContentLength( dos.size() );
dos.close();
os.close();
return;
}
private void Deal_ZCFG_Library(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
try
{
//获得行数
PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from ZCFG_Library");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from ZCFG_Library";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetZCFG_Library info = new SetZCFG_Library();
//发送信息
while( rs.next() )
{
info.setZCFG_Id( rs.getInt("ZCFG_Id") );
info.setZcfgType_Id( rs.getInt("ZcfgType_Id") );
info.setCreateTime( rs.getDate("CreateTime").getTime() );
info.setFW_Number( rs.getString("FW_Number") );
info.setFW_FWJG( rs.getString("FW_FWJG") );
info.setFW_Key( rs.getString("FW_Key") );
info.setFW_Date( rs.getDate("FW_Date").getTime() );
info.setFW_Title( rs.getString("FW_Title") );
info.setFW_Type( rs.getString("FW_Type") );
info.setIsNew( rs.getInt("IsNew") );
info.setValidity( rs.getInt("Validity") );
info.setFW_FileName( rs.getString("FW_FileName") );
info.setIsAutoLK( rs.getInt("IsAutoLK") );
info.setLKInterval( rs.getInt("LKInterval") );
info.setFW_Describe( rs.getString("FW_Describe") );
info.setLKDate( rs.getDate("LKDate").getTime() );
info.setCreateName( rs.getString("CreateName") );
info.setModifyTime( rs.getDate("ModifyTime").getTime() );
//序列化为二进制数据
byte[] data = info.serialize();
//一条记录的长度
dos.writeInt( data.length );
dos.write(data);
}
//释放资源
rs.close();
}
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
//指明所有发送了的数据的字节数
response.setContentLength( dos.size() );
dos.close();
os.close();
return;
}
private void Deal_ZCFG_Type(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
try
{
//获得行数
PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from ZCFG_Type");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from ZCFG_Type";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetZCFG_Type info = new SetZCFG_Type();
//发送信息
while( rs.next() )
{
info.setZcfgType_Id( rs.getInt("ZcfgType_Id") );
info.setZcfgType_name( rs.getString("ZcfgType_name") );
info.setClerk_ID( rs.getInt("Clerk_ID") );
info.setZcfgType_Brief( rs.getString("ZcfgType_Brief") );
info.setCreateTime( rs.getDate("CreateTime").getTime() );
info.setCreateName( rs.getString("CreateName") );
//序列化为二进制数据
byte[] data = info.serialize();
//一条记录的长度
dos.writeInt( data.length );
dos.write(data);
}
//释放资源
rs.close();
}
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
//指明所有发送了的数据的字节数
response.setContentLength( dos.size() );
dos.close();
os.close();
return;
}
private void Deal_clerk(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
try
{
//获得行数
PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from clerk");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from clerk";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
Setclerk info = new Setclerk();
//发送信息
while( rs.next() )
{
info.setClerk_Id( rs.getInt("Clerk_Id") );
info.setOrganID( rs.getInt("OrganID") );
info.setclerk_name( rs.getString("clerk_name") );
info.setName( rs.getString("Name") );
info.setclerk_pwd( rs.getString("clerk_pwd") );
info.setclerk_sex( rs.getString("clerk_sex") );
info.setClerk_Job( rs.getString("Clerk_Job") );
info.setclerk_address( rs.getString("clerk_address") );
info.setclerk_telephone( rs.getString("clerk_telephone") );
info.setclerk_email( rs.getString("clerk_email") );
info.setclerk_dw( rs.getString("clerk_dw") );
info.setclerk_bm( rs.getString("clerk_bm") );
info.setclerk_post( rs.getString("clerk_post") );
info.setclerk_bz( rs.getString("clerk_bz") );
info.setClerk_BornDate( rs.getDate("Clerk_BornDate").getTime() );
info.setClerk_xl( rs.getString("Clerk_xl") );
info.setClerk_WorkType( rs.getString("Clerk_WorkType") );
info.setClerk_Number( rs.getString("Clerk_Number") );
info.setClerk_SFZNumber( rs.getString("Clerk_SFZNumber") );
info.setClerk_WorkTime( rs.getDate("Clerk_WorkTime").getTime() );
info.setClerk_Status( rs.getInt("Clerk_Status") );
info.setCreateTime( rs.getDate("CreateTime").getTime() );
info.setCreateName( rs.getString("CreateName") );
info.setLoginTimes( rs.getInt("LoginTimes") );
info.setClerk_Train( rs.getString("Clerk_Train") );
info.setClerk_TrainPlace( rs.getString("Clerk_TrainPlace") );
info.setOtherC1( rs.getString("OtherC1") );
info.setOtherC2( rs.getString("OtherC2") );
info.setOtherD1( rs.getDate("OtherD1").getTime() );
info.setOtherF1( rs.getFloat("OtherF1") );
info.setB_level( rs.getInt("B_level") );
info.setLeibie( rs.getInt("Leibie") );
info.setOther1( rs.getString("Other1") );
info.setOther2( rs.getString("Other2") );
info.setOther3( rs.getString("Other3") );
info.setOtherInt1( rs.getInt("OtherInt1") );
info.setOtherInt2( rs.getInt("OtherInt2") );
info.setOtherDate1( rs.getDate("OtherDate1").getTime() );
info.setOtherDate2( rs.getDate("OtherDate2").getTime() );
//序列化为二进制数据
byte[] data = info.serialize();
//一条记录的长度
dos.writeInt( data.length );
dos.write(data);
}
//释放资源
rs.close();
}
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
//指明所有发送了的数据的字节数
response.setContentLength( dos.size() );
dos.close();
os.close();
return;
}
private void Deal_clerk_kscj(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
try
{
//获得行数
PreparedStatement ps1 = conn.prepareStatement("select count(*) as raw_count from clerk_kscj");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from clerk_kscj";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
Setclerk_kscj info = new Setclerk_kscj();
//发送信息
while( rs.next() )
{
info.setClerk_kscj_ID( rs.getInt("Clerk_kscj_ID") );
info.setclerk_Id( rs.getInt("clerk_Id") );
info.settk_cl_Id( rs.getInt("tk_cl_Id") );
info.setClerk_ks_status( rs.getInt("Clerk_ks_status") );
info.setclerk_ks_btime( rs.getDate("clerk_ks_btime").getTime() );
info.setclerk_tmp_time( rs.getDate("clerk_tmp_time").getTime() );
info.setclerk_ks_etime( rs.getDate("clerk_ks_etime").getTime() );
info.setCJ( rs.getFloat("CJ") );
info.setKs_Time( rs.getInt("Ks_Time") );
info.settype( rs.getInt("type") );
info.setcause( rs.getString("cause") );
info.setClerk_pj( rs.getString("Clerk_pj") );
info.setclerk_xzdf( rs.getFloat("clerk_xzdf") );
info.setclerk_wddf( rs.getFloat("clerk_wddf") );
info.setclerk_wdpf( rs.getString("clerk_wdpf") );
info.setRate( rs.getFloat("Rate") );
info.setClerk_Result( rs.getString("Clerk_Result") );
info.setOther1( rs.getString("Other1") );
info.setOtherINT1( rs.getInt("OtherINT1") );
//序列化为二进制数据
byte[] data = info.serialize();
//一条记录的长度
dos.writeInt( data.length );
dos.write(data);
}
//释放资源
rs.close();
}
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
//指明所有发送了的数据的字节数
response.setContentLength( dos.size() );
dos.close();
os.close();
return;
}
private void Deal_clerk_kscj_by_clerk_id_tk_cl_id(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
InputStream is = request.getInputStream();
DataInputStream dis = new DataInputStream(is);
int clerk_id = dis.readInt();
int tk_cl_id = dis.readInt();
float IsGDFS = 0;
int tk_cl_time = 0;
int MaxKsNum = 0;
int tct;
int Clerk_kscj_ID = 0;
String GD = "1";
try
{
sql = "select count(*) as raw_count from tk_cl where tk_cl_id = " + tk_cl_id;
//获得行数
PreparedStatement ps1 = conn.prepareStatement( sql );
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
if( num <= 0 )
{
System.out.println("错误的题库集！");
dos.writeByte(MessageConstants.OPERATION_GET_CLERK_KSCJ_NO_TK_CL);
return;
}
sql = "select * from tk_cl where tk_cl_id = " + tk_cl_id;
//执行SQL语句
rs = stmt.executeQuery(sql);
while( rs.next() )
{
MaxKsNum = rs.getInt("MaxKsNum");
tct = rs.getInt("tk_cl_type");
IsGDFS = rs.getFloat("IsGDFS");
GD = rs.getString("GD");
rs.close();
break;
}
sql = "Select count(*) as raw_count From clerk_kscj Where tk_cl_id=" + tk_cl_id + " And clerk_id = " + clerk_id;
//获得行数
ps1 = conn.prepareStatement( sql );
//执行查询语句
rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
if( num >= MaxKsNum )
{
System.out.println("考试次数已经超出最大次数");
dos.writeByte(MessageConstants.OPERATION_GET_CLERK_OVER_MAXKSNUM);
return;
}
sql = "insert into clerk_kscj(clerk_id,tk_cl_id,Clerk_ks_status,ks_time,clerk_ks_btime) values(" + clerk_id + "," + tk_cl_id + ",0,0,getdate())";
//执行SQL语句
System.out.println(sql);
stmt.execute( sql );
sql = "SELECT @@IDENTITY";
rs1 = stmt.executeQuery( sql );
while( rs1.next() )
{
Clerk_kscj_ID = rs1.getInt(1);
rs1.close();
break;
}
System.out.println("Clerk_kscj_ID = " + Clerk_kscj_ID);
//////////////////
if( GD.equals("1") )
{
try{
sql = "{call p_ks_CreateDA(?,?)}";
CallableStatement sqlStmt = conn.prepareCall(sql);
//设置输入参数
sqlStmt.setInt(1,Clerk_kscj_ID);
sqlStmt.setInt(2,tk_cl_id);
int i = sqlStmt.executeUpdate();
System.out.println("1i = " + i);
sqlStmt.close();
sql = "{call p_ks_SetRateFx(?)}";
sqlStmt.setInt(1,Clerk_kscj_ID);
i = sqlStmt.executeUpdate();
System.out.println("2i = " + i);
sqlStmt.close();
System.out⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -