📄 webexam.java
字号:
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();
//一条记录的长度
result.writeInt( data.length );
result.write(data);
}
else
{
//发送登录失败
result.writeInt(0);
}
rs.close();
}
catch(Exception e)
{
throw new ServletException( e.getMessage() );
}
return;
}
private void Deal_Clerk_TBTrain(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_TBTrain");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Clerk_TBTrain";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetClerk_TBTrain info = new SetClerk_TBTrain();
//发送信息
while( rs.next() )
{
info.setAuto_Id( rs.getInt("Auto_Id") );
info.setClerk_ID( rs.getInt("Clerk_ID") );
info.settk_tkj_Id( rs.getInt("tk_tkj_Id") );
info.setTm_Id( rs.getInt("Tm_Id") );
info.setTm_Fs( rs.getFloat("Tm_Fs") );
//序列化为二进制数据
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_Data_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 Data_Library");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Data_Library";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetData_Library info = new SetData_Library();
//发送信息
while( rs.next() )
{
info.setData_Id( rs.getInt("Data_Id") );
info.setSubject_ID( rs.getInt("Subject_ID") );
info.setSubjectBook_ID( rs.getInt("SubjectBook_ID") );
info.setTm_Zsd( rs.getString("Tm_Zsd") );
info.setCreateTime( rs.getDate("CreateTime").getTime() );
info.setCreateName( rs.getString("CreateName") );
info.setData_FileName( rs.getString("Data_FileName") );
info.setData_Point( rs.getString("Data_Point") );
info.setData_Difficulty( rs.getString("Data_Difficulty") );
info.setData_Describe( rs.getString("Data_Describe") );
info.setData_Order( rs.getInt("Data_Order") );
//序列化为二进制数据
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_Forum_Forum(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 Forum_Forum");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Forum_Forum";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetForum_Forum info = new SetForum_Forum();
//发送信息
while( rs.next() )
{
info.setF_ID( rs.getInt("F_ID") );
info.setF_SUBJECT( rs.getString("F_SUBJECT") );
info.setF_DESCRIPTION( rs.getString("F_DESCRIPTION") );
info.setF_TOPICS( rs.getInt("F_TOPICS") );
info.setF_REPLY( rs.getInt("F_REPLY") );
info.setF_LAST_POST( rs.getDate("F_LAST_POST").getTime() );
info.setF_Clerk_ID( rs.getString("F_Clerk_ID") );
//序列化为二进制数据
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_Forum_Reply(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 Forum_Reply");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Forum_Reply";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetForum_Reply info = new SetForum_Reply();
//发送信息
while( rs.next() )
{
info.setF_ID( rs.getInt("F_ID") );
info.setT_ID( rs.getInt("T_ID") );
info.setR_ID( rs.getInt("R_ID") );
info.setr_subject( rs.getString("r_subject") );
info.setR_CONTENT( rs.getString("R_CONTENT") );
info.setR_author_id( rs.getInt("R_author_id") );
info.setR_AUTHOR( rs.getString("R_AUTHOR") );
info.setR_DATE( rs.getDate("R_DATE").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_Forum_Topic(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 Forum_Topic");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Forum_Topic";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetForum_Topic info = new SetForum_Topic();
//发送信息
while( rs.next() )
{
info.setF_ID( rs.getInt("F_ID") );
info.setT_ID( rs.getInt("T_ID") );
info.setT_SUBJECT( rs.getString("T_SUBJECT") );
info.setT_CONTENT( rs.getString("T_CONTENT") );
info.setT_clerk_id( rs.getInt("T_clerk_id") );
info.setT_clerk_name( rs.getString("T_clerk_name") );
info.setT_DATE( rs.getDate("T_DATE").getTime() );
info.setT_REPLY( rs.getInt("T_REPLY") );
info.setT_VIEW( rs.getInt("T_VIEW") );
info.setR_DATE( rs.getDate("R_DATE").getTime() );
info.setT_TOP( rs.getByte("T_TOP") );
info.setT_LOCK( rs.getByte("T_LOCK") );
//序列化为二进制数据
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_Article_Comment(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 Article_Comment");
//执行查询语句
ResultSet rs1 = ps1.executeQuery();
rs1.next();//获得第一项数据
int num = rs1.getInt("raw_count");//获得行数
rs1.close();
ps1.close();
sql = "select * from Article_Comment";
//执行SQL语句
rs = stmt.executeQuery(sql);
//发送数目
dos.writeInt(num);
SetArticle_Comment info = new SetArticle_Comment();
//发送信息
while( rs.next() )
{
info.setCommentID( rs.getInt("CommentID") );
info.setArticleID( rs.getInt("ArticleID") );
info.setClerkID( rs.getInt("ClerkID") );
info.setCommentDetail( rs.getString("CommentDetail") );
info.setCreateTime( rs.getDate("CreateTime").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_GuestBook(HttpServletRequest request, HttpServletResponse response ) throws ServletException,IOException
{
//按照二进制方式进行传输
response.setContentType("application/octet-stream");
OutputStream os = response.getOutputStream();
DataOutputStream dos = new DataOutputStream(os);
try
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -