//更新删除等操作 // index代码
<%@ page contentType="text/html;charset=UTF-8" language="java" %> <html> <title>注册页面</title> </head> <body> <form action="register.jsp" method="post"> 用户名： <input type="text" name="username"><br> 密码： <input type="text" name="password"><br> 年龄： <input type="text" name="age" ><br> 性别： <input type="text" name="gender" ><br> <button type="submit">注册</button> </form> </body> </html>//register代码
<%@ page import="java.sql.Connection" %> <%@ page import="java.sql.DriverManager" %> <%@ page import="java.sql.Statement" %> <%@ page import="javax.sql.RowSet" %><%-- Created by IntelliJ IDEA. User: 和 Date: 2020/9/23 Time: 9:42 To change this template use File | Settings | File Templates. --%> <%@ page contentType="text/html;charset=UTF-8" language="java" %> <jsp:useBean id="user" class="com.media.bean.UserBean"></jsp:useBean> <jsp:setProperty name="user" property="*"></jsp:setProperty> <% //加载数据库驱动 Class.forName("com.mysql.jdbc.Driver"); //连接数据库 String url = "jdbc:mysql://localhost:3306/whd"; Connection connection=DriverManager.getConnection(url,"root","root"); //使用Statement对象执行sql语句 Statement stmt=connection.createStatement(); //字符串类型的数据插入数据库必须使用单引号 数值类型不用使用单引号 //String sql="insert into user(username,password,gender,age) values ("+user.getUsername()+"," +user.getPassword()+"1,2)"; // String sql ="update from user where id=12"; String sql ="update whd set password =10 where id=11"; int count=stmt.executeUpdate(sql); if(count>0){ out.print("更新成功"); } else{ out.print("更新失败"); } %> <jsp:getProperty name="user" property="username"/>//Userbean代码
package com.media.bean; public class UserBean { private String username; private String password; private int gender; private int age; private int status; public String getUsername() { return username; } public void setUsername(String username) { this.username = username; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public int getGender() { return gender; } public void setGender(int gender) { this.gender = gender; } public int getAge() { return age; } public void setAge(int age) { this.age = age; } public int getStatus() { return status; } public void setStatus(int status) { this.status = status; } }//运行截图
