JAVA语言 web3 注册（web2.jsp）-职坐标

JAVA语言 web3 注册（web2.jsp）

小标 2018-12-19 来源：阅读 1000 评论 0

摘要：本文主要向大家介绍了JAVA语言 web3 注册（web2.jsp），通过具体的内容向大家展示，希望对大家学习JAVA语言有所帮助。

本文主要向大家介绍了JAVA语言 web3 注册（web2.jsp），通过具体的内容向大家展示，希望对大家学习JAVA语言有所帮助。

web2.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"

pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title></title>
</head>
<body background="image/1.jpg"style=" background-repeat:no-repeat ;
background-size:100% 100%;
background-attachment: fixed;" >

<p align="center">
<h1>注册表</h1>
<br><br><br>
<form action="web2-1.jsp" method="post">
id:<input type="text"name="id">&nbsp *
<br><br>
密码:<input type="password"name="passward">&nbsp*
<br><br>
昵称:<input type="text"name="name">&nbsp*
<br><br>
<input type="submit" value="注册">
</form>
</p>
</body>
</html>

web2-1.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "https://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
<%
String drivername="com.mysql.jdbc.Driver";
String username="root";
String userpwd="test";
String dbname="sys";
String url1="jdbc:mysql://localhost:3306/"+dbname;
String url2="?user="+username+"&password="+userpwd;
String url3="&useUnicode=true&characterEncoding=UTF-8";
String url=url1+url2+url3;
Class.forName(drivername);
Connection conn=DriverManager.getConnection(url);

String sql="select id from register";
PreparedStatement pstmt=conn.prepareStatement(sql);
ResultSet rs=pstmt.executeQuery();
String id=request.getParameter("id");
int flag=0;
while(rs.next()){
String str1=rs.getString("id");

if(id.equals(str1)){
out.print("用户名已被注册请重新输入！");
flag=1;
break;
}}
if(flag==0){
String pwd=request.getParameter("passward");
String name=request.getParameter("name");
String sq="Insert into register(id,password,name)values(?,?,?)";
PreparedStatement pstmt2=conn.prepareStatement(sq);
pstmt2.setString(1, id);
pstmt2.setString(2, pwd);
pstmt2.setString(3, name);
int n=pstmt2.executeUpdate();
if(n==1){
out.print("注册成功！");
}

}
%>
</body>
</html>