在sql server2005表中有good_introduce数据,记录书籍的简介,但是却显示不出来,哪位大侠能告诉我该怎么办,问题提示是error,null,谢谢!!
index.jsp:
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("类找不到!");
out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=shopping","sa","11011");
sql=con.createStatement();
rs=sql.executeQuery("select * from goods");
out.print("<table border align=center>");
out.print("<tr><td colspan=8 align=center bgcolor=#0009999>网上商城书店的书有</td></tr>");
out.print("<tr>");
out.print("<td width=100 bgcolor=#ccc8888>"+"书籍简介");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.print("<td bgcolor=#fff888><a href='introduce.jsp?good_introduce="+rs.getString(4)+"'>简介</td>"); /**********/
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException ee){
out.print(ee.getMessage());
}
%>introduce.jsp:
<%!
public String codetoString(String str){
String good=str;
try{
byte[] b=good.getBytes("ISO-8859-1");
good=new String(b);
return good;
}
catch(Exception e){return good;}
}%>
<html>
<body>
<a href="index.jsp">返回</a><br>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("类找不到!");
out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=shopping","sa","11011");
sql=con.createStatement();
String good_introduce=codetoString(request.getParameter("good_introduce"));/*********/
out.print("<table border>");
out.print("<tr><td colspan=8 align=center>网上商城书店的书有</td></tr>");
out.print("<tr>");
out.print("<td width=100>"+"书籍");
out.print("</tr>");
out.print("<tr>");
rs=sql.executeQuery("select * from goods where good_introduce="+good_introduce); /*********/
rs.next();
out.print("<td>"+rs.getString("good_introduce")+"</td>");
out.print("</tr>");
out.print("</table>");
}
catch(Exception ee){
out.println("error!");
out.print(ee.getMessage());
}
%>
</body>
</html>
index.jsp:
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("类找不到!");
out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DatabaseName=shopping","sa","11011");
sql=con.createStatement();
rs=sql.executeQuery("select * from goods");
out.print("<table border align=center>");
out.print("<tr><td colspan=8 align=center bgcolor=#0009999>网上商城书店的书有</td></tr>");
out.print("<tr>");
out.print("<td width=100 bgcolor=#ccc8888>"+"书籍简介");
out.print("</tr>");
while(rs.next()){
out.print("<tr>");
out.print("<td bgcolor=#fff888><a href='introduce.jsp?good_introduce="+rs.getString(4)+"'>简介</td>"); /**********/
out.print("</tr>");
}
out.print("</table>");
con.close();
}
catch(SQLException ee){
out.print(ee.getMessage());
}
%>introduce.jsp:
<%!
public String codetoString(String str){
String good=str;
try{
byte[] b=good.getBytes("ISO-8859-1");
good=new String(b);
return good;
}
catch(Exception e){return good;}
}%>
<html>
<body>
<a href="index.jsp">返回</a><br>
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.print("类找不到!");
out.print(e);
}
try{
con=DriverManager.getConnection("jdbc:sqlserver://localhost:1433; DatabaseName=shopping","sa","11011");
sql=con.createStatement();
String good_introduce=codetoString(request.getParameter("good_introduce"));/*********/
out.print("<table border>");
out.print("<tr><td colspan=8 align=center>网上商城书店的书有</td></tr>");
out.print("<tr>");
out.print("<td width=100>"+"书籍");
out.print("</tr>");
out.print("<tr>");
rs=sql.executeQuery("select * from goods where good_introduce="+good_introduce); /*********/
rs.next();
out.print("<td>"+rs.getString("good_introduce")+"</td>");
out.print("</tr>");
out.print("</table>");
}
catch(Exception ee){
out.println("error!");
out.print(ee.getMessage());
}
%>
</body>
</html>
难道表中的数据不能有逗号吗?
是不是有点问题
再把sql语句中的*改一下试试看