?? modify_mn_test_totalmark.jsp
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="jinghua.*"%>
<jsp:useBean id="DBCon" class="jinghua.JinghuaConn" scope="session">
</jsp:useBean>
<%!boolean debug=false;
Connection con=null;
String sql=null;
StringBuffer sb=null;
ResultSet rs=null;
Statement stmt=null;
%>
<%
String mn_testID=request.getParameter("mn_testID");
String mntotalmark=request.getParameter("mntotalmark");
if(debug){
out.print("<br>mn_testID="+mn_testID+
"<br>mntotalmark="+mntotalmark);
}
if(mn_testID==null || mntotalmark==null)
throw new Exception("調用參數不足!");
try{
con=DBCon.getConnection();
con.setAutoCommit(false);
sql="update mn_test set mntotalmark="+mntotalmark+
" where id="+mn_testID;
stmt=con.createStatement();
stmt.executeUpdate(sql);
stmt.close();
if(debug)
out.print("<br>update mn_test sql="+sql);
//Tools.showalert("設置分數成功!",out);
//Tools.goback(out);
response.sendRedirect("modify_test_mn.jsp?mnID="+mn_testID);
//Tools.showJS("window.open('admin_subject.jsp','_self')",out);
}
catch(SQLException se){
out.println(se.toString());
out.print("<br>sql="+sql);
}
catch(Exception e){
out.print("<br>"+e.toString());
}
finally{
DBCon.dropConnection();
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -