<%@ page import="java.sql.*"%>
<%!
public static final String dbdriver="oracle.jdbc.driver.OracleDriver";
public static final String dburl="jdbc:oracle:thin:@localhost:1521/orcl";
public static final String dbuser="scott";
public static final String dbpass="tiger";
%> <%
boolean flag = false ;
String id = request.getParameter("userid");
String pwd = request.getParameter("password");
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
Class.forName(dbdriver);
conn = DriverManager.getConnection(dburl,dbuser,dbpass);
String sql = "select * from tuser where userid=? and password=? ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,id);
pstmt.setString(2,pwd);
rs = pstmt.executeQuery();
if(rs.next()){
flag = true ;
}
}catch(Exception e){
}finally{
try{
conn.close();
}catch(Exception e){
}
}
%> <%
if(flag){
%>
<jsp:forward page="success.jsp"/>
<%
}else{
%>
<jsp:forward page="failure.jsp"/>
<%
}
%>
数据库里添加了表,用该查询语句也能行,但是怎么总是跳到错误的页面(failure.jsp)?输入正确的口令也是!判断有错??
<%!
public static final String dbdriver="oracle.jdbc.driver.OracleDriver";
public static final String dburl="jdbc:oracle:thin:@localhost:1521/orcl";
public static final String dbuser="scott";
public static final String dbpass="tiger";
%> <%
boolean flag = false ;
String id = request.getParameter("userid");
String pwd = request.getParameter("password");
Connection conn = null;
PreparedStatement pstmt = null;
ResultSet rs = null;
try{
Class.forName(dbdriver);
conn = DriverManager.getConnection(dburl,dbuser,dbpass);
String sql = "select * from tuser where userid=? and password=? ";
pstmt = conn.prepareStatement(sql);
pstmt.setString(1,id);
pstmt.setString(2,pwd);
rs = pstmt.executeQuery();
if(rs.next()){
flag = true ;
}
}catch(Exception e){
}finally{
try{
conn.close();
}catch(Exception e){
}
}
%> <%
if(flag){
%>
<jsp:forward page="success.jsp"/>
<%
}else{
%>
<jsp:forward page="failure.jsp"/>
<%
}
%>
数据库里添加了表,用该查询语句也能行,但是怎么总是跳到错误的页面(failure.jsp)?输入正确的口令也是!判断有错??
解决方案 »
- 紧急求助,同一主机,多个应用程序不同jvm问题。。。
- 在线等。。。struts2 与json 转换的问题。。答对后。。马上加分。。
- jsp连接SQL 2000
- 有关struts2验证框架的问题
- 公司要做基于alfresco的二次开发,从何看起啊
- servlet.jar我都加载了..还是不行..各位高手来看一看...
- 我用ejb3.0,完成webservice服务问一下能不能,在一个ejb项目里面写两个以上的webservice
- 请问jstl能否格式化显示Calendar型的日期?应该怎么做?急................
- hibernate exception , help me~
- Maven的web项目,deploy时出错了!!
- struts1中如何添加串口通信功能
- ssh部署到tomcat后出问题 , 无法访问到该项目 请进!
flag = true ;
}
这一句就是没执行。查询不到数据。