jdbc

最新推荐文章于 2022-11-23 21:28:13 发布

原创最新推荐文章于 2022-11-23 21:28:13 发布 · 739 阅读

0 ·

CC 4.0 BY-SA版权

Java 专栏收录该内容

25 篇文章

订阅专栏

import可以导入N个包，用“,”隔开即可。

改成这样试试
<%@ page import="java.sql.*,java.util.*"%>

简单数据库登录验证:

数据库:mysql

用户名:root

密码:root

数据库脚本:

create database user;
use user;
create table user_tb(id int auto_increment,username varchar(50),pwd varchar(50),primary key(id));
select * from user_tb;
insert into user_tb(username,pwd) values('admin','admin');
insert into user_tb(username,pwd) values('nicolas','nicolas');
insert into user_tb(username,pwd) values('alice','alice');

最简单的登录页面:

login.jsp

<%@ page contentType="text/html;charset=utf-8" %>
<html>

<head>
<title>欢迎来到登录页面</title>


</head>

<body>
<center>
<form action="check.jsp" method="post" >
帐号:<input type="text" name="username" id="username"/><br />
密码:<input type="text" name="password" id="password" /><br /><br />
<input type="submit" value="登录"/>
   <input type="reset" />
</form>
</center>
</body>

</html>

简单数据验证后台服务页面:

check.jsp:

<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="utf-8"%>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    
    <title>My JSP 'check.jsp' starting page</title>
  </head>
  
  <body>
  <%
  Class.forName("org.gjt.mm.mysql.Driver").newInstance();  
  String username=request.getParameter("username");
  String pwd=request.getParameter("password");
  String url ="jdbc:mysql://localhost/user?user=root&password=root&useUnicode=true&characterEncoding=utf-8"; 
  String sql="select * from user_tb where username='"+username+"' and pwd='"+pwd+"'";
  Connection conn= DriverManager.getConnection(url); 
  Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE); 
  ResultSet rs=stmt.executeQuery(sql); 
  if(rs.first())
  {
	  out.println("登录成功");
	  
  }
  else
  {
	  out.println("登录失败");
  }
  %>
  </body>
</html>