addmanager.jsp
来自「ftp管理。构造网络路径部分比较好。内部有数据库截图。。」· JSP 代码 · 共 126 行
JSP
126 行
<%@ 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 + =
减小字号Ctrl + -
显示快捷键?