登录jsp页面为什么无法登录? myeclipse+mysql创建一个登录jsp页面为什么无法登录?也没有提示错误信息! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 代码如下:login.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><html> <body> <center> <h2>管理员登录</h2> <form method="post" action="process.jsp"> <table border=bordercolor=yellow > <tr><td width="40%">用户名:</td> <td><input type="text" name="user"/></td> <tr><td width="40%">密 码:</td> <td><input type="text" name="pw"/></td> <tr> <td colspan="2" align="center"> <input type="submit" value=登录> <input type="reset" value=清空>" </td> </table> </form> <% String warning=request.getParameter("warning"); if(warning!=null) { warning=new String(warning.getBytes("ISO-1"),"GBK"); out.println("<h3>"+warning+",请重新登录或<a href='index.jsp'>返回首页</a></h3>"); } %> </center> </body></html>process.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"import="java.sql.*"%><jsp:useBean id="db" class="bean.QueryBean" scope="session"/><% Connection conn=db.setConnection("movie"); String user=request.getParameter("user"); String pw=request.getParameter("pw"); String sql="select * from admin where name='"+user+"' and password='"+pw+"'"; ResultSet rs=db.getQuery(sql); if(rs.next()) { rs.close(); db.close(); session.setAttribute("admin","ok"); %><jsp:forward page="manage.jsp"/><% } else { rs.close(); db.close(); %><jsp:forward page="login.jsp"><jsp:param name="warning" value="对不起,您的用户名或密码不正确"/></jsp:forward><% } %>check.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><% if(session.getAttribute("admin")==null) response.sendRedirect("login.jsp"); else response.sendRedirect("manage.jsp");%> 代码如下:login.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><html> <body> <center> <h2>管理员登录</h2> <form method="post" action="process.jsp"> <table border=bordercolor=yellow > <tr><td width="40%">用户名:</td> <td><input type="text" name="user"/></td> <tr><td width="40%">密 码:</td> <td><input type="text" name="pw"/></td> <tr> <td colspan="2" align="center"> <input type="submit" value=登录> <input type="reset" value=清空>" </td> </table> </form> <% String warning=request.getParameter("warning"); if(warning!=null) { warning=new String(warning.getBytes("ISO-1"),"GBK"); out.println("<h3>"+warning+",请重新登录或<a href='index.jsp'>返回首页</a></h3>"); } %> </center> </body></html>process.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"import="java.sql.*"%><jsp:useBean id="db" class="bean.QueryBean" scope="session"/><% Connection conn=db.setConnection("movie"); String user=request.getParameter("user"); String pw=request.getParameter("pw"); String sql="select * from admin where name='"+user+"' and password='"+pw+"'"; ResultSet rs=db.getQuery(sql); if(rs.next()) { rs.close(); db.close(); session.setAttribute("admin","ok"); %><jsp:forward page="manage.jsp"/><% } else { rs.close(); db.close(); %><jsp:forward page="login.jsp"><jsp:param name="warning" value="对不起,您的用户名或密码不正确"/></jsp:forward><% } %>check.jsp<%@ page language="java" import="java.util.*" pageEncoding="GBK"%><% if(session.getAttribute("admin")==null) response.sendRedirect("login.jsp"); else response.sendRedirect("manage.jsp");%>manage.jsp<%@ page language="java" import="java.sql.*" pageEncoding="GBK"%><%@include file="check.jsp" %><jsp:useBean id="db" class="bean.QueryBean" scope="session"/><center><h2>系统维护</h2><table border bordercolor=blue><tr><th colspan="3" bgcolor=yellow>删除投票项</th><% Connection conn=db.setConnection("movie"); ResultSet rs=db.getQuery("select * from vote"); int i=1; while(rs.next()) { out.println("<tr>"); out.println("<td>"+i+"</td>"); out.println("<td>"+rs.getString("item")+"</td>"); out.println("<td align='center'><a href='delete.jsp?delid="+rs.getString("id")+"'>删除</a></td>"); i++; }%><tr><th colspan="3" bgcolor=blue>添加投票项</th> <tr><td colspan="3"><form method="post" action="add.jsp">内容:<input type="text" name="additem"size="30"/> <input type="submit" value=提交/> <input type="reset" value=重置/> </form></td><tr><td colspan="3" align="center" ><a href="index.jsp">返回投票页面</a></td></table> </td>数据库JavaBeanQueryBean.javapackage bean;import java.sql.*;public class QueryBean { private Statement statement=null; private Connection conn=null; private String dbs; private ResultSet rs=null; public QueryBean(){} public Connection setConnection(String db){ dbs="jdbc:mysql://localhost:3306/"+db; String user = "root"; String pwd = "123"; try{ Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection(dbs,user,pwd); } catch(Exception e){ System.out.println(e.toString()); } return conn; } public ResultSet getQuery(String sqls){ try{ statement=conn.createStatement(); rs=statement.executeQuery(sqls); } catch(Exception e){ System.out.println(e.toString()); } return rs; } public void setModify(String sqls){ try{ statement=conn.createStatement(); statement.executeUpdate(sqls); } catch(Exception e){ System.out.println(e.toString()); } } public void close(){ try{ statement.close(); conn.close(); } catch(SQLException ex){ System.out.println(ex.toString()); } } } 结果跳到manage.jsp页面。 楼主 try catch 一下 看看报什么异常, 根据异常来找错误比较好找。 给你意见:先启动服务器,再<table border=bordercolor=yellow > 1你确定这里没错? <input type="reset" value=清空>"2你确定你的引号没有加错?3你确定你的页面跳转没有错?意见:一个页面一个页面测,使用纯静态的数据测试先别连接数据库,如果可以 再将数据库测试下。测试多了,你会发现你在面对这些问题的时候信心十足了…… 这问题还是自己试着解决下……相信你能搞定的…… 那在login.jsp页面确定的时候页面有没有跳转啊?没的话就是action那有问题 关于内存数据库 问一个菜鸟问题,谢谢啦 js获取选中的的checkbox会有undefined 加载项目出现java.lang.NoClassDefFoundError错误。 有关filter,listener,interceptor的问题 java中用Ganymed实现SCP 和SFTP文件传输 在线等答案!错在上的很么地方了! struts2 格式化输出数字和日期问题 大家帮忙参考一下这个单帮别人做多少钱合适? 初学ejb,小问题,请赐教。。。 一对多级联删除 SSH面试相关
login.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<html>
<body>
<center>
<h2>管理员登录</h2>
<form method="post" action="process.jsp">
<table border=bordercolor=yellow >
<tr><td width="40%">用户名:</td>
<td><input type="text" name="user"/></td>
<tr><td width="40%">密 码:</td>
<td><input type="text" name="pw"/></td>
<tr>
<td colspan="2" align="center">
<input type="submit" value=登录>
<input type="reset" value=清空>"
</td>
</table>
</form>
<%
String warning=request.getParameter("warning");
if(warning!=null)
{
warning=new String(warning.getBytes("ISO-1"),"GBK");
out.println("<h3>"+warning+",请重新登录或<a href='index.jsp'>返回首页</a></h3>");
}
%>
</center>
</body>
</html>
process.jsp
<%@ page language="java" import="java.util.*"
pageEncoding="GBK"import="java.sql.*"%>
<jsp:useBean id="db" class="bean.QueryBean" scope="session"/>
<%
Connection conn=db.setConnection("movie");
String user=request.getParameter("user");
String pw=request.getParameter("pw");
String sql="select * from admin where name='"+user+"' and password='"+pw+"'";
ResultSet rs=db.getQuery(sql);
if(rs.next())
{
rs.close();
db.close();
session.setAttribute("admin","ok");
%>
<jsp:forward page="manage.jsp"/>
<%
}
else
{
rs.close();
db.close();
%>
<jsp:forward page="login.jsp">
<jsp:param name="warning" value="对不起,您的用户名或密码不正确"/>
</jsp:forward>
<%
}
%>
check.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
if(session.getAttribute("admin")==null)
response.sendRedirect("login.jsp");
else
response.sendRedirect("manage.jsp");
%>
login.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<html>
<body>
<center>
<h2>管理员登录</h2>
<form method="post" action="process.jsp">
<table border=bordercolor=yellow >
<tr><td width="40%">用户名:</td>
<td><input type="text" name="user"/></td>
<tr><td width="40%">密 码:</td>
<td><input type="text" name="pw"/></td>
<tr>
<td colspan="2" align="center">
<input type="submit" value=登录>
<input type="reset" value=清空>"
</td>
</table>
</form>
<%
String warning=request.getParameter("warning");
if(warning!=null)
{
warning=new String(warning.getBytes("ISO-1"),"GBK");
out.println("<h3>"+warning+",请重新登录或<a href='index.jsp'>返回首页</a></h3>");
}
%>
</center>
</body>
</html>
process.jsp
<%@ page language="java" import="java.util.*"
pageEncoding="GBK"import="java.sql.*"%>
<jsp:useBean id="db" class="bean.QueryBean" scope="session"/>
<%
Connection conn=db.setConnection("movie");
String user=request.getParameter("user");
String pw=request.getParameter("pw");
String sql="select * from admin where name='"+user+"' and password='"+pw+"'";
ResultSet rs=db.getQuery(sql);
if(rs.next())
{
rs.close();
db.close();
session.setAttribute("admin","ok");
%>
<jsp:forward page="manage.jsp"/>
<%
}
else
{
rs.close();
db.close();
%>
<jsp:forward page="login.jsp">
<jsp:param name="warning" value="对不起,您的用户名或密码不正确"/>
</jsp:forward>
<%
}
%>
check.jsp
<%@ page language="java" import="java.util.*" pageEncoding="GBK"%>
<%
if(session.getAttribute("admin")==null)
response.sendRedirect("login.jsp");
else
response.sendRedirect("manage.jsp");
%>manage.jsp
<%@ page language="java" import="java.sql.*" pageEncoding="GBK"%>
<%@include file="check.jsp" %>
<jsp:useBean id="db" class="bean.QueryBean" scope="session"/>
<center>
<h2>系统维护</h2>
<table border bordercolor=blue>
<tr><th colspan="3" bgcolor=yellow>删除投票项</th>
<%
Connection conn=db.setConnection("movie");
ResultSet rs=db.getQuery("select * from vote");
int i=1;
while(rs.next())
{
out.println("<tr>");
out.println("<td>"+i+"</td>");
out.println("<td>"+rs.getString("item")+"</td>");
out.println("<td align='center'><a href='delete.jsp?delid="+rs.getString("id")+"'>删除</a></td>");
i++;
}
%>
<tr><th colspan="3" bgcolor=blue>添加投票项</th>
<tr><td colspan="3">
<form method="post" action="add.jsp">
内容:<input type="text" name="additem"size="30"/>
<input type="submit" value=提交/>
<input type="reset" value=重置/>
</form></td>
<tr><td colspan="3" align="center" ><a href="index.jsp">返回投票页面</a></td>
</table> </td>
数据库JavaBean
QueryBean.java
package bean;
import java.sql.*;
public class QueryBean {
private Statement statement=null;
private Connection conn=null;
private String dbs;
private ResultSet rs=null;
public QueryBean(){}
public Connection setConnection(String db){
dbs="jdbc:mysql://localhost:3306/"+db;
String user = "root";
String pwd = "123";
try{
Class.forName("com.mysql.jdbc.Driver");
conn=DriverManager.getConnection(dbs,user,pwd);
}
catch(Exception e){
System.out.println(e.toString());
}
return conn;
}
public ResultSet getQuery(String sqls){
try{
statement=conn.createStatement();
rs=statement.executeQuery(sqls);
}
catch(Exception e){
System.out.println(e.toString());
}
return rs;
}
public void setModify(String sqls){
try{
statement=conn.createStatement();
statement.executeUpdate(sqls);
}
catch(Exception e){
System.out.println(e.toString());
}
}
public void close(){
try{
statement.close();
conn.close();
}
catch(SQLException ex){
System.out.println(ex.toString());
}
}
}
结果跳到manage.jsp页面。
再
<table border=bordercolor=yellow > 1你确定这里没错?
<input type="reset" value=清空>"2你确定你的引号没有加错?3你确定你的页面跳转没有错?意见:一个页面一个页面测,使用纯静态的数据测试先别连接数据库,如果可以 再将数据库测试下。
测试多了,你会发现你在面对这些问题的时候信心十足了…… 这问题还是自己试着解决下……相信你能
搞定的……