📄 operatedelq.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!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>
<link href="../img/cssexamin.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
.unnamed1 { font-size: 12px;
font-weight: lighter;
color: #FF0000;
text-decoration: none;
}
-->
</style>
</head>
<body>
<%!
int type2;
String sqlstr2;
%>
<%
Connection conn = linejdbc.getopenConnection();
PreparedStatement p=null;
try{
type2=Integer.parseInt(request.getParameter("type2"));
if(type2==0){
out.print("请选择增加的科目名称！");
%>
<script language="JavaScript">alert("请选择科目！")</script>
<%
}
else if(type1==1){
sqlstr2="select * from chi_choose";
p = conn.prepareStatement(sqlstr2);
p.setInt(1,id);
int result = p.executeUpdate();
if (result==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("添加失败，请重新添加！")</script>
<%
}
}
else if(type1==2){
sqlstr2 = "select * from maths_choose";
p = conn.prepareStatement(sqlstr2);
p.setInt(1,id);
int result = p.executeUpdate();
if (result==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("添加失败，请重新添加！")</script>
<%
}
}
else if(type1==3){
sqlstr2 = "select * from eng_choose";
p = conn.prepareStatement(sqlstr2);
p.setInt(1,id);
int result = p.executeUpdate();
if (result==1)
{
%>
<script language="JavaScript">alert("添加成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("添加失败，请重新添加！")</script>
<%
}
}
else if(type1==4){
sqlstr2 = "select * from log_choose";
p = conn.prepareStatement(sqlstr2);
p.setInt(1,id);
int result = p.executeUpdate();
if (result==1)
{
%>
<script language="JavaScript">alert("删除成功！")</script>
<%
}
else
{
%>
<script language="JavaScript">alert("删除失败，请重新删除！")</script>
<%
}
}
else{%>
<script language="JavaScript">alert("删除失败！")</script>
<%}
}
catch(Exception e){out.print(""+e);}
%>
/*
if (type2==0){
%><script language="JavaScript">alert("请选择科目！")</script><%
}
else if (type3==1){sqlstr1="select * from chi_choose";}
else if(type3==2){sqlstr1="select * from maths_choose";}
else if(type3==3){sqlstr1="select * from eng_choose";}
else{sqlstr1="select * from log_choose";}
*/
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -