我仅有180分，一个关于SQL SERVER2000数据库查询的问题，

hong12345 2002-05-23 08:25:15

我竭尽全力改了整一天仍然没有找出错误，为何可以搜索却传不回结果好象是打*号的那句有错，但我不知错在哪儿？？？？？
<%@ page language="java" import="java.util.*" import="java.sql.*" %>
<%@ page contentType="text/html; charset=gb2312" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>显示元数据</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>

</head>

<BODY class=mainInterface>

<H2>查询结果:</H2>

<%
Connection conn = null;
String dbdriver="sun.jdbc.odbc.JdbcOdbcDriver";
String connstr="jdbc:odbc:zy";
ResultSetMetaData rsmd=null;

String Sbook=request.getParameter("book");
byte[] tmpbyte1=Sbook.getBytes("ISO8859_1");
Sbook=new String(tmpbyte1);
String Sname=request.getParameter("name");
byte[] tmpbyte2=Sname.getBytes("ISO8859_1");
Sname=new String(tmpbyte2);
//返回结果
String sStr = "select * from yan " ;
String sCondition = "" ;
ResultSet rs=null;

if (!Sbook.equals(""))
sCondition +=" and 书名 like '%" + Sbook + "%'" ;
if (!Sname.equals(""))
sCondition += " and 作者 like '%" + Sname + "%'";
if (!sCondition.equals(""))
sStr +="where "+sCondition.substring(2);
out.println(sStr);

try
{
Class.forName(dbdriver);
}
catch(java.lang.ClassNotFoundException e)
{
System.err.println("opendb():"+ e.getMessage());
}

try
{
conn=DriverManager.getConnection(connstr);
Statement stmt=conn.createStatement();
rs=stmt.executeQuery(sStr);
}
catch(SQLException ex)
{
System.err.println("aq.executeQuery:"+ ex.getMessage());
}

* rsmd=rs.getMetaData();

int cols=rsmd.getColumnCount();
out.println("<TABLE border=1>");
out.println("<tr>");
for(int i = 1; i <= cols; i++)
{
out.print("<TH>");
//显示字段名
out.print(rsmd.getColumnLabel(i));
out.println("</TH>");
}
out.print("</TR>");
//输出所有数

while(rs.next())
{
out.print("<TR align=center>");
for(int i = 1; i <= cols; i ++)
{
out.print("<TD>");
Object obj = rs.getObject(i);
if(obj != null)
out.print(obj.toString());
else
{
out.print("");
out.println("</TD>");
}
out.print("</TR>");
}

out.print("</TABLE>");
}
rs.close();

finally
{
//总是关闭数据库连接
try
{
if(con != null)
con.close();
}
catch(Exception e){}
}

%>

</BODY>
</HTML>

...全文

32 1 打赏收藏转发到动态举报

写回复

用AI写文章

1 条回复

切换为时间正序

请发表友善的回复…

发表回复

OpenVMS 2002-05-25

打赏
举报

String sStr = "select * from yan " ;
String sCondition = "" ;
ResultSet rs=null;

if (!Sbook.equals(""))
sCondition +=" and 书名 like '''%" + Sbook + "%'''" ;
if (!Sname.equals(""))
sCondition += " 作者 like '''%" + Sname + "%'''";
if (!sCondition.equals(""))
sStr +="where "+sCondition.substring(2);