JSP连接mysql数据库实现用户登录

最新推荐文章于 2022-08-31 18:16:40 发布

奔跑的废柴

最新推荐文章于 2022-08-31 18:16:40 发布

阅读量1.7k

点赞数 1

分类专栏： JavaWeb课文章标签： JSP

本文链接：https://blog.csdn.net/weixin_42970433/article/details/102879407

版权

JavaWeb课专栏收录该内容

5 篇文章 0 订阅

订阅专栏

连接数据库基本操作就是这样，我用的是mysql，其他数据库同理。

<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<%@ page import="java.sql.*"%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>My JSP 'login.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">
	-->

  </head>
  <body bgcolor="#696969">
  <%  
  		String userid="";
  		String userpwd="";
        try {  
            Class.forName("com.mysql.jdbc.Driver");  驱动程序名
            String url = "jdbc:mysql://localhost:3306/091101"; //数据库名
            String username = "root";  //数据库用户名
            String password = "root";  //数据库用户密码
            Connection conn = DriverManager.getConnection(url, username, password);  //连接状态

            if(conn != null){             
                Statement stmt = null;  
                ResultSet rs = null;  
                String sql = "SELECT * FROM login;";  //查询语句
                stmt = conn.createStatement();  
                rs = stmt.executeQuery(sql);   
                while (rs.next()) { 
                 userid=rs.getString("id");
                 userpwd=rs.getString("pwd");
            	}  
            }
            else{  
                out.print("连接失败！");  
            }  
        }catch (Exception e) {        
            out.print("数据库连接异常！");  
        }  
	%>
	
		<form name="loginForm" action="b.jsp" method="post">
			<table  align="center">
			<tr>
			<th>
			用户名：<input name="account" type="text">
			</th>
			</tr>
			<tr>
			<th>
			密码：<input name="password" type="password">
			</th>
			</tr>
			<tr>
			<th>
			<input type="button" value="登录" onClick="validate()">
			</th>
			</tr>
			</table>
		</form>
	
	
	<script type="text/javascript">
  	function validate(){
  		var aid=<%=userid%>;
  		var apwd=<%=userpwd%>;
  		var bid= loginForm.account.value;
  		var bpwd= loginForm.password.value;
  		if(aid==bid&&apwd==bpwd){
  			loginForm.submit();
  		}
  		else{
  			alert("账号或密码错误");
  			return;	
  		}
  	}
	</script>   
  </body>
</html>