JSP用户管理系统
<%
// 数据库连接信息
String url = "jdbc:mysql://localhost:3306/testdb" String user = "" String password = "password"
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName(".mysql.cj.jdbc.Driver" conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
// 创建用户表
String createTable = "CREATE TABLE IF NOT EXISTS users (" "id INT AUTO_INCREMENT PRIMARY KEY, " +
"e VARCHAR(100) NOT NULL, " +
" VARCHAR(100) NOT NULL)" stmt.executeUpdate(createTable);
// 处理表单提交
String action = request.getParameter("action" if("add"equals(action)) {
String userName = request.getParameter(
ame" String userEmail = request.getParameter("" if(userName != null && userEmail != null) {
String insertSql = "INSERT INTO users (name, email) VALUES (?, ?)" PreparedStatement pstmt = conn.prepareStatement(insertSql);
pstmt.setString(1, userName);
pstmt.setString(2, userEmail);
pstmt.executeUpdate();
}
}
// 显示用户列表
String selectSql = "*FROM users" rs = stmt.executeQuery(selectSql);
%>
| ID | 姓名 | 邮箱 | 操作 |
|---|---|---|---|
| <%= rs.getInt("id"> | <%= rs.getString("e"> | <%= rs.getString(""> |
<%
} catch(Exception e) {
out.println(": " + e.getMessage());
} finally {
if(rs != null) rs.close();
if(stmt != null) stmt.close();
if(conn != null) conn.close();
}
%>