<%@ 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)?输入正确的口令也是!判断有错??
解决方案 »
- jquery引入的问题
- 2010特殊问题
- 刚刚接触EL表达示很迷惑!!!!求解
- 让人很郁闷的No result defined for action 错误。。。望牛人解答!!!!!!
- 推荐几本 进阶的数据结构书 我 谢谢
- 如何将ResultSet 变成 数组
- struts:提交到某个action后,如果点刷新还可一再提交一次,请问如何避免啊(我已经return mapping.findForward("...")了)
- 输出格式化问题
- 毛了,这种问题
- 哪位有“21天学通J2EE”这本书的随书光盘?
- struts1中如何添加串口通信功能
- ssh部署到tomcat后出问题 , 无法访问到该项目 请进!
flag = true ;
}
这一句就是没执行。查询不到数据。