📄 savedata.jsp
字号:
<%@page import="java.sql.*"%>
<%@page import="java.util.*"%>
<%@page contentType="text/html;charset=GB2312"%>
<%@include file="opendata.jsp"%>
<%@include file="convert.jsp"%>
<%@include file="check.jsp"%>
<%!
int isempty(String str) //判断递交的字符串是否为空
{
if(str.length() ==0)
return (0);
else return (1);
}
%>
<%!
String transfer(int i) //将时间数值转换为标准格式
{
if(i>=10)
return (String.valueOf(i));
else return ("0"+String.valueOf(i));
}
%>
<%
request.setCharacterEncoding("GBK");
String question = request.getParameter("question");
String utime=(new java.util.Date()).toLocaleString();
String item[] = {request.getParameter("item1"),request.getParameter("item2"),
request.getParameter("item3"),request.getParameter("item4"),
request.getParameter("item5"),request.getParameter("item6"),
request.getParameter("item7"),request.getParameter("item8"),
request.getParameter("item9"),request.getParameter("item0"),};
if(question != null && question.length() >0) {
ResultSet tmpRs = smt.executeQuery("select max(QuestionID) As maxid from Questions");
tmpRs.next();
int max_id = tmpRs.getInt("maxid") + 1;
tmpRs.close();
sql="INSERT INTO Questions(QuestionID,Question,Date1) VALUES ("+max_id+",'"+question+"','"+utime+"')";
smt.executeUpdate(sql);
}
try{
sql="select QuestionID from Questions where Date1= '"+utime+"'";//利用新建立的时间查找新建立的题目的ID号
rs = smt.executeQuery(sql);
int questionid = 0; //
rs.beforeFirst();
while(rs.next())
{questionid = rs.getInt(1);}
for(int i = 0;i<=9;i++)
{
if(isempty(item[i])==1)
{
ResultSet tmpRs1 = smt.executeQuery("select max(ItemID) As m_id from Items");
tmpRs1.next();
int id = tmpRs1.getInt("m_id") + 1;
tmpRs1.close();
sql="insert into Items(ItemID,QuestionID,Item) values('"+id+"','"+questionid+"','"+item[i]+"')";
smt.executeUpdate(sql);
}
}
response.sendRedirect("mainform.jsp");
}catch(Exception e){
out.println(e.getMessage());
}
%>
<html>
<title>错误信息</title>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -