javaweb -jsp中访问数据库

最新推荐文章于 2021-02-11 15:33:32 发布

袁祺

最新推荐文章于 2021-02-11 15:33:32 发布

阅读量156

点赞数

分类专栏： JavaWeb

本文链接：https://blog.csdn.net/weixin_44130043/article/details/101116581

版权

JavaWeb 专栏收录该内容

19 篇文章 0 订阅

订阅专栏

配置方面于JDBC大体相似

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<form action="check.jsp" method = "post">
		用户名：<input type = "text" name = "uname">
		密码：<input type = "text" name = "upassword">
		<input type = "submit" value="登陆">
	</form>

</body>
</html>

check.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8" %>
<%@ page import = "java.sql.*" %>
<%@ page import = "java.util.Properties" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<%
	 java.sql.Driver driver = (java.sql.Driver) Class.forName("com.mysql.jdbc.Driver").newInstance();
	
	Properties properties = new Properties();
	properties.put("user", "root");
	properties.put("password", "root");
	String url = "jdbc:mysql://127.0.0.1:3306/jsp-jdbc";
	Connection connect = driver.connect(url, properties);
	String name = request.getParameter("uname");
	String password = request.getParameter("upassword");
	
	String sql = "SELECT id FROM userdata WHERE username = '"+name+"' and password = '"+password+"'";
	
	Statement statement = connect.createStatement();
	
	ResultSet resultSet = statement.executeQuery(sql);
	
	if(resultSet.next()){
		request.getRequestDispatcher("success.jsp").forward(request,response);
	}else{
		out.print("用户名或密码错误！");
	}
		
	%>
	<a href = "login.jsp" >返回</a>

</body>
</html>

success.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>Insert title here</title>
</head>
<body>
	<% 
		String name = request.getParameter("uname");
		String password = request.getParameter("upassword");
		
		out.print(name + "<br/>");
		out.print(password);
	%>
	

</body>
</html>

袁祺

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
javaweb -jsp中访问数据库

配置方面于JDBC大体相似login.jsp<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w...
复制链接

扫一扫