实验04JDBC20130901增删改查的实验指导.docVIP

实验四： JDBC数据库连接 使用mysql数据库，实现记录插入： DBInsertLogin.jsp %@page contentType=text/html;charset=gbk% form id=form1 name=form1 method=post action=DBInsert.jsp label br / 姓名 input name=name type=text / br / /label label 密码 input name=pwd type=password / /label label br / input type=submit name=Submit value=insert / /label /form DBInsert.jsp： %@page contentType=text/html;charset=gbk% %@page import=java.sql.*% % String sname = request.getParameter(name); String spwd = request.getParameter(pwd); Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager .getConnection(jdbc:mysql://localhost/test,root,admin); Statement sql = con.createStatement(); ResultSet rs = sql .executeQuery(select * from user where username= + sname + and password= + spwd + ); if (rs.next()) out.print(用户已存在 !); else { sql.executeUpdate(Insert into user(username,password) values( + sname + , + spwd + )); out.print( 用户 + sname + 的 信息已被插入！); } con.close(); % 使用Access数据库，实现记录删除、更新： DBDeleteLogin.jsp: %@page contentType=text/html;charset=gbk% form id=form1 name=form1 method=post action=DBDelete.jsp label 输入要删除纪录的用户的id： input name=id type=text id=id / /label label input type=submit name=Submit value=提交 / /label /form DBDelete.jsp: %@page contentType=text/html;charset=gbk% %@page import=java.sql.*% % String sid=request.getParameter(id); Class.forName(com.mysql.jdbc.Driver); Connection con = DriverManager .getConnection(jdbc:mysql://localhost/test,root,admin); Statement sql = con.createStatement(); ResultSet rs = sql .executeQuery(select * from user where id= + sid+ ); if(rs.next()) {sql.executeUpdate(Delete from user where id=+sid+); out.print(sid+号用户信息已被删除！);} con.close(); % DBUpdateLogin.jsp %@page contentType=text/html;charset=gbk% form id=form1 name=form1 method=post action=DBUpdate.jsp label 输入要修改的用户id： input name=id type=text / /label labelbr / 输入要修改的用户姓名： input name=username type=text / /l