JSP用户注册执行代码(可防止重名注册)2009-04-23 16:331. 表单 传到此页面
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" import="java.sql.*"%>
<%
final String DBDRIVER = "org.gjt.mm.mysql.Driver" ;
final String DBURL = "jdbc:
mysql://localhost:3306/pci";
Connection conn = null ;
ResultSet rs = null ;
String name=null;
String password=null;
String reg_name=request.getParameter("username");
String reg_pass=request.getParameter("pass
word");
Statement st=null;
PreparedStatement stat=null;
boolean flag=true;
try
{
Class.forName(DBDRIVER) ;
conn = DriverManager.getConnection(DBURL,"root","root") ;
st=conn.createStatement();
rs = st.executeQuery("select * from admin") ;
while(rs.next())
{
if(reg_name.equals(rs.getString(1))){
out.println("
请重新注册");
out.println("");
flag=false;
break;
}
}
if (flag){
stat=conn.prepareStatement("insert admin values(?,?)");
stat.setString(1,reg_name);
stat.setString(2,reg_pass);
stat.executeUpdate();
out.println("
注册成功");
out.println("
您的用户名是:"+reg_name+"");
out.println("
您的密码是: "+reg_pass+"");
stat.close();
String name_reged=null;
session.putValue("name_reged",reg_name);
out.println("");
}
rs.close() ;
conn.close() ;
}
catch(Exception e)
{
out.println(e);
}
%>
2. 把登陆界面提交到处理下面的页 :
<%
//获取提交的用户名和密码
String name=request.getParameter("name");
String pass=request.getParameter("pass");
//连接数据库
String driverName = “com.microsoft.jdbc.sqlserver.SQLServerDriver”;
String dbURL = “jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs”;
String userName = “sa”;
String userPwd = “”;
try {
Class.forName(driverName);
Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt=conn.createStatement();
//数据库查询语句
String sql="select * from admin where username='"+name+"' and userpass='"+pass+"'";
ResultSet rs=stmt.executeQuery(
sql);
//判断用户是否存在
if(rs.next())
{
//记得把用户名写入session
session.setAttribute("username",name);
//转向登陆后的界面
response.sendRedirect("main.jsp");
}
else
{
%>
<%
//response.sendRedirect("main.jsp");
}
//关闭 结果集 会话 和 连接
rs.close(
);
stmt.close();
connect.close();
%> 首先把登陆界面提交到处理页,
在处理页:
<%
//获取提交的用户名和密码
String name=request.getParameter("name");
String pass=request.getParameter("pass");
//连接数据库
String driverName = “com.microsoft.jdbc.sqlserver.SQLServerDriver”;
String dbURL = “jdbc:microsoft:sqlserver://localhost:1433; DatabaseName=pubs”;
String userName = “sa”;
String userPwd = “”;
try {
Class.forName(driverName);
Connection dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
Statement stmt=conn.createStatement();
//数据库
查询语句
String sql="select * from admin where username='"+name+"' and userpass='"+pass+"'";
ResultSet rs=stmt.executeQuery(sql);
//判断用户是否存在
if(r