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

📄 register0.jsp

📁 jsp+sqlserver2000+tomcat做的教材管理系统。基本功能全部实现
💻 JSP
字号:
<%@ page language="java" contentType="text/html; charset=gb2312"
	pageEncoding="gb2312" errorPage="../error.jsp"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
	<head>
		<title>My JSP 'register.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">
	-->
		<link href="../style.css" rel="stylesheet" type="text/css">
	</head>
	<jsp:useBean id="myRs" scope="page" class="utils.DBManager" />
	<%
		String sql = null;
		java.sql.ResultSet rs = null;
		String message = "";
		String type = "";
		String userid = "";
		String password = "";
	%>
	<%
		request.setCharacterEncoding("gb2312");
		type = request.getParameter("type");
		if(type!=null){
		userid = request.getParameter("userid");
		password = request.getParameter("password");
		String sql1 = "insert into users (levels,";
		String sql2 = "values(1,";
		if (userid != null) {
			sql1 += "userid,";
			sql2 += "'" + userid + "',";
		}
		if (password != null) {
			sql1 += "password,";
			sql2 += "'" + password + "',";
		}
		sql1 = sql1.substring(0, sql1.length() - 1);
		sql2 = sql2.substring(0, sql2.length() - 1);
		sql1 += ")";
		sql2 += ")";
		sql = sql1 + sql2;

		try {
			int i = myRs.executeUpdate(sql);
			message = "注册用户成功!<a href=\"../index.jsp\">登录</a>";
		} catch (Exception e) {
			e.printStackTrace();
			message = "注册用户失败!该用户已存在,请后退,或者重新注册!";
		} finally {
			myRs = null;
		}
	}
	%>
	<body>
		<table width="1024" border="0" align="center">
			<tr>
				<td>
					<img src="../MainImages/Top.jpg" width="1024" height="126">
				</td>
			</tr>
			<tr>
				<td>
					<table width="100%" height="300" border="1">
						<tr>
							<td>
								<form name="form" method="post" action="register.jsp?type=add">
									<table width="50%" border="1" align="center">
										<tr>
											<td width="35%">
												<div align="right">
													用户帐号:
												</div>
											</td>
											<td width="65%">
												<div align="left">
													<label>
														<input name="userid" type="text" size="40">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td>
												<div align="right">
													用户密码:
												</div>
											</td>
											<td>
												<div align="left">
													<label>
														<input name="password" type="password" size="40">
													</label>
												</div>
											</td>
										</tr>
										<tr>
											<td colspan="2">
												<div align="center">
													<label>
														<input type="submit" name="Submit" value="注册">
													</label>
												</div>
											</td>
										</tr>
									</table>
								</form>
								<center>
									<%=message%>
								</center>
							</td>
						</tr>
					</table>
				</td>
			</tr>
			<tr>
				<td>
					<p align="center">
						<img src="../MainImages/bottom.gif" width="1024" height="80"
							border="0" usemap="#Map">
					</p>
				</td>
			</tr>
		</table>
	</body>
</html>

⌨️ 快捷键说明

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