jsp注册页面，检测用户名，删除用户名

上一篇 / 下一篇  2012-05-30 13:33:05 / 个人分类：web

查看( 2795 ) / 评论( 0 ) / 评分( 0 / 0 )

实现代码：regedit.jsp

<%@ page contentType="text/html;charset=GBK"%>
<script. language="javascript">
function on_submit()
 {
  if (form1.userid.value == "")
    {
     alert("用户名不能为空，请输入用户名！");
     form1.userid.focus();
     return false;
    }
    if (form1.password.value == "")
    {
     alert("用户密码不能为空，请输入密码！");
     form1.userpassword.focus();
     return false;
    }
    if (form1.password2.value == "")
    {
     alert("用户确认密码不能为空，请输入密码！");
     form1.password2.focus();
     return false;
    }
   if (form1.password.value != form1.password2.value)
    {
    alert("密码与确认密码不同");
    form1.password.focus();
     return false;
    }
 }
 function on_delected(){
 if (form2.delectname.value == "")
    {
     alert("用户名不能为空，请输入删除的用户名！");
     form2.delectname.focus();
     return false;
    }
 }
 function on_relogin()
 {
  window.location.href="../index.htm";
 }
</script>
<script. language="javascript">
function check(action)
{
 form1.action=action;
    form1.submit();
 if (form1.userid.value == "")
    {
     alert("用户名不能为空，请输入用户名！");
     window.location.href="regedit.jsp";
    }
}
</script>
<html>
<head>
<title>无标题文档</title>
</head>
<body>
<table border="1"  width=80% >
<tr>
<td colspan="5">
<div class="regedit_div" name="regedit1">
<form. name="form1" method="post" action="regeditln.jsp" nSubmit="return on_submit()">
用户名&nbsp;&nbsp;&nbsp;：
  <input type="text" name="userid"/>
  <input type="button" name="Button" value="检测用户" nClick="check('checkuser.jsp')">
  <p>密码&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;：
    <input type="password" name="password" value="123456"/>
</p>
  <p>确认密码&nbsp;：
    <input type="password" name="password2" value="123456"/>
  </p>
   <p>
     所在组&nbsp;&nbsp;&nbsp;：
   <select name="selectlogrole">
     <option value="testGroup" selected>测试组</option>
     <option value="guest">来访者</option>
     <option value="admin">管理员</option>
  <option value="development">开发组</option>
   </select>
 </p>
  <p align="left">
    <input type="submit" name="Submit" value="添加"/>
 <input type="button" name="relogin" value="重新登录" nclick="on_relogin()"/>
 <a href="../sindex.jsp">继续浏览</a>
  </p>
</form>
</div>
</td>
<td>
<div>
<form. action="delete.jsp" name="form2" nSubmit="return on_delected()">
<p>
删除名字：<input type="text" name="delectname">
</p>
<p>
<input type="submit" value="删除">
</p>
</form>
</div>
</td>
</tr>
</table>
</body>
</html>

regeditln.jsp

<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>

<%!
 public static final String DBDRIVER = "com.mysql.jdbc.Driver";
 public static final String userName = "root";
 public static final String userPasswd = "jwzhangjie";
 public static final String dbName = "test";  //数据库名
 public static final String tableName="tuser"; //表名
 public static final String DBURL = "jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
%>
<%
 Connection connection = null ;
 Statement statement = null;
 ResultSet rs = null ;
 ResultSetMetaData rmeta. = null;
%>
<%
  request.setCharacterEncoding("GBK");
        String name=request.getParameter("userid");
        String password=request.getParameter("password");
  String selected=request.getParameter("selectlogrole");
  
 try{
  Class.forName(DBDRIVER).newInstance();
  String str="select userid from tuser where userid='"+name+"'";
  connection=DriverManager.getConnection(DBURL);
  statement = connection.createStatement();
  rs = statement.executeQuery(str);
  if(rs.next()){ 
%>  
<script. language="javascript">
 alert("此用户已经被占用请重新注册");
 history.back();
</script>
<%
 }else{
  String sql="insert into tuser values('"+name+"','"+selected+"','"+password+"')";
  int sert=statement.executeUpdate(sql);
            if(sert ==1)
{ %>
<script. language="javascript">
 alert("添加成功");
 window.location.href="regedit.jsp";
</script>
<%
 }else
{
%>
<script. language="javascript">
 alert("添加失败！！");
        history.back();
 </script>
<%
  }
  }
 }catch(Exception e){
 }finally{
  try{
   connection.close() ; // 连接一关闭，所有的操作都将关闭
 }catch(Exception e){}
 }
%>

checkuser.jsp

<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>

<%!
 public static final String DBDRIVER = "com.mysql.jdbc.Driver";
 public static final String userName = "root";
 public static final String userPasswd = "jwzhangjie";
 public static final String dbName = "test";  //数据库名
 public static final String tableName="tuser"; //表名
 public static final String DBURL = "jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
%>
<%
 Connection connection = null ;
 Statement statement = null;
 ResultSet rs = null ;
 ResultSetMetaData rmeta. = null;
%>
<%
  request.setCharacterEncoding("GBK");
        String name=request.getParameter("userid");
  
 try{
  Class.forName(DBDRIVER).newInstance();
  String str="select userid from tuser where userid='"+name+"'";
  connection=DriverManager.getConnection(DBURL);
  statement = connection.createStatement();
  rs = statement.executeQuery(str);
  if(rs.next()){ 
%>  
<script. language="javascript">
 alert("此用户已经被占用");
 history.back();
</script>
<%  }else{
%>
<script. language="javascript">
alert("恭喜，此用户名可以使用");
 window.history.back();
</script>
<% 
}
 }catch(Exception e){
 }finally{
  try{
   connection.close() ; // 连接一关闭，所有的操作都将关闭
 }catch(Exception e){}
 }
%>

delete.jsp

<%@ page contentType="text/html; charset=GBK" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>

<%!
 public static final String DBDRIVER = "com.mysql.jdbc.Driver";
 public static final String userName = "root";
 public static final String userPasswd = "jwzhangjie";
 public static final String dbName = "test";  //数据库名
 public static final String tableName="tuser"; //表名
 public static final String DBURL = "jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
%>
<%
 Connection connection = null ;
 Statement statement = null;
 ResultSet rs = null ;
 ResultSetMetaData rmeta. = null;
%>
<%
  request.setCharacterEncoding("GBK");
        String name=request.getParameter("delectname");
  
 try{
  Class.forName(DBDRIVER).newInstance();
  String str="select userid from tuser where userid='"+name+"'";
  connection=DriverManager.getConnection(DBURL);
  statement = connection.createStatement();
  rs = statement.executeQuery(str);
  if(rs.next()){ 
  String sql="delete from tuser where userid='"+name+"'";
  int sert=statement.executeUpdate(sql);
            if(sert ==1)
{ %>
<script. language="javascript">
 alert("删除成功");
 window.location.href="regedit.jsp";
</script>
<%
 }else
{
%>
<script. language="javascript">
 alert("删除失败！！");
        history.back();
 </script>
<%
  }
  }else{
%>
<script. language="javascript">
 alert("无此用户，请重新输入");
 window.location.href="regedit.jsp";
</script>
<%  }
 }catch(Exception e){
 }finally{
  try{
   connection.close() ; // 连接一关闭，所有的操作都将关闭
 }catch(Exception e){}
 }
%>

 


 


收藏 举报

TAG: JSP jsp

 

评分：0

我来说两句

Open Toolbar