请问下面代码有啥问题？

javawriter 2003-03-07 12:37:11

if ((type!=null)&&(sex!=null)&&(patation!= null)){
find_db.setDrivername("sun.jdbc.odbc.JdbcOdbcDriver");
out.println(session.getAttribute("sex").toString());
find_db.setConurl("jdbc:odbc:syjz");
find_db.setLoginuser("java");
find_db.setLoginpassword("qifeng");
if(type.equals("0")){

}
else if(sex.equals("11")){
sex = "*";
}
else if(patation.equals("21")){
patation = "*";
}
String query = null;
query = "select sort,bigtype,type,memo from employee where type ='"+type+"' and sex = '"+sex+"' and patation = '"+patation+"'";
find_db.setQueryStatement(query);
find_db.query_result();
ResultSet rs=find_db.result;
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
浏览器显示：

/data/find.jsp:49: Missing term.
ResultSet rs=find_db.result;
^
/data/find.jsp:51: Invalid expression statement.
<%out.print("数据库操作成功，恭喜你");
^
/data/find.jsp:51: Missing term.
<%out.print("数据库操作成功，恭喜你");
^
/data/find.jsp:53: 'catch' without 'try'.
} catch (java.lang.Throwable _jsp_e) {
^
/data/find.jsp:58: '}' expected.
}
^
/data/find.jsp:60: 'try' without 'catch' or 'finally'.
private com.caucho.java.LineMap _caucho_line_map;
^
/data/find.jsp:60: Statement expected.
private com.caucho.java.LineMap _caucho_line_map;
^
7 errors

Bean写的没有问题。能取出结果。

--------------------------------------------------------------------------------
Resin 2.1.6 (built Fri Nov 8 08:18:18 PST 2002)

...全文

61 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

javawriter 2003-03-07

打赏
举报

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<jsp:useBean id = "find_db" scope = "session" class = "com.syjzw.data.result_db"/>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>查询结果</title>
</head>

<body>
以下为查询结果：
<%String type = null;
String sex = null;
String patation = null;
type = request.getParameter("type");
sex = request.getParameter("sex");
patation = request.getParameter("patation");
if (type!=null){
session.setAttribute("type",type.toString());
out.println("type"+type);
}
if (sex!=null){
session.setAttribute("sex",sex.toString());
out.println("sex"+sex);
}
if (patation!= null){
session.setAttribute("patation",patation.toString());
out.println("patation"+patation);
}
out.println(session.getAttribute("sex").toString());
if ((type!=null)&&(sex!=null)&&(patation!= null)){
find_db.setDrivername("sun.jdbc.odbc.JdbcOdbcDriver");
out.println(session.getAttribute("sex").toString());
find_db.setConurl("jdbc:odbc:syjz");
find_db.setLoginuser("java");
find_db.setLoginpassword("qifeng");
if(type.equals("0")){

}
else if(sex.equals("11")){
sex = "*";
}
else if(patation.equals("21")){
patation = "*";
}
String query = null;
query = "select sort,bigtype,type,memo from employee where type ='"+type+"' and sex = '"+sex+"' and patation = '"+patation+"'";
find_db.setQueryStatement(query);
find_db.query_result();
ResultSet rs=find_db.result;
while(rs.next()) {%>
您的第一个字段内容为：<%=rs.getString(1)%>
您的第二个字段内容为：<%=rs.getString(2)%>
<%}%>
<%out.print("数据库操作成功，恭喜你");%>
</body>

teddy_huang 2003-03-07