java连接数据库查询得不到想要的结果

来源:百度知道 编辑:UC知道 时间:2024/05/26 18:29:37
所有的代码在下面,运行总是跳到errorloading.jsp,就算输入正确了用户名密码也跳不到view.jsp,是类方法写错了呢还是loadingmain.jsp写得有问题呢~
loadingmain.jsp
<%@ page language="java" import="new.*" pageEncoding="GBK"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>

<body>
<%String username=request.getParameter("username");
username=new String(username.getBytes("ISO8859_1"),"GBK");
String password=request.getParameter("password");
password=new String(password.getBytes("ISO8859_1"),"GBK");
if(new SqlJDBC().query(username,password)){
response.

while (rs.next()) {
if(username.equals(rs.getString("USERNAME"))&&password.equals(rs.getString("password"))){
flag=true;
break;//加上这句。
}
不过SELECT * FROM TABLE1,
我觉得可以限制一下
"SELECT * FROM TABLE1 WHERE USERNAME = '"+username+"'"