实现用户注册
1.首先创建数据表tb_userinfo 只有3个字段 id username password
2.使用JavaBean封装数据表的字段 .....
3.创建用户注册的首页面
<form action = "register.jsp" method= "post" name = "form1">
<table align = "center">
<tr><td><h3>用户注册</h3></td></tr>
<tr><td>账号:<input type = "text" name = "username"></td></tr>
<tr><td>密码:<input type = "text" name = "password"></td></tr>
<tr>
<td>
<input type = "submit" value = "注册" >
</td>
</tr>
</table>
</form>
4,register.jsp 用户提交后的处理页
<body>
<jsp:useBean id="userinfo" class = "com.model.UserInfo"></jsp:useBean>
<jsp:setProperty property="*" name="userinfo"/>
<%
try{
Class.forName("com.mysql.jdbc.Driver");
String url = "jdbc:mysql://localhost:3306/db_blog";
String username = "root";
String pwd = "hellosql";
Connection conn = DriverManager.getConnection(url,username,pwd);
String sql = "insert into tb_userinfo(username,password) values(?,?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1,userinfo.getUsername());
ps.setString(2,userinfo.getPassword());
int rows = ps.executeUpdate();
if(rows >0){
out.println("注册成功");
}
ps.close();
conn.close();
}catch(Exception e){
out.println("添加数据失败");
e.printStackTrace();
}
%>
<a href = "index.jsp">返回</a>
</body>