哪位高手帮忙看看，为何Login.jsp无法和LoginServlet交互，LoginServlet错在哪了
Login.jsp:
<%@ page language="java" contentType="text/html; charset=gb2312"%><table align=center border=0 width=100% cellspacing=0 cellpadding=0 height=200>
<tr>
<td width=100% colspan=2 height=10 bgcolor=red>
<font color="blue"><center>用户登录</center></font>
</td>
</tr>
<% if (request.getAttribute("error") != null){ %>
<tr>
<td width=100% align=center colspan=4 height=36>
<font color=red><b><%=request.getAttribute("error")%></b></font>
</td>
</tr>
<%
}
%>
<form name="login" method="post" action="LoginServlet">
<tr>
<td align=right height=32 width=20%>用户名称：</td>
<td>
<input type="text" name="logname" value="">
</td>
</tr>
<tr>
<td align=right height=32>密码：</td>
<td><input type="password" name="logpwd"></td>
</tr>
<tr>
<td align=center colspan=2 height=32>
<input type="button" name="login" value="登 录" onclick="check()">
<input type="reset" name="reset" value="重 置">
</td>
<script language="javascript">
function check()
{
if(document.login.logname.value=="")
{
window.alert("请输入用户名！");
window.login.logname.focus();
return false;
}
if(document.login.logpwd.value=="")
{
window.alert("请输入密码！");
window.login.logpwd.focus();
return false;
}
login.submit();
}
</script>
</tr>
</form>
</table>LoginServlet.java:
package Servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import JavaBean.user;
import JavaBean.DB_user;
public class LoginServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
public LoginServlet()
{
super();
}
protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html;charset=GB2312");
String username=request.getParameter("logname");
String password=request.getParameter("logpwd");
DB_user dbuser = new DB_user();
user user=dbuser.get(username,password);
if(user!=null)
{
request.getSession(true).setAttribute("username",username);
try{
request.getRequestDispatcher("index.jsp").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
else
{
request.setAttribute("error", "用户名与密码不匹配,请重试！");
try{
request.getRequestDispatcher("Login.jsp").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
}
}
DB_conn.java:
package JavaBean;
import java.sql.*;
import java.io.PrintWriter;
public class DB_conn{
private Connection conn=null;
public Statement sm=null;
private PrintWriter out = null;
public void connectDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:shop","sa","");
sm=conn.createStatement();
}
catch(Exception e){
out.print("数据库连接失败！");
}
}
public void closeDB(){
try{
if(sm!=null)
{
sm.close();
}
conn.close();
}
catch(Exception e){
out.println("数据库关闭失败！");
}
}
}
DB_user.java:
package JavaBean;
import java.io.*;
import java.sql.*;
import java.util.*;
import JavaBean.user;
import JavaBean.DB_conn;
public class DB_user
{
DB_conn conn=new DB_conn();
public void add(user us)
{
conn.connectDB();
try{
String sql="insert into userinfo(user_name,pwd,"
+ "email,gender,tel) values('" + us.getusername()
+ "','" + us.getpwd() + "','" + us.getemail()
+ "','" + us.getgender() + "','" + us.gettel()
+ "')";
conn.sm.executeUpdate(sql);
}
catch(Exception e){
System.out.println("执行失败！");
}
finally{
conn.closeDB();
}
}
public void update(user us)
{
conn.connectDB();
try {
String sql = "update userinfo set user_name='"
+ us.getusername() + "',pwd='"
+ us.getpwd() + "',email='"
+ us.getemail() + "',gender='"
+ us.getgender() + "',tel='"
+ us.gettel() + "' where user_id='"
+ us.getuserid() + "'"; conn.sm.executeUpdate(sql);
}
catch (Exception e) {
System.out.println("执行失败！");
}
finally {
conn.closeDB();
}
}
public user get(String username, String password)
{
conn.connectDB();
ResultSet rs = null;
try {
String sql = "select * from userinfo where user_name = '"
+ username + "' and pwd='" + password + "'";
rs = conn.sm.executeQuery(sql);
user us = null;
if (rs.next())
{
us = new user();
us.setuserid(rs.getInt("user_id"));
us.setusername(rs.getString("username"));
us.setpwd(rs.getString("pwd"));
us.setemail(rs.getString("email"));
us.setgender(rs.getInt("gender"));
us.settel(rs.getString("tel"));
return us;
}
return us;
}
catch (Exception e) {
System.out.println(e);
return null;
} finally {
conn.closeDB();
}
}
}
user.java:
package JavaBean;
public class user{
private int userid;
private String username;
private String pwd;
private String email;
private int gender;
private String strgender;
private String tel;
public int getuserid() {
return userid;
}
public void setuserid(int id) {
this.userid=id;
}
public String getusername() {
return username;
}
public void setusername(String username) {
this.username=username;
}
public String getpwd() {
return pwd;
}
public void setpwd(String pwd) {
this.pwd=pwd;
}
public String getemail() {
return email;
}
public void setemail(String email) {
this.email=email;
}
public int getgender() {
return gender;
}
public void setgender(int gender) {
this.gender=gender;
}
public String getstrgender(){
if (gender == 0)
strgender="女";
else
strgender="男";
return strgender;
}
public String gettel() {
return tel;
}
public void settel(String tel) {
this.tel=tel;
}
}
Login.jsp:
<%@ page language="java" contentType="text/html; charset=gb2312"%><table align=center border=0 width=100% cellspacing=0 cellpadding=0 height=200>
<tr>
<td width=100% colspan=2 height=10 bgcolor=red>
<font color="blue"><center>用户登录</center></font>
</td>
</tr>
<% if (request.getAttribute("error") != null){ %>
<tr>
<td width=100% align=center colspan=4 height=36>
<font color=red><b><%=request.getAttribute("error")%></b></font>
</td>
</tr>
<%
}
%>
<form name="login" method="post" action="LoginServlet">
<tr>
<td align=right height=32 width=20%>用户名称：</td>
<td>
<input type="text" name="logname" value="">
</td>
</tr>
<tr>
<td align=right height=32>密码：</td>
<td><input type="password" name="logpwd"></td>
</tr>
<tr>
<td align=center colspan=2 height=32>
<input type="button" name="login" value="登 录" onclick="check()">
<input type="reset" name="reset" value="重 置">
</td>
<script language="javascript">
function check()
{
if(document.login.logname.value=="")
{
window.alert("请输入用户名！");
window.login.logname.focus();
return false;
}
if(document.login.logpwd.value=="")
{
window.alert("请输入密码！");
window.login.logpwd.focus();
return false;
}
login.submit();
}
</script>
</tr>
</form>
</table>LoginServlet.java:
package Servlet;
import java.io.*;
import java.sql.*;
import javax.servlet.*;
import javax.servlet.http.*;
import JavaBean.user;
import JavaBean.DB_user;
public class LoginServlet extends javax.servlet.http.HttpServlet implements javax.servlet.Servlet
{
public LoginServlet()
{
super();
}
protected void doPost(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html;charset=GB2312");
String username=request.getParameter("logname");
String password=request.getParameter("logpwd");
DB_user dbuser = new DB_user();
user user=dbuser.get(username,password);
if(user!=null)
{
request.getSession(true).setAttribute("username",username);
try{
request.getRequestDispatcher("index.jsp").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
else
{
request.setAttribute("error", "用户名与密码不匹配,请重试！");
try{
request.getRequestDispatcher("Login.jsp").forward(request,response);
}
catch(Exception e){
System.out.println(e);
}
}
}
}
DB_conn.java:
package JavaBean;
import java.sql.*;
import java.io.PrintWriter;
public class DB_conn{
private Connection conn=null;
public Statement sm=null;
private PrintWriter out = null;
public void connectDB(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:shop","sa","");
sm=conn.createStatement();
}
catch(Exception e){
out.print("数据库连接失败！");
}
}
public void closeDB(){
try{
if(sm!=null)
{
sm.close();
}
conn.close();
}
catch(Exception e){
out.println("数据库关闭失败！");
}
}
}
DB_user.java:
package JavaBean;
import java.io.*;
import java.sql.*;
import java.util.*;
import JavaBean.user;
import JavaBean.DB_conn;
public class DB_user
{
DB_conn conn=new DB_conn();
public void add(user us)
{
conn.connectDB();
try{
String sql="insert into userinfo(user_name,pwd,"
+ "email,gender,tel) values('" + us.getusername()
+ "','" + us.getpwd() + "','" + us.getemail()
+ "','" + us.getgender() + "','" + us.gettel()
+ "')";
conn.sm.executeUpdate(sql);
}
catch(Exception e){
System.out.println("执行失败！");
}
finally{
conn.closeDB();
}
}
public void update(user us)
{
conn.connectDB();
try {
String sql = "update userinfo set user_name='"
+ us.getusername() + "',pwd='"
+ us.getpwd() + "',email='"
+ us.getemail() + "',gender='"
+ us.getgender() + "',tel='"
+ us.gettel() + "' where user_id='"
+ us.getuserid() + "'"; conn.sm.executeUpdate(sql);
}
catch (Exception e) {
System.out.println("执行失败！");
}
finally {
conn.closeDB();
}
}
public user get(String username, String password)
{
conn.connectDB();
ResultSet rs = null;
try {
String sql = "select * from userinfo where user_name = '"
+ username + "' and pwd='" + password + "'";
rs = conn.sm.executeQuery(sql);
user us = null;
if (rs.next())
{
us = new user();
us.setuserid(rs.getInt("user_id"));
us.setusername(rs.getString("username"));
us.setpwd(rs.getString("pwd"));
us.setemail(rs.getString("email"));
us.setgender(rs.getInt("gender"));
us.settel(rs.getString("tel"));
return us;
}
return us;
}
catch (Exception e) {
System.out.println(e);
return null;
} finally {
conn.closeDB();
}
}
}
user.java:
package JavaBean;
public class user{
private int userid;
private String username;
private String pwd;
private String email;
private int gender;
private String strgender;
private String tel;
public int getuserid() {
return userid;
}
public void setuserid(int id) {
this.userid=id;
}
public String getusername() {
return username;
}
public void setusername(String username) {
this.username=username;
}
public String getpwd() {
return pwd;
}
public void setpwd(String pwd) {
this.pwd=pwd;
}
public String getemail() {
return email;
}
public void setemail(String email) {
this.email=email;
}
public int getgender() {
return gender;
}
public void setgender(int gender) {
this.gender=gender;
}
public String getstrgender(){
if (gender == 0)
strgender="女";
else
strgender="男";
return strgender;
}
public String gettel() {
return tel;
}
public void settel(String tel) {
this.tel=tel;
}
}
解决方案 »
- 链接数据库错误oracle
- 有人了解基于java的web游戏开发么?介绍介绍
- 一个jsp页面为什么能同时响应多个请求
- JSP + oracle 处理千万级数据量的高难度问题探讨 ---- 高手进 >>
- 我的servlet怎么没有进行判断？高手前来指教下
- ServletContext接口的getAttributeNames和ServletConfig的getInitParameterNames有何区别
- 大家推荐一个好的学习hibernate的网站呗。
- 请教(Myeclipse)：Step Into进入函数内部，这里函数内部是指什么啊？
- jbuilder9运行项目的问题
- ５００分：急求如何通过jsp或servlet读取data.xml生成一个插入（insert）的sql语句打印出来。
- 为什么在myesplise中会出现这个问题
- 如何用jspsmartupload接收表单的一切信息
可以让你的开发简单的一塌糊涂。
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
java.lang.Thread.run(Unknown Source)
root cause java.lang.ClassNotFoundException: Servlet.LoginServlet
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1359)
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1205)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:870)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:685)
java.lang.Thread.run(Unknown Source)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.23