实现增删改查
首先是增加和删除
建立Java Bean文件
user.java
建立index.jsp
建立连接jsp文件 register.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <jsp:useBean id="user" class="com.name.user"> </jsp:useBean> <jsp:setProperty name="user" property="*"></jsp:setProperty> <% //user userbean = new user(); Class.forName("com.mysql.jdbc.Driver"); String url ="jdbc:mysql://127.0.0.1:3306/book?user=root&password=root"; Connection connection = DriverManager.getConnection(url); String sql = "delete from user where id=12"; Statement stmt = connection.createStatement(); int count = stmt.executeUpdate(sql); if(count == 0){ out.print("删除成功"); }else{ out.print("删除失败"); } %>
改和删