judge() java中_Judgelogin.java

package bookManage;

import java.io.IOException;

import java.io.PrintWriter;

import java.net.URLEncoder;

import java.sql.Connection;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

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 javax.xml.ws.Response;

/**

* Servlet implementation class Judgelogin

*/

@WebServlet("/Judgelogin")

public class Judgelogin extends HttpServlet {

private static final long serialVersionUID = 1L;

/**

* @see HttpServlet#HttpServlet()

*/

public Judgelogin() {

super();

// TODO Auto-generated constructor stub

}

/**

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

*/

SqlHelper sh;

Connection conn=null;

PreparedStatement psmt=null;

ResultSet rs=null;

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

// TODO Auto-generated method stub

response.setCharacterEncoding("UTF-8");//设置将字符以"UTF-8"编码输出到客户端浏览器

String username = new String((request.getParameter("username")).getBytes("ISO-8859-1"),"UTF-8");

String pwd = new String((request.getParameter("password")).getBytes("ISO-8859-1"),"UTF-8");

System.out.println("username "+username);

System.out.println("pwd "+pwd);

conn=sh.getConnect();

String sql="SELECT * FROM dbo.fm_userinfo WHERE name=‘"+username+"‘ AND pwd=‘"+pwd+"‘";

try {

psmt=conn.prepareStatement(sql);

psmt.setString(1, username);

psmt.setString(2, pwd);

rs=psmt.executeQuery();

while(rs.next()) {

RequestDispatcher dispatcher = request.getRequestDispatcher("index.jsp?username="+username+"");

dispatcher .forward(request, response);

}

} catch (SQLException e) {

e.printStackTrace();

}

}

/**

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

*/

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

// TODO Auto-generated method stub

doGet(request, response);

}

}