首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > JAVA > Java Web开发 >

小弟我写了个JSP的登录页面,老是提交不过去,大家帮忙看看了多谢

2012-01-02 
我写了个JSP的登录页面,老是提交不过去,大家帮忙看看了谢谢登录页面就不写了logOn.jsp提交给LoginServlet.

我写了个JSP的登录页面,老是提交不过去,大家帮忙看看了谢谢
登录页面就不写了logOn.jsp提交给LoginServlet.java
LoginServlet.java代码:
package   com.gsi.role.servlet;

import   java.io.IOException;
import   java.sql.Connection;
import   java.sql.ResultSet;
import   java.sql.SQLException;
import   java.sql.Statement;

import   javax.servlet.ServletException;
import   javax.servlet.http.HttpServletRequest;
import   javax.servlet.http.HttpServletResponse;

import   com.gsi.role.db.ConnectionPool;
import   com.gsi.role.db.DB;

/**
  *   Servlet   implementation   class   for   Servlet:   LoginServlet
  */
public   class   LoginServlet   extends   javax.servlet.http.HttpServlet   implements
javax.servlet.Servlet   {
/*
  *   (non-Java-doc)
  *  
  *   @see   javax.servlet.http.HttpServlet#HttpServlet()
  */
public   LoginServlet()   {
super();
}

/*
  *   (non-Java-doc)
  *  
  *   @see   javax.servlet.http.HttpServlet#doGet(HttpServletRequest   request,
  *             HttpServletResponse   response)
  */
protected   void   doGet(HttpServletRequest   request,
HttpServletResponse   response)   throws   ServletException,   IOException   {
//   TODO   Auto-generated   method   stub
}

/*
  *   (non-Java-doc)
  *  
  *   @see   javax.servlet.http.HttpServlet#doPost(HttpServletRequest   request,
  *             HttpServletResponse   response)
  */
protected   void   doPost(HttpServletRequest   request,
HttpServletResponse   response)   throws   ServletException,   IOException   {
response.setContentType( "text/html ");
String   result   =   " ";

//   获取提交的用户名:
String   strUserName   =   request.getParameter( "C_Usr_Id ");
//   获取提交的密码:
String   strPassword   =   request.getParameter( "C_Usr_Passwd ");
if   ((strUserName   ==   null)   ||   (strUserName.equals( " "))
||   (strUserName.length()   >   20))   {
result   =   "请输入用户名(不超过20字符) ";
request.setAttribute( "error_username ",   result);
response.sendRedirect( "logOn.jsp ");
}
if   ((strPassword   ==   null)   ||   (strPassword.equals( " "))
||   (strPassword.length()   >   20))   {
result   =   "请输入密码(不超过20字符) ";
request.setAttribute( "error_password ",   result);
response.sendRedirect( "logOn.jsp ");
}
//   创建数据库连接对象:
ConnectionPool   connPool   =   DB.getConnPool();
Connection   conn   =   connPool.getConnection();
Statement   stmt   =   null;
ResultSet   rs   =   null;
String   sql= " ";

try   {
//   sql语句:
sql   =   "select   *   from   sys_usr   where   C_Usr_Id= ' "+   strUserName   +   " '   and   C_Usr_Passwd= ' "   +   strPassword   +   " ' ";


//   创建数据记录集对象:
stmt   =   conn.createStatement();
//   执行sql语句,返回一个记录集到rs:
rs   =   stmt.executeQuery(sql);
//   如果记录集为非空,表明有相匹配的用户名和密码,登录成功:
if   (rs.next())   {
//   登录成功时,把strUserName设成session变量UserName
request.getSession(true).setAttribute( "userName ",   strUserName);
response.sendRedirect( "index.htm ");
}   else   {
//   否则(记录集为空),表明失败:
response.sendRedirect( "err.jsp ");
}
}   catch   (SQLException   sqlExc)   {
sqlExc.printStackTrace();
}   catch   (Exception   e)   {
e.printStackTrace();
}   finally   {
//   关闭连接,释放数据库资源:
try   {
if   (rs   !=   null)   {
rs.close();
}
if   (stmt   !=   null)   {
stmt.close();
}
connPool.freeConnection(conn);
}   catch   (SQLException   sqlExc)   {
sqlExc.printStackTrace();
}
}
}
}


[解决办法]
在doGet方法里面加一句


{
doPost(HttpServletRequest request,
HttpServletResponse response);
}
[解决办法]
同楼上,你在 doget里加上dopost

热点排行