201819102036张祺9-26
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html><head><title>$Title$</title></head><body><form method="post" action="register.jsp">用户名：<input type="text" name="username"><br>密码：<input type="text" name="password"><br>性别：<input type="text" name="gender"><br>年龄：<input type="text" name="age"><br><button type="submit">注册</button></form></body>
</html>register.jsp
<jsp:useBean id="user" class="bean.User"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty><%//User user = new User();//userBean.setUsername(request.getParameter("username");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="insert into user(username,password,gender,age) values('"+user.getUsername()+"','"+user.getPassword()+"',1,23)";Statement stmt = connection.createStatement();int count = stmt.executeUpdate(sql);if(count == 0){out.print("注册失败");}else{out.print("注册成功");}%><jsp:getProperty name="user" property="username"/>User
package media;public class User {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;}
}
实现数据库的增删改查的操作
1.使用Statement增加数据
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<jsp:useBean id="user" class="bean.User"></jsp:useBean>
<jsp:setProperty name="user" property="*"></jsp:setProperty>
<%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="insert into user(username,password,gender,age) values('"+user.getUsername()+"','"+user.getPassword()+"',1,23)";Statement stmt = connection.createStatement();int count = stmt.executeUpdate(sql);if(count == 0){out.print("注册失败");}else{out.print("注册成功");}%><jsp:getProperty name="user" property="username"/>使用PreparedStatement增加数据
<%Class.forName("com.mysql.jdbc.Driver");String url ="jdbc:mysql://127.0.0.1:3306/book";Connection connection = DriverManager.getConnection(url,"book","book");String sql = "insert into user(username,password,gender,age) values (?,?,?,?)";PreparedStatement Ws = connection.prepareStatement(sql);Ws.setString(1,request.getParameter("username"));Ws.setString(2,request.getParameter("password"));
Ws.setInt(3,request.getParameter("gender"));
Ws.setInt(4,request.getParameter("age"));ResultSet rs = Ws.executeQuery();%>
本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！