<%@ page import="com.mysql.jdbc.Driver"%>
<%@ page import ="java.sql.*"%>
<%@ page import="java.io.*"%>
<%@ page import ="java.util.*"%>

<%
int count=0; //让count初始值为0
String userId=request.getParameter("userId"); //取值
String userPwd=request.getParameter("userPwd"); //取值
try {
 Class.forName("org.gjt.mm.mysql.Driver");//建立路径
 
    System.out.println("Success loading Mysql Driver!");//连接成功的话会显示

catch (Exception e) {    //否则
  System.out.print("Error loading Mysql Driver!");//失败的话显示
        e.printStackTrace();
}
Connection connect=null;
Statement stmt=null;
ResultSet rs=null;
try {
    connect = DriverManager.getConnection(
        "jdbc:mysql://localhost/login", "root", "123");
    System.out.println("Success connect Mysql server!");

    stmt = connect.createStatement();
    String strSQL="select * from login_check where username='"+userId+"' and password='"+userPwd+"'";
    rs = stmt.executeQuery(strSQL);
   
    while(rs.next()){
    count++;
    }
}
catch (Exception e)
{
    System.out.print("get data error!");
    e.printStackTrace();
}
finally
{
 rs.close();
 stmt.close();
 connect.close();
}

if(count>0)
{
 out.println("pass ");
}
else
{
 out.println("your password or userid is false");
}

%>