adduser.jsp

课程设计中的在线书店源码

<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<jsp:useBean id="conn" class="dbBean.DBBean" scope="session"/>
<jsp:setProperty name="conn" property="connStr" value="jdbc:odbc:forum"/>
<link rel="stylesheet" type="text/css" href="style.css"/>
<%
request.setCharacterEncoding("gb2312");
String name="";
String password="";
String sex="";
String age="";
String phone="";
String email="";
String address="";
String face="";
ResultSet  rs=null;
if(request.getParameter("username")!=null)
	name=request.getParameter("username");
if(request.getParameter("password")!=null)
	password=request.getParameter("password");
if(request.getParameter("sex")!=null)
	sex=request.getParameter("sex");
if(request.getParameter("age")!=null)
	age=request.getParameter("age");
if(request.getParameter("phone")!=null)
	phone=request.getParameter("phone");
if(request.getParameter("email")!=null)
	email=request.getParameter("email");
if(request.getParameter("address")!=null)
	address=request.getParameter("address");
if(request.getParameter("face")!=null)
	face=request.getParameter("face");
	String sql="select * from user where name='"+name+"'";
	rs=conn.executeQuery(sql);
	if(rs.next())
	{
		rs.close();
		out.println("<center><h2>对不起，该用户名已经被占用，请另选一个用户名！<br></h2>");
		out.println("<a href='javascript:history.back()'>返回</a></center>");	
	}
	else
	{
		sql="insert into user(name,password,sex,age,phone,email,address,rank,pubnum,face) values('"+name+"','"+password+"','"+sex+"','"+age+"','"+phone+"','"+email+"','"+address+"',0,0,'"+face+"')";	
		conn.executeUpdate(sql);
		out.println("<center><h2>恭喜您，注册成功！<br></h2>");
		out.println("<a href='login.jsp'>返回登录页面</a></center>");	
	}
	conn.close();	    
%>