package mybean.data;public class Login {
private String logname = null;
private String password = null;
private String backNews = null;
private boolean success = false;


public String getBackNews() {
return backNews;
}
public void setBackNews(String backNews) {
this.backNews = backNews;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public boolean getSuccess() {
return success;
}
public void setSuccess(boolean success) {
this.success = success;
}
public String getLogName() {
return logname;
}
public void setLogName(String logname) {
this.logname = logname;
}}package myservlet.control;import java.io.*;
import mybean.data.*;
import java.sql.*;import javax.servlet.*;
import javax.servlet.http.*;
public class HandleLogin extends HttpServlet { public void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {doPost(request, response);}
public void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException { response.setContentType("text/html;charset=gbk");
PrintWriter out = response.getWriter();

try {
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
} catch(ClassNotFoundException e){
System.out.println("驱动找不着");
}

Connection conn = null;
PreparedStatement prestmt = null;
ResultSet rs = null;
Login loginBean = null;
String backNews = null;
HttpSession session = request.getSession(true);



try{
loginBean=(Login)session.getAttribute("login");
if(loginBean==null){
loginBean = new Login();
session.setAttribute("login", loginBean);
}
} catch(Exception e){
loginBean = new Login();
session.setAttribute("login", loginBean);
}

String logname = request.getParameter("logname").trim();
String password = request.getParameter("password").trim();
boolean ok = loginBean.getSuccess();


if(ok==true && logname.equals((loginBean.getLogName()))){
backNews = logname+"已经登陆了";
loginBean.setBackNews(backNews);



}
else {

String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=ComeHere";
String dbuser = "sa";
String dbpassword = "sa";
String sql = "select * from member where logname=? and password=?";
try {
conn = DriverManager.getConnection(url,dbuser,dbpassword);
prestmt = conn.prepareStatement(sql);
prestmt.setString(1,logname);
prestmt.setString(2,password);

rs = prestmt.executeQuery();


if(rs.next()){
backNews = "登陆成功";
loginBean.setBackNews(backNews);
loginBean.setSuccess(true);
loginBean.setLogName(logname);

System.out.println(loginBean.getLogName());
System.out.println(loginBean.getLogName());

}

else{


backNews ="输入的用户名不处在,或密码不正确";
loginBean.setBackNews(backNews);
loginBean.setSuccess(false);
loginBean.setLogName(logname);
loginBean.setPassword(password);


}

} catch (Exception e){

}finally {
try{
if(rs != null){
rs.close();
rs = null;
}
if(prestmt != null){
prestmt.close();
prestmt = null;
}
if(conn != null){
conn.close();
conn = null;
}
} catch(SQLException e){
e.printStackTrace();
}
}
}



RequestDispatcher dispatcher = request.getRequestDispatcher("/showLoginMess.jsp");
dispatcher.forward(request, response);

}
}<%@ page language="java" contentType="text/html; charset=gbk"
    pageEncoding="gbk"%>
<%@ page import="mybean.data.Login" %>
<jsp:useBean id="login" type="mybean.data.Login" scope="session"/>
<jsp:include page="head.jsp"/><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk">
</head>
<body bgcolor="yellow">
<center>
<font size="4" color="blue">
<br><jsp:getProperty name="login" property="backNews"/></br>
</font>
<%
if(login.getSuccess()==true) {
%>
<br>登陆会员名称:<jsp:getProperty name="login" property="logname"/></br>
<%
  }
  else {
 
%>
<br>登陆会员名称:<jsp:getProperty name="login" property="logname"/></br>
<br>登陆会员密码:<jsp:getProperty name="login" property="password"/></br>

<%
response.setHeader("refresh","2;url=Login.jsp");
}%>

</center></body>
</html>