?? 204701e99d45001d1cdee86927ab33b7
字號:
<%@page contentType="text/html; charset=gb2312" import="java.sql.*"%>
<%
String driver = "sun.jdbc.odbc.JdbcOdbcDriver"; //驅動程序,見第十四章
String url = "jdbc:odbc:stud"; //數據庫連接語句,見第十四章
String userID = "sa", pwd = "", sql = "";
try {
Class.forName(driver); //調入JDBC-ODBC橋的驅動程序
Connection conn = DriverManager.getConnection(url, userID, pwd); //建立與數據的連接
//request對象見第四章
request.setCharacterEncoding("gb2312"); //亂碼轉換成中文
Statement stmt = conn.createStatement(); //建立Statement的實例,相當于創建一個查詢分析器的運行環境
sql = "select * from studinfo where studid='" + request.getParameter("studID") + "'";
ResultSet rs = stmt.executeQuery(sql);
if(rs.next())
{
%>
<script language="javascript">
alert("學生編號已存在,請選擇其它編號");
window.history.go(-1);
</script>
<%
}
rs.close();
sql = "insert studinfo values('" + request.getParameter("studID") + "','";
sql = sql + request.getParameter("studName") + "','";
sql = sql + request.getParameter("classID") + "','";
sql = sql + request.getParameter("sex") + "','";
sql = sql + request.getParameter("age") + "')";
if (stmt.executeUpdate(sql) > 0) {
response.sendRedirect("StudList.jsp"); //response對象見第四章,連接到memCenter.jsp頁面
}
} catch (Exception e) {
System.out.println(e.getMessage());
}
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -