⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 adduser.jsp

📁 JSP+SQL2005 MVC模式 下载后改DB.java类的SQL密码就可用。
💻 JSP
字号:
<%@ page language="java" import="java.sql.ResultSet,java.util.ArrayList,java.sql.SQLException" contentType="text/html;charset=gb2312"%>
<jsp:useBean id="mydb" class="com.model.javabean.DB"/>
<%

 String a= request.getParameter("user");
 String b= request.getParameter("age");
 String c= request.getParameter("e-mail");
 String d= request.getParameter("password1");
 String e= (String)request.getParameter("gender");
 a=new String(a.getBytes("ISO-8859-1"),"gb2312");
 e=new String(e.getBytes("ISO-8859-1"),"gb2312");



 String sql1="select  * from yonghu where 昵称='"+a+"'";
		 ResultSet rs1= mydb.Read(sql1);
		try {
			if (rs1.next())
			{
			     out.println("<h1>用户名"+a+"已被注册,请重新输入</h1>");
				out.print("<script language = javascript>alert('用户名:"+a+"已被注册!');window.location.href='enrol1.jsp';</script>");
                rs1.close();
                
			}
			else{
			  out.println("*你的用户名为:" +a+"          \n"+"*密码为:"+d);
			  String sql="insert into yonghu (昵称,年龄,邮箱,密码,性别) values ('"+a+"','"+b+"','"+c+"','"+d+"','"+e+"')";
              ResultSet rs=mydb.Read(sql);
              out.print("<script language = javascript>alert(' 你已成功注册!请登陆');window.location.href='index.jsp';</script>");}
              
               	
		} catch (SQLException eee) {
		
			eee.printStackTrace();
		}
  
    

       
 


%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
   
    <title>My JSP 'shi1.jsp' starting page</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<!--
	<link rel="stylesheet" type="text/css" href="styles.css">
	-->

  </head>
  
  <body>
  
    <br>
  </body>
</html>


⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -