jsp实现用户验证数据库登陆、查询数据库信息

简单地实现了通过jsp使用jdbc连接数据库验证用户登陆信息，用户查询到的数据库信息显示到网页上，改一改数据库的东西就能用

package com.servlet;


import java.io.IOException;  
import java.sql.Connection;  
import java.sql.DriverManager;  
import java.sql.ResultSet;  
import java.sql.Statement;  
import java.util.ArrayList;  
import java.util.HashMap;  
import java.util.List;  
import java.util.Map;  
 

import javax.servlet.ServletException;  
import javax.servlet.annotation.WebServlet;  
import javax.servlet.http.HttpServlet;  
import javax.servlet.http.HttpServletRequest;  
import javax.servlet.http.HttpServletResponse; 

@WebServlet（“/query“）
public class query extends HttpServlet {
	private static final long serialVersionUID = 1L;
	private static String jdbcDriver=“com.mysql.jdbc.Driver“;

	public static String jdbcUrl = “jdbc:mysql://127.0.0.1:3306/security“;
	public static Strin

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----

     文件       1077  2018-04-27 00:26  Security\.classpath

     文件       1041  2018-03-16 14:52  Security\.project

     文件        503  2018-03-16 14:52  Security\.settings\.jsdtscope

     文件        106  2018-04-27 11:51  Security\.settings\org.eclipse.core.resources.prefs

     文件        364  2018-03-16 14:52  Security\.settings\org.eclipse.jdt.core.prefs

     文件        476  2018-03-16 14:52  Security\.settings\org.eclipse.wst.common.component

     文件        345  2018-03-16 14:52  Security\.settings\org.eclipse.wst.common.project.facet.core.xml

     文件         49  2018-03-16 14:52  Security\.settings\org.eclipse.wst.jsdt.ui.superType.container

     文件          6  2018-03-16 14:52  Security\.settings\org.eclipse.wst.jsdt.ui.superType.name

     文件       4120  2018-05-26 14:28  Security\build\classes\com\servlet\query.class

     文件       2734  2018-05-31 14:20  Security\src\com\servlet\query.java

     文件       1057  2018-04-26 13:13  Security\WebContent\Login.jsp

     文件       2159  2018-04-28 10:51  Security\WebContent\login_check.jsp

     文件         39  2018-03-16 14:52  Security\WebContent\meta-INF\MANIFEST.MF

     文件       1900  2018-04-27 11:53  Security\WebContent\show.jsp

     文件      20682  2018-04-27 00:18  Security\WebContent\WEB-INF\lib\jstl-1.1.2.jar

     文件     512707  2016-05-10 13:34  Security\WebContent\WEB-INF\lib\mysql-connector-java-5.0.5-bin.jar

     文件     393259  2018-04-27 00:18  Security\WebContent\WEB-INF\lib\standard-1.1.2.jar

     文件        654  2018-04-26 17:11  Security\WebContent\WEB-INF\web.xml

     目录          0  2018-05-26 14:28  Security\build\classes\com\servlet

     目录          0  2018-05-26 14:28  Security\build\classes\com

     目录          0  2018-04-26 17:11  Security\src\com\servlet

    ..AD...         0  2018-04-27 00:25  Security\WebContent\WEB-INF\lib

     目录          0  2018-05-26 14:28  Security\build\classes

     目录          0  2018-04-26 17:11  Security\src\com

     目录          0  2018-03-17 22:41  Security\WebContent\meta-INF

     目录          0  2018-04-26 14:00  Security\WebContent\WEB-INF

     目录          0  2018-03-17 22:41  Security\.settings

     目录          0  2018-03-17 22:41  Security\build

     目录          0  2018-04-26 17:11  Security\src

............此处省略5个文件信息