返回信息流jsp读取数据库所有商品信息 DBHelp类和ope测试成功，但还是报错no suitable driver found for jdbc
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/nuoxin?useUnicode=true&characterEncoding-UTF-8
listoperate.ope@366d0705
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at util.DBHelp.getConnection(DBHelp.java:29)
at operate.ope.getcakes(ope.java:23)
at org.apache.jsp.many_jsp._jspService(many_jsp.java:103)
以下是操作数据库的类
package operate;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.util.ArrayList;
import java.io.Console;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import entity.cake;
import util.DBHelp;
import com.mysql.jdbc.*;
public class ope {
//获得所有蛋糕的信息
public static ArrayList<cake> getcakes() throws Exception
{
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
ArrayList<cake> aryall=new ArrayList<cake>();//蛋糕信息的集合
System.out.println("co:");
try{
conn=DBHelp.getConnection();
System.out.println("conn:"+conn);
stmt=conn.prepareStatement("select * from cake;");
rs=stmt.executeQuery();
int i=0;
while(rs.next())
{
i++;
System.out.println("i:"+i);
cake iu=new cake();
iu.setId(rs.getInt("id"));
iu.setName(rs.getString("name"));
iu.setEname(rs.getString("ename"));
iu.setSweet(rs.getInt("sweet"));
iu.setP(rs.getString("p"));
iu.setPipo(rs.getString("pipo"));
iu.setType(rs.getString("type"));
iu.setTxt(rs.getString("txt"));
iu.setPic(rs.getString("pic"));
aryall.add(iu);
//把一个蛋糕信息加入集合
}
return aryall;
}
catch (Exception ex)
{
ex.printStackTrace();
return null;
}
finally {
// 释放数据集对象
if (rs != null) {
try {
rs.close();
rs = null;
} catch (Exception ex) {
ex.printStackTrace();
}
}
// 释放语句对象
if (stmt != null) {
try {
stmt.close();
stmt = null;
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
}
public cake getCake(int id)throws Exception
{
Connection conn=null;
PreparedStatement stmt=null;
ResultSet rs=null;
ArrayList<cake> aryall=new ArrayList<cake>();
try{
conn=DBHelp.getConnection();
stmt=conn.prepareStatement("select * from cake where id=?;");
stmt.setInt(1, id);
rs = stmt.executeQuery();
if (rs.next()) {
cake item = new cake();
item.setId(rs.getInt("id"));
item.setName(rs.getString("name"));
item.setEname(rs.getString("ename"));
item.setSweet(rs.getInt("sweet"));
item.setP(rs.getString("p"));
item.setPipo(rs.getString("pipo"));
item.setType(rs.getString("type"));
item.setTxt(rs.getString("txt"));
item.setPic(rs.getString("pic"));
return item;
} else {
return null;
}
}
catch (Exception ex)
{
ex.printStackTrace();
return null;
}
finally {
// 释放数据集对象
if (rs != null) {
try {
rs.close();
rs = null;
} catch (Exception ex) {
ex.printStackTrace();
}
}
// 释放语句对象
if (stmt != null) {
try {
stmt.close();
stmt = null;
} catch (Exception ex) {
ex.printStackTrace();
}
}
}
}
}
以下是页面调用部分代码
<%
ope items = new ope();
ArrayList<cake> list = items.getcakes();
System.out.println("list"+items);
if(list!=null&&list.size()>0)
{
for(int i=0;i<list.size();i++)
{
cake item = list.get(i);
%>
<span class='name'><%=item.getName() %></span>
<%}} %>
这是一条镜像帖。来源：北邮人论坛 / java / #58236同步于 2017/12/1
Java机器人发帖
【问题】单独编译Java成功 引入jsp报错
sugelan
2017/12/1镜像同步0 回复
订阅后，新回复会通过你的通知中心匿名送达。
0 条回复
暂无回复 · 你可以订阅本帖等待新回复。