<%@ page language="java" contentType="text/html; charset=UTF-8"
pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
pageEncoding="UTF-8"%>
<%@ page import="java.io.*,java.util.*,java.sql.*"%>
<%@ page import="javax.servlet.http.*,javax.servlet.*" %>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ taglib uri="http://java.sun.com/jsp/jstl/sql" prefix="sql"%>
<!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>
<%
<title>Insert title here</title>
</head>
<body>
<%
String username=request.getParameter("username");
String password=request.getParameter("password");
String password=request.getParameter("password");
String driverName="com.mysql.jdbc.Driver";//驱动
String userName="root";
String userPasswd="123456";
String dbName="mysql"; //数据库名
String tableName="websites";// 表名
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd; //可直接写路径,这里写变量是为了防止出错
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
User=rs.getString("账号"); //此处“账号” “密码”为数据库中的名字,即User,Psw包含数据库中所有值
Psw=rs.getString("密码");
String userName="root";
String userPasswd="123456";
String dbName="mysql"; //数据库名
String tableName="websites";// 表名
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd; //可直接写路径,这里写变量是为了防止出错
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn=DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = stmt.executeQuery(sql);
while(rs.next()) {
User=rs.getString("账号"); //此处“账号” “密码”为数据库中的名字,即User,Psw包含数据库中所有值
Psw=rs.getString("密码");
if(User.equals("username")&&Psw.equals("password")) //表单的值与数据库中数据进行对比判断是否存在
{
response.sendRedirect("/index.jsp");
}
{
response.sendRedirect("/index.jsp");
}
}
rs.close();
stmt.close();
conn.close();
%>
</body>
</htm>
rs.close();
stmt.close();
conn.close();
%>
</body>
</htm>
在ecllise环境下需要JSP标准库,同时也需要下载jstl.jar和standrad.jar库,可在菜鸟驿站下载。与数据库连接需要mysql-connector-java-bin.jar库(这几个文件放在WEB-INF下的lib目录下,完事后在菜单project下选择properties,将这三个.jar文件加入,截图如下)