mysql怎么用参数获取数据_Prepared Statement不使用Java Class的Method参数从MySql获取数据...

我试图从jsp页面将用户名和密码传递给Java类(LogMeIn.java)中的Authenticate Method，但是我得到'false'的结果。然而，当我硬编码值(abc / abc)时，我确实得到'通过'结果。即。它是成功的。

请你能指教为什么它不接受通过jsp传递的参数？

--LogMeIn.java--

package org.cms.model;

import java.sql.Connection;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.sql.PreparedStatement;

import javax.naming.Context;

import javax.naming.InitialContext;

import javax.sql.DataSource;

public class LogMeIn {

public boolean Authenticate( String username, String password ) {

Connection connection = null;

// Statement statement = null;

ResultSet resultSet = null;

PreparedStatement pst = null;

String query;

boolean result = false;

try {

Context initCtx = new InitialContext();

Context envCtx = (Context) initCtx.lookup("java:comp/env");

DataSource ds = (DataSource) envCtx.lookup("jdbc/TestDB");

connection = ds.getConnection();

//statement = connection.createStatement();

query = "select name from account where name= ? and password = ?";

pst = connection.prepareStatement(query);

pst.setString(1, username);

pst.setString(2, password);

resultSet = pst.executeQuery();

int count=0;

if(resultSet.next())

{

count++;

}

if(count>0)

{

result = true;

}

else

{

result = false;

}

}

catch (SQLException e){

e.printStackTrace();

}

catch (Exception e){

e.printStackTrace();

}

finally {

if (resultSet != null) try { resultSet.close(); } catch (SQLException logOrIgnore) {}

if (connection != null) try { connection.close(); } catch (SQLException logOrIgnore) {}

}

return result;

}

}--- LoginServlet ---

package org.cms.controller;

import java.io.IOException;

import javax.servlet.RequestDispatcher;

import javax.servlet.ServletException;

import javax.servlet.annotation.WebServlet;

import javax.servlet.http.HttpServlet;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.cms.model.LogMeIn;

/**

* Servlet implementation class LoginServlet

*/

@WebServlet("/LoginServlet")

public class LoginServlet extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)

*/

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {

String username;

String password;

username = request.getParameter("user");

password = request.getParameter("pass");

LogMeIn a = new LogMeIn();

boolean result = a.Authenticate(username, password);

System.out.println(result);

if (result) {

request.setAttribute("loginresult","Pass");

RequestDispatcher dispatcher = request.getRequestDispatcher("Login.jsp");

dispatcher.forward(request, response);

}

else {

request.setAttribute("loginresult","Failed");

RequestDispatcher dispatcher = request.getRequestDispatcher("Login.jsp");

dispatcher.forward(request, response);

}

}

}--- ---的Login.jsp

pageEncoding="ISO-8859-1"%>

Login

User Name:
Password:
	value="submit" class="fb8"/>

非常感谢