SQL Server实现用户注册
时间:2021-07-01 10:21:17
帮助过:5人阅读
form action
="zhuChe.jsp" method
="post" onsubmit
="
return reg(this);"
>
<div id
="div2"
>
<p style
="margin
-left:30px"
><img src
="
image/pic_zc.gif"
></img
></p
>
<div style
="width:350px;height:20px;margin
-left:30px;margin
-top:
-10px"
>
<p
><hr
/></p
>
</div
>
<p style
="margin
-left:70px"
>请填写您的姓名:
<input type
="
text" name
="userName"
></p
>
<p style
="margin
-left:200px;margin
-top:
-10px;font
-size:12px"
>请填写有效的Name作为下次登入的用户名,同时我们也会这个地址发送您的账户信息、订单通知等。
</p
>
<p style
="margin
-left:100px"
>请设定密码:
<input type
="password" value
="" name
="password" datatype
="
*6-15" errormsg
="密码范围在6
~15位之间,不能使用空格!"
/></p
>
<p style
="margin
-left:35px"
>请再次输入设定密码:
<input type
="password" value
="" name
="repassword" datatype
="
*" recheck
=password" errormsg
="您两次输入的账号密码不一致!"
/></p
>
<p style
="margin
-left:80px"
>请输入验证码:
<input type
="
text" name
="yanz" style
="width:50px"
></p
>
<p style
="margin
-left:250px;margin
-top:
-40px;"
><img src
="
image/code_img.gif"
></img
></p
>
<p style
="margin
-left:250px;margin
-top:
-15px;font
-size:12px"
>看不清换一张
</p
>
<p style
="
text-align:center;"
>请阅读
<a href
><font color
="red" style
="font
-weight:bold"
>《"V
+网站"服务条款》
</font
></a
></p
>
<p style
="
text-align:center;"
><img src
="
image/sumit_bg.gif"
></img
></p
>
<p style
="margin
-left:129px;font
-weight:bold;color:#fff;margin
-top:
-41px;"
><input type
="submit" value
="同意以上条款并注册" style
="color:#8D0223"
></p
>
</div
>
<!
--右边div框架结束-->
</form
>
<%@ page language="java" import="java.util.*" pageEncoding="utf-8"%>
<%@page import="jdbc.sqlServer"%>
<%@page import="java.sql.Connection"%>
<%@page import="java.sql.ResultSet"%>
<%@page import="java.sql.PreparedStatement"%>
<%
String userName = request.getParameter("userName");
userName = new String( userName.getBytes("ISO-8859-1"),"utf-8");
String money = request.getParameter("money");
String password = request.getParameter("password");
if(userName==null && password==null){
%> <script type="text/javascript">
alert("用户名或密码不为空");
location="doLog.jsp";
</script>
<%
}
%>
<%
//引用连接数据库方法
sqlServer sq=new sqlServer();
//得到数据库连接
Connection con = sq.getConnection();
//编写sql语句
String sql="insert into Admin values (?,?,?)";
//得到数据库操作对象
PreparedStatement st =con.prepareStatement(sql);
st.setString(1,userName);
st.setInt(2,200);
st.setString(3,password);
// 得到查询的结果
if(st.executeUpdate()>0){
%>
<script type="text/javascript">
alert("注册成功");
location="LinDao.jsp";
</script>
<%
}else{
%>
<script language="javascript">
function check(){
if (password!=password2){
alert("两次密码输入不一致,你看着办吧!");
}
return true;
}
</script>
<%
}
%>
SQL Server实现用户注册
标签: