java修改数据库jsp页面_【JSP+JDBC编程】实现简单的数据库增删改查

JSP+JDBC技术完成用户管理功能#

【1】主界面模块##

1)index.jsp###

My JSP 'index.jsp' starting page

String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序

Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接

String sql = "select * from users";

PreparedStatement pStmt = conn.prepareStatement(sql);

ResultSet rs = pStmt.executeQuery();

%>

编号	姓名	密码	操作

while (rs.next()) {

%>

out.print(rs.getString("id"));

%>

out.print(rs.getString("username"));

%>

out.print(rs.getString("password"));

%>

" οnclick="return confirm('确定删除该条记录?')">删除 ">编辑

}

%>

添加新记录

//关闭

rs.close();

pStmt.close();

conn.close();

%>

新建模块##

1)register.jsp###

My JSP 'register.jsp' starting page

姓名：

密码：

2)add.jsp###

My JSP 'add.jsp' starting page

String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序

Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接

String sql = "insert into users values(null,?,?)";

PreparedStatement pStmt = conn.prepareStatement(sql);

String username = request.getParameter("username");

String password = request.getParameter("password");

pStmt.setString(1, username);

pStmt.setString(2, password);

int cnt = pStmt.executeUpdate();

if (cnt > 0) {

response.sendRedirect("index.jsp");

} else {

out.print("用户已存在，重新注册");

}

//关闭

pStmt.close();

conn.close();

%>

编辑模块##

1)edit.jsp###

My JSP 'edit.jsp' starting page

String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序

Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接

String id = request.getParameter("id");

String username = "";

String password = "";

String sql = "select * from users where id=?";

PreparedStatement pStmt = conn.prepareStatement(sql);

pStmt.setString(1, id);

ResultSet rs = pStmt.executeQuery();

while (rs.next()) {

username = rs.getString("username");

password = rs.getString("password");

}

%>

编号：

姓名：

密码：

//关闭

pStmt.close();

conn.close();

%>

2)modify.jsp###

My JSP 'modify.jsp' starting page

String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序

Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接

String sql = "update users set username=?,password=? where id=?";

PreparedStatement pStmt = conn.prepareStatement(sql);

String id = request.getParameter("id");

String username = request.getParameter("username");

String password = request.getParameter("password");

pStmt.setString(1, username);

pStmt.setString(2, password);

pStmt.setString(3, id);

pStmt.executeUpdate();

//关闭

pStmt.close();

conn.close();

response.sendRedirect("index.jsp");

%>

删除模块##

1)delete.jsp###

My JSP 'delete.jsp' starting page

String url = "jdbc:mysql://localhost:3306/testdb"; //数据库连接串

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); //加载驱动程序

Connection conn = DriverManager.getConnection(url, "root", "root"); //建立连接

String sql = "delete from users where id=?";

PreparedStatement pStmt = conn.prepareStatement(sql);

String id = request.getParameter("id");

pStmt.setString(1, id);

pStmt.executeUpdate();

//关闭

pStmt.close();

conn.close();

response.sendRedirect("index.jsp");

%>