JSP+SQLSERVE 登陆模块源码在线等

Login.java
package mybean.data;
public class Login
{   String  logname,
           password,
           backNews="";
   boolean success=false;
   public void setLogname(String name)
    {  logname=name;
    }
   public String getLogname()
    {return logname;
    }
   public void setPassword(String pw)
    {  password=pw;
    }
    public String getPassword()
    {return password;
    }
   public String getBackNews()
    { return backNews;
    }
   public void setBackNews(String s)
    { backNews=s;
    }
   public void setSuccess(boolean b)
    {  success=b;
    }
   public boolean getSuccess()
   {   return success;
   }
}login.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<HTML><HEAD><%@ include file="head.txt" %></HEAD>
<BODY bgcolor=pink><Font size=2><CENTER>
<BR><BR>
<table border=2>
<tr> <th>请您登录</th></tr>
<FORM action="helpLogin" Method="post">
<tr><td>登录名称:<Input type=text name="logname"></td></tr>
<tr><td>输入密码:<Input type=password name="password"></td></tr>
</table>
<BR><Input type=submit name="g" value="提交">
</Form></CENTER>
</BODY></HTML>showLoginMess.jsp
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="mybean.data.Login"%>
<jsp:useBean id="login" type="mybean.data.Login" scope="session"/>
<HTML><HEAD><%@ include file="head.txt" %></HEAD>
<HTML><BODY bgcolor=yellow >
<CENTER><Font size=4 color=blue >
       <BR> <jsp:getProperty name="login"  property="backNews"/>
       </Font>
<% if(login.getSuccess()==true)
     {
%>    <BR>登录会员名称:<jsp:getProperty name="login" property="logname"/>
<%  }
   else
    {
%>  <BR>登录会员名称:<jsp:getProperty name="login" property="logname"/>
   <BR>登录会员密码:<jsp:getProperty name="login" property="password"/>
<% }
%>
</FONT></CENTER>
</BODY></HTML>HandleLogin.java
package myservlet.control;
import mybean.data.*;
import java.sql.*;
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class HandleLogin extends HttpServlet
{   public void init(ServletConfig config) throws ServletException
    { super.init(config);
      try {  Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
          }
       catch(Exception e){}
    }
   public String handleString(String s)
   {   try{ byte bb[]=s.getBytes("iso-8859-1");
            s=new String(bb);
          }
       catch(Exception ee){}
       return s;
   }
   public  void  doPost(HttpServletRequest request,HttpServletResponse response)
                        throws ServletException,IOException
    {   Connection con;
        PreparedStatement sql;
        Login loginBean=null;
        String backNews="";
        HttpSession session=request.getSession(true);
        try{  loginBean=(Login)session.getAttribute("login");
              if(loginBean==null)
              { loginBean=new Login();
                session.setAttribute("login",loginBean);
              }
           }
        catch(Exception ee)
          {  loginBean=new Login();
             session.setAttribute("login",loginBean);
          }
        String logname=request.getParameter("logname").trim(),
        password=request.getParameter("password").trim();
        boolean ok=loginBean.getSuccess();
        logname=handleString(logname);
        password=handleString(password);
        if(ok==true&&logname.equals(loginBean.getLogname()))
        {  backNews=logname+"已经登录了";
           loginBean.setBackNews(backNews);
        }
        else
        {  String uri="jdbc:sqlserver://127.0.0.1:1433;DatabaseName=Friend";
           boolean boo=(logname.length()>0)&&(password.length()>0);
           try{ con=DriverManager.getConnection(uri,"sa","sa");
                String condition="select * from member where logname =? and password =?";
                sql=con.prepareStatement(condition);
                if(boo)
                { sql.setString(1,logname);
                  sql.setString(2,password);
                  ResultSet rs=sql.executeQuery();
                  boolean m=rs.next();
                  if(m==true)
                  {  backNews="登录成功";
                     loginBean.setBackNews(backNews);
                     loginBean.setSuccess(true);
                     loginBean.setLogname(logname);
                  }
                 else
                  {  backNews="您输入的用户名不存在，或密码不般配";
                     loginBean.setBackNews(backNews);
                     loginBean.setSuccess(false);
                     loginBean.setLogname(logname);
                     loginBean.setPassword(password);
                  }
                }
                else
                { backNews="您输入的用户名不存在，或密码不般配";
                  loginBean.setBackNews(backNews);
                  loginBean.setSuccess(false);
                  loginBean.setLogname(logname);
                  loginBean.setPassword(password);
                }
                con.close();
              }
           catch(SQLException exp)
             {  backNews=""+exp;
                loginBean.setBackNews(backNews);
                loginBean.setSuccess(false);
             }
        }
       RequestDispatcher dispatcher=request.getRequestDispatcher("showLoginMess.jsp");
       dispatcher.forward(request, response);
    }
   public  void  doGet(HttpServletRequest request,HttpServletResponse response)
                        throws ServletException,IOException
    {   doPost(request,response);
    }
}
这是个MVC 模式做的在XML 下加入
<servlet>
    <servlet-name>login</servlet-name>
    <servlet-class>myservlet.control.HandleLogin</servlet-class>
</servlet>
<servlet-mapping>
   <servlet-name>login</servlet-name>
   <url-pattern>/helpLogin</url-pattern>
</servlet-mapping>
按照上面的包建相应的文件以及更改数据库调试下就行了

调试易

JSP+SQLSERVE 登陆模块源码在线等

解决方案 »

JSP+SQLSERVE 登陆模块源码 在线等

解决方案 »

JSP+SQLSERVE 登陆模块源码在线等