Spring_SSH整合之_架构的历史(两层架构整合JSP+MySQL)_1

最新推荐文章于 2022-11-27 14:16:43 发布

辐_射

最新推荐文章于 2022-11-27 14:16:43 发布

阅读量428

点赞数

分类专栏： Java Spring

本文链接：https://blog.csdn.net/L1585931143/article/details/72771140

版权

Java 同时被 2 个专栏收录

694 篇文章 3 订阅

订阅专栏

Spring

40 篇文章 0 订阅

订阅专栏

注册界面（JSP页面）：

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>用户注册</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">

</head>

<body>
	<h1>用户注册</h1><br/>
	<form action="registDeal.jsp" method="post">
		用户名：<input type="text" name="username"/><br/>
		密码：<input type="password" name="password"/><br/>
		确认密码：<input type="password" name="password2"/><br/>
		<input type="submit" value=" 提 交 "/>
	</form>
</body>
</html>

数据库页面：

<%@ page language="java" import="java.util.*, java.sql.*" pageEncoding="GB18030"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
String username = request.getParameter("username");
String password = request.getParameter("password");
String password2 = request.getParameter("password2");
Class.forName("com.mysql.jdbc.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/spring", "root", "root");

String sqlQuery = "select count(*) from user where username = ?";
PreparedStatement psQuery = conn.prepareStatement(sqlQuery);
psQuery.setString(1, username);
ResultSet rs = psQuery.executeQuery();
rs.next();
int count = rs.getInt(1);
if(count > 0) {
	response.sendRedirect("registFail.jsp");
	psQuery.close();
	conn.close();
	return;
}

String sql = "insert into user values (null, ?, ?)";
PreparedStatement ps = conn.prepareStatement(sql);
ps.setString(1, username);
ps.setString(2, password);
ps.executeUpdate();
ps.close();
conn.close();

response.sendRedirect("registSuccess.jsp");                 
%>

jsp页面：

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>失败</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">

</head>

<body>
	<h1>Fail!</h1>
</body>
</html>

<%@ page language="java" import="java.util.*" pageEncoding="GB18030"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>

<title>成功</title>

<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">

</head>

<body>
	<h1>Success!</h1>
</body>
</html>

辐_射

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
Spring_SSH整合之_架构的历史(两层架构整合JSP+MySQL)_1

注册界面（JSP页面）：用户注册用户注册用户名：密码：确认密码：数据库页面：<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="GB18030"%><% String path = request.getConte
复制链接

扫一扫

专栏目录