任务:编写jsp页面实现对数据库表的添加删除修改
这个任务与前面第七周查看数据表属于一个类型的任务,只需要在前面的代码稍加修改就行了,难度不大,下面是相关代码和运行后的界面图
<%@ page language="java" import="java.sql.*, java.lang.System" pageEncoding="UTF-8" %> <% try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { out.println("加载数据库驱动时抛出异常,内容如下:"); e.printStackTrace(); } Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost/how2java", "root", "admin"); Statement stmt = conn.createStatement(); int trn = stmt.executeUpdate("insert into tb_user(username,mypassword) values('hope','111')"); out.println("成功插入"+trn+"条"); // while (rs.next()) { // out.println("用户名:" + rs.getString(2) + " 密码:" + rs.getString(3) + "<br>"); // } // rs.close(); stmt.close(); conn.close(); %>
<%@ page language="java" import="java.sql.*, java.lang.System" pageEncoding="UTF-8" %> <% try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { out.println("加载数据库驱动时抛出异常,内容如下:"); e.printStackTrace(); } Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost/how2java", "root", "admin"); Statement stmt = conn.createStatement(); int trn = stmt.executeUpdate("delete from tb_user where username='333'"); out.println("成功删除"+trn+"条"); // while (rs.next()) { // out.println("用户名:" + rs.getString(2) + " 密码:" + rs.getString(3) + "<br>"); // } // rs.close(); stmt.close(); conn.close(); %>
<%@ page language="java" import="java.sql.*, java.lang.System" pageEncoding="UTF-8" %> <% try { Class.forName("com.mysql.jdbc.Driver"); } catch (ClassNotFoundException e) { out.println("加载数据库驱动时抛出异常,内容如下:"); e.printStackTrace(); } Connection conn = DriverManager.getConnection( "jdbc:mysql://localhost/how2java", "root", "admin"); Statement stmt = conn.createStatement(); int trn = stmt.executeUpdate("update tb_user set username='dream' where username='admin'"); out.println("成功修改"+ trn +"条"); // while (rs.next()) { // out.println("用户名:" + rs.getString(2) + " 密码:" + rs.getString(3) + "<br>"); // } // rs.close();,mypassword='123' stmt.close(); conn.close(); %>
这是进行添加删除修改结算后的数据表(由于我反复运行了几次,所以出现了一些相同行)