📄 regdit.jsp

📁 一个自己完成的网上书店
💻 JSP
字号:
<%@ page language="java" import="java.util.*,java.sql.*"
	pageEncoding="gb2312"%>
<%
request.setCharacterEncoding("GB2312");
%>
<%
	String path = request.getContextPath();
	String basePath = request.getScheme() + "://"
			+ request.getServerName() + ":" + request.getServerPort()
			+ path + "/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<base href="<%=basePath%>">

		<title>欢迎注册</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>
		<%!String nicheng, password, password1, name, email, address, sex,
			passwordproblem, passwordanswer, notes;

	boolean regattempt = false;%>
		<%
			response.setCharacterEncoding("gbk");
			nicheng = request.getParameter("name");

			password = request.getParameter("password");
			password1 = request.getParameter("password1");
			name = request.getParameter("name");
			name = new String(name.getBytes("ISO-8859-1"), "GB2312");
			out.println(nicheng);
			email = request.getParameter("email");
			address = request.getParameter("address");
			sex = request.getParameter("sex");
			passwordproblem = request.getParameter("passwordproblem");
			passwordanswer = request.getParameter("passwordanswer");
			notes = request.getParameter("notes");

			if (sex.equalsIgnoreCase("1")) {
				sex ="1";
			} else {
				sex = "2";
			}
			if (passwordproblem.trim().equals("")) {
				passwordproblem = null;
			}
			if (passwordanswer.trim().equals("")) {
				passwordanswer = null;
			}
			if (notes.trim().equals("")) {
				notes = null;
			}
			Class.forName("com.mysql.jdbc.Driver").newInstance();
			//连接数据库
			Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/bookstore?user=root&password=ptnest&useUnicode=true&characterEncoding=gb2312" ); 
  			Statement stmt=con.createStatement();
			String sql = "select *from user where name='" + nicheng + "'";
			ResultSet rs = stmt.executeQuery(sql);
			int number = 0;
			try {
				while (rs.next()) {
					number++;
				}
			} catch (Exception e) {
				out.println("对不起该用户名已经存在！");
			}
			if (number == 0) {
				regattempt = true;
			} else {
				response.sendRedirect("reregdit.html");
			}
			out.println(1);
			if (regattempt == true) {
				String sql1 = "insert into user(name,pass,real_name,email,address,sex,quesstion,answer,content)Values('"
				+ nicheng
				+ "','"
				+ password
				+ "','"
				+ name
				+ "','"
				+ email
				+ "','"
				+ address
				+ "','"
				+ sex
				+ "','"
				+ passwordproblem
				+ "','"
				+ passwordanswer
				+ "','"
				+ notes + "')";
				try {
					stmt.executeUpdate(sql1);
					rs.close();
					con.close();
					
					out.println("OK!");
					response.sendRedirect("list.jsp");
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		%>
	</body>
</html>
⌨️ 快捷键说明

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