📄 zhuce.jsp

📁 网上花店销售系统
💻 JSP
字号:

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page import="java.util.*" %>
<%@page import="java.sql.*"%>
<%!    
        String username;
        String password1;
		String password2;
	String question;
	String answer;
	String realname;
	String sex;
	String dizhi;
	String email;
	String qq;
	String web;
		String DBDriver="sun.jdbc.odbc.JdbcOdbcDriver";
		String ConnStr="jdbc:odbc:zhuce";
%>
<%
    username=request.getParameter("username");
	password1=request.getParameter("password1");
	password2=request.getParameter("password2");
	question=request.getParameter("question");
	answer=request.getParameter("answer");
	realname=request.getParameter("realname");
	sex=request.getParameter("sex");
	dizhi=request.getParameter("dizhi");
	email=request.getParameter("email");
	qq=request.getParameter("qq");
	web=request.getParameter("web");
	if(username.equals("")||password1.equals("")||password2.equals(""))
		{
		out.println("带*为必填项,请您重新填写,谢谢!<p>您将在3秒钟后返回注册页");
		response.setHeader("Refresh","3;URL=zhuce.htm");
		return;
	}
	if(!password1.equals(password2)){
	out.println("您填写的两次密码不一致,请重新填写!<p>您将在3秒钟后返回注册页");
	response.setHeader("Refresh","3;URL=zhuce.htm");
	return;

	}
   
String sql="insert into huiyuan(username,password1,password2,question,answer,realname,sex,dizhi,email,qq,web) values ('"+username+"','"+password1+"','"+password2+"','"+question+"','"+answer+"','"+realname+"','"+sex+"','"+dizhi+"','"+email+"','"+qq+"','"+web+"')";

	try	
		{
			Class.forName(DBDriver);//加载JDBC驱动程序
		}
	catch(java.lang.ClassNotFoundException e)
		{
			System.err.println("database:"+e.getMessage());
			out.println("驱动没有加载");
		}

	try
		{
			Connection conn=DriverManager.getConnection(ConnStr," "," ");
			
			Statement stmt=conn.createStatement();

			stmt.executeUpdate(sql);
			
			out.println("您已经注册成功! "+"<br>");
			stmt.close();
			conn.close();
		}
	catch(SQLException e)
		{
			System.err.println("executeUpdate:"+e.getMessage());
			out.println("数据没有写入");
		}

    %>
<p>您注册的资料如下：
<body bgcolor="#FFdcdc">
<p align="center"> 
  <%
	out.println("用户名："+username+"<br />");
	out.println("密码："+password1+"<br />");
	out.println("密码问题："+question+"<br />");
	out.println("问题答案："+answer+"<br />");
	out.println("真实姓名："+realname+"<br />");
	out.println("性别："+sex+"<br />");
	out.println("地址："+dizhi+"<br />");
	out.println("Email地址："+email+"<br/>");
	out.println("QQ号码："+qq+"<br />");
	out.println("主页："+web+"<br />");
	response.setHeader("Refresh","3;URL=index.htm");%>
<p>3秒钟后你将返回首页<p><p>

</BODY>
</HTML>
⌨️ 快捷键说明

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