?? addmanager.jsp
字號:
<%@ page language="java"%>
<%@ page contentType="text/html; charset=GBK"%>
<%@ page import="java.sql.*,common.DAO"%>
<html>
<head>
<title>軟件下載索引管理</title>
</head>
<%
String username = request.getParameter("username");
String password = request.getParameter("password");
String repassword = request.getParameter("repassword");
String realname = request.getParameter("realname");
int id = 0;
if (username != null) {
int purview = Integer.parseInt(request.getParameter("purview"));
String sqlstr = "insert into manager (id,username,password,realname,purview) values (?,?,?,?,?)";
if (password.equals(repassword)) {
try {
Connection conn = DAO.getConnection();
Statement stmt = conn.createStatement();
String sql = "select max(id) from manager";
java.sql.ResultSet rs = stmt.executeQuery(sql);
if (rs.next()) {
id = rs.getInt(1);
out.println(id);
}
PreparedStatement ps = conn.prepareStatement(sqlstr);
ps.setInt(1, id + 1);
ps.setString(2, username);
ps.setString(3, password);
ps.setString(4, realname);
ps.setInt(5, purview);
ps.executeUpdate();
rs.close();
stmt.close();
ps.close();
conn.close();
} catch (java.sql.SQLException ex) {
out.println(ex.getMessage());
}
}
}
%>
<body>
<form name="form1" method="post" action="#">
<table width="327" height="158" border="1" align="center">
<tr>
<td>
用戶名
</td>
<td>
<input type="text" name="username">
</td>
<td>
</td>
</tr>
<tr>
<td>
密碼
</td>
<td>
<input type="password" name="password">
</td>
<td>
</td>
</tr>
<tr>
<td>
重復密碼
</td>
<td>
<input type="password" name="repassword">
</td>
<td>
</td>
</tr>
<tr>
<td>
真實姓名
</td>
<td>
<input type="text" name="realname">
</td>
<td>
</td>
</tr>
<tr>
<td>
權限
</td>
<td>
<select name="purview">
<option value=1>
超級
</option>
<option value=0 selected>
普通
</option>
</select>
</td>
<td>
</td>
</tr>
<tr>
<td>
<input type="submit" name="Submit" value="提交">
</td>
<td>
</td>
<td>
</td>
</tr>
</table>
</form>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -