<%@ page contentType="text/html; charset=GBK" import="java.sql.*" %>
<html>
<head>
<title>查询结果</title>
</head>
<body><%
Connection Db;
Statement DataRequest;
ResultSet Results;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Db=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:huxb","system","system");
}catch(ClassNotFoundException e){
out.println("数据库没找到");
out.println(e.toString());
}
catch(SQLException e){
out.println("发生一个错误:"+
e.toString());
}
String c=request.getParameter("stopc"); out.println("经过站点"+c+"的车有:");
try{
String query="select bus_b_stop.bus_road from bus_stop,bus_b_stop where bus_stop.b_stop="+"\""+c+"\""+"&&b_stop.s_no=bus_b_stop.s_no";
DataRequest=Db.createStatement();
Results=DataRequest.executeQuery(query);
}
catch(SQLException e){};
boolean r=Results.next();
if(!r){
out.println("没找到请重新输入"); }
else try{
do{
String a=Requests.getString(1);
out.println(a);
} while(Results.next());
}catch(SQLException e){}
Results.close();
DataRequest.close();
Db.close();
%></body>
</html>
为什么说DataRequest=Db.createStatement();Db不能解析
Results.next();Results不能解析
String a=Requests.getString(1);Requests不能解析
帮帮忙啊
<html>
<head>
<title>查询结果</title>
</head>
<body><%
Connection Db;
Statement DataRequest;
ResultSet Results;
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Db=DriverManager.getConnection("jdbc:oracle:thin:@127.0.0.1:1521:huxb","system","system");
}catch(ClassNotFoundException e){
out.println("数据库没找到");
out.println(e.toString());
}
catch(SQLException e){
out.println("发生一个错误:"+
e.toString());
}
String c=request.getParameter("stopc"); out.println("经过站点"+c+"的车有:");
try{
String query="select bus_b_stop.bus_road from bus_stop,bus_b_stop where bus_stop.b_stop="+"\""+c+"\""+"&&b_stop.s_no=bus_b_stop.s_no";
DataRequest=Db.createStatement();
Results=DataRequest.executeQuery(query);
}
catch(SQLException e){};
boolean r=Results.next();
if(!r){
out.println("没找到请重新输入"); }
else try{
do{
String a=Requests.getString(1);
out.println(a);
} while(Results.next());
}catch(SQLException e){}
Results.close();
DataRequest.close();
Db.close();
%></body>
</html>
为什么说DataRequest=Db.createStatement();Db不能解析
Results.next();Results不能解析
String a=Requests.getString(1);Requests不能解析
帮帮忙啊
Results.next();Results不能解析
String a=Requests.getString(1);Requests不能解析
帮帮忙啊lz这个jsp错误太多了
如果的classpath设置没问题的话
下边是一些修改Connection Db;
Statement DataRequest;
ResultSet Results;
改为
Connection Db=null;
Statement DataRequest=null;
ResultSet Results=null;String a=Requests.getString(1);Requests不能解析
改为
String a=Results.getString(1);
改完之后应该还会有错误,你自己查一下了
没有导入包吧