📄 addquestion.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.io.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>后台处理增加试题</title>
</head>
<jsp:useBean id="linejdbc" scope="page" class="examinline.DBConnectionBean" />
<%linejdbc.setdrivername();%>
<script language='JavaScript' type='text/JavaScript' src='../img/fun.js'></script>
<body>
<center>
<%!String sql=null;
String sql2=null;
String sql3=null;
String question;
String keya;
String keyb;
String keyc;
String keyd;
String answer;
int n;
int type1;
ResultSet rs;
//int id2;
//int type1=Integer.parseInt(request.getParameter("type1"));
%>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement p=null;
question = request.getParameter("question");
keya = request.getParameter("keya");
keyb = request.getParameter("keyb");
keyc = request.getParameter("keyc");
keyd = request.getParameter("keyd");
answer = request.getParameter("answer");
if((keya.equals(keyb))||(keya.equals(keyc))||(keya.equals(keyd))||(keyb.equals(keyc))||(keyb.equals(keyd))||(keyc.equals(keyd)))
{%>
<script language="JavaScript">alert("你输入的选项中有两个或两个以上的内容相同！");</script>
<script language="JavaScript">MM_goToURL('parent','./addQ222.jsp');</script>
<%
}
else{}
if((answer.equals("A"))||(answer.equals("B"))||(answer.equals("C"))||(answer.equals("D"))){n=1;}
else{%>
<script language="JavaScript">alert("你输入的正确答案不合法！");</script>
<script language="JavaScript">MM_goToURL('parent','./addQ222.jsp');</script>
<%
n=0;
}
if (request.getParameter("type1")!=null)
{
try{
type1=Integer.parseInt(request.getParameter("type1"));
}
catch(Exception e){out.print(""+e);}
}
else{%>
<script language="JavaScript">alert("请选择科目！")</script>
<script language="JavaScript">MM_goToURL('parent','./addQ.jsp');</script>
<%
}
if(type1==1){
sql = "insert into chi_choose(question,k_a,k_b,k_c,k_d,answer) values(?,?,?,?,?,?)";
sql2= "select * from chi_choose";
sql3="select * from chi_choose where question=? and k_a=? and k_b=? and k_c=? and k_d=? and answer=?";
}
else if(type1==2){
sql = "insert into maths_choose(question,k_a,k_b,k_c,k_d,answer) values(?,?,?,?,?,?)";
sql2= "select * from maths_choose";
sql3="select * from chi_choose where question=? and k_a=? and k_b=? and k_c=? and k_d=? and answer=?";
}
else if(type1==3){
sql = "insert into eng_choose(question,k_a,k_b,k_c,k_d,answer) values(?,?,?,?,?,?)";
sql2= "select * from eng_choose";
sql3="select * from chi_choose where question=? and k_a=? and k_b=? and k_c=? and k_d=? and answer=?";
}
else {
sql = "insert into log_choose(question,k_a,k_b,k_c,k_d,answer) values(?,?,?,?,?,?)";
sql2= "select * from log_choose";
sql3="select * from chi_choose where question=? and k_a=? and k_b=? and k_c=? and k_d=? and answer=?";
}
//System.out.print(""+sql3);
p = conn.prepareStatement(sql3);
p.setString(1,question);
p.setString(2,keya);
p.setString(3,keyb);
p.setString(4,keyc);
p.setString(5,keyd);
p.setString(6,answer);
rs = p.executeQuery();
if(rs.next())
{%>
<script language="JavaScript">alert("你输入的试题已经存在！请重新输入");</script>
<script language="JavaScript">MM_goToURL('parent','./addQ222.jsp');</script>
<%
rs.close();
}
else{}
if(n>0){
p = conn.prepareStatement(sql);
p.setString(1,question);
p.setString(2,keya);
p.setString(3,keyb);
p.setString(4,keyc);
p.setString(5,keyd);
p.setString(6,answer);
int result = p.executeUpdate();
if (result==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
p = conn.prepareStatement(sql2);
rs = p.executeQuery();
%>
<table width="550" border="1" align="center" class="table">
<tr align="center" class="table">
<td width="16" class="table">题号</td>
<td class="table">题目</td>
<td class="table" colspan="4">选项</td>
<td width="16" class="table">答案</td>
</tr>
<%
while (rs.next())
{
%>
<tr align="center" class="table">
<td class="table"><%=rs.getString("id")%></td>
<td class="table"><%=rs.getString("question")%></td>
<td class="table"><%=rs.getString("k_a")%></td>
<td class="table"><%=rs.getString("k_b")%></td>
<td class="table"><%=rs.getString("k_c")%></td>
<td class="table"><%=rs.getString("k_d")%></td>
<td class="table"><%=rs.getString("answer")%></td>
<%
}
%>
</tr>
<div align="center"><tr><td class="table" colspan="7"><a href = "addQ222.jsp">返回继续添加或删除试题</a></td></tr>
<span class="unnamed1"></span></div>
</table>
<%
}
}
%>
</center>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -