201819102035田美玉

最新推荐文章于 2023-12-13 10:50:02 发布

weixin_50391037

最新推荐文章于 2023-12-13 10:50:02 发布

阅读量58

点赞数

本文链接：https://blog.csdn.net/weixin_50391037/article/details/108875622

版权

201819102035田美玉

<body>
public class User
{ private String username;
private int gender;
private String password;
private int age;
public String getUsername()
{ return username; }
public void setUsername(String username)
{ this.username = username;
} public int getAge()
{ return age;
} public void setAge(int age)
{ this.age = age;
} public int getGender()
{ return gender;
} public void setGender(int gender)
{ this.gender = gender;
} public String getPassword()
{ return password;
} public void setPassword(String password)
{ this.password = password;
}
}

    <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>

<jsp:useBean id="user" class="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); 
// 获得链接对象 //alt+回车 自动导入类 
// 创建Statement对象，执行aql语句 
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"/>