jsp调用数据库问题，求解答

qq_32286125 2016-10-06 01:10:31

<%@page contentType="text/html; charset=utf-8"%>
<%@page import="java.sql.*"%>
<html>
<body >
<%
Connection con;
Statement sql;
ResultSet rs;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(Exception e){
out.print(e);
}
try{
con = DriverManager.getConnection("jdbc:odbc:flower","flower","123456");
sql = con.createStatement();
rs = sql.executeQuery("select * from flower");
while(rs.next()){
out.print("<center>");
out.print("<table style='width:770px;border-width:1px;border-style:dotted;font-size:14px;'>");
out.print("<tr>");
if(rs.getString("pictureb")!=null){ //没加if语句时可正常运行，加了之后提示 No data found
out.print("<td width='30%'>"+"<img src='picture/"+rs.getString("pictureb")+"'>");
}
out.print("<td width='70%'>");
out.print("<div style='font-weight:bold;font-size:medium;height:40px;line-height:40px;color:#000066; text-align:center;border-width:1px; border-style:solid; border-color:red;'>");
out.print(rs.getString("fname"));
out.print("</div>");
out.print("<div>");
out.print("材料："+rs.getString("cailiao"));
out.print("</div>");
out.print("<div>");
out.print("包装："+rs.getString("baozhuang"));
out.print("</div>");
out.print("<div>");
out.print("花语："+rs.getString("huayu"));
out.print("</div>");
out.print("<div>");
out.print("说明："+rs.getString("shuoming"));
out.print("</div>");
out.print("<div style='text-align:left; font-size: medium; color: #000066;text-decoration:line-through;margin-top:8px;'>");
out.print("原价："+rs.getString("price"));
out.print("</div>");
out.print("<div style='text-align:left; font-size: medium; color: #000066;'>");
out.print("现价：");
out.print("<font size ='33' color='red'>"+rs.getString("yourprice"));
out.print("</div>");
out.print("<div>");
out.print("<img src='image/ingwc_ico.jpg'>");
out.print("</div>");
out.print("</td>");

}

con.close();
}catch(SQLException e){
out.print(e);
}
%>
</body>
</html>
主要是if语句那里不明白为什么是错的，求解答谢谢！
错误提示如下：

...全文

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

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

qq_32286125 2016-10-08

打赏
举报

谢谢楼上的解答了哈，我找到问题所在了：我用的是access数据库，所以在代码中不可以出现两次rs.getString("pictureb")

小七和十一的爸爸 2016-10-08

打赏
举报

con = DriverManager.getConnection("jdbc:odbc:flower","flower","123456");这个理有问题， con = DriverManager.getConnection(URL,"flower","123456");//URL：连接数据库地址

qq_32286125 2016-10-06