为什么我这里没有显示鼠标的悬停可改变页面颜色，以为什么我加载了mysql的jar文件还是不能显示报表的内容呢？

源自：3-6 JSP页面实现

为什么我这里没有显示鼠标的悬停可改变页面颜色，以为什么我加载了mysql的jar文件还是不能显示报表的内容呢？

首先是index.jsp

<%@ page language="java" import="java.util.*,beans.*"

pageEncoding="UTF-8"%>

String path = request.getContextPath();

String basePath = request.getScheme() + "://" + request.getServerName() + ":" + request.getServerPort()

+ path + "/";

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<title>原生态java环境生成报表</title>

table.hovertable {

font-family: verdana, arial, sans-serif;

font-size: 13px;

color: #333333;

border-width: 1px;

border-color: #999999;

border-collapse: collapse;

}

table.hovertable th {

background-color: #c3dde0;

border-width: 1px;

padding: 8px;

border-style: solid;

border-color: #a9c6c9;

}

table.hovertable tr {

background-color: #d4e3e5;

}

table.hovertable td {

border-width: 1px;

padding: 8px;

border-style: solid;

border-color: #a9c6c9;

}

</style>

</head>

<body>

</form>

<tr>

</tr>

<tr>

</tr>

List list = null;//初始化一个List

if (session.getAttribute("PROFIT") != null) {

list = (List) session.getAttribute("PROFIT");

if (list.size() > 0) {

int temp = 0;

int temp1 = 0;

int temp2 = 0;

int temp3 = 0;

Profit pf;

for (int i = 0; i < list.size(); i++) {

pf = new Profit();

pf = (Profit) list.get(i);

<tr onmouseover="this.style.backgroundColor='#ffff66';"

onmouseout="this.style.backgroundColor='#d4e3e5';">

</tr>

}

</table>

</body>

</html>

然后是我的JdbcConn类

public class JdbcConn {

private static String url="jdbc:mysql://127.0.0.1:3306/TestReport";

private static String user = "root";

private static String password = "123";

public static Connection conn;

public static PreparedStatement ps;

public static ResultSet rs;

public static Statement st;

public static Connection getConnection(){

//1.首先我们要初始化驱动包

try {

Class.forName("com.mysql.jdbc.Driver");

conn = DriverManager.getConnection(url,user,password);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return conn;

}

这是我的Service类

public class Service {

private Connection dbConnection;

private Statement st,st1,st2;

private ResultSet rs,rs1,rs2;

private String sql;

private List list;

private Profit pf;

public List getProfit(){

list = new ArrayList();

dbConnection = JdbcConn.getConnection();

try {

st = (Statement)dbConnection.createStatement();

st1 = (Statement)dbConnection.createStatement();

st2 = (Statement)dbConnection.createStatement();

sql="select g.goods_name goodsName,g.selling_price selling,g.cost_price costPrice,g.goods_id goodsId"

+ "from goods g,trading t"

+ "where t.trading_goods_id=g.goods_id"

+ "group by g.goods_name;";

rs = st.executeQuery(sql);

int temp;

while(rs.next()){

pf = new Profit();

pf.setGoodsName(rs.getString("goodsName"));

pf.setSellingPrice(rs.getInt("selling"));

pf.setCostPrice(rs.getInt("selling"));

pf.setGoodsId(rs.getInt("goodsId"));

temp=0;

temp=pf.getSellingPrice()-pf.getCostPrice();//单品利润

sql="select sum(t.trading_number) sumNum from trading t where t.trading_goods_id= "+pf.getGoodsId();

rs1=st1.executeQuery(sql);

while(rs1.next()){

pf.setTradingNumber(rs1.getInt("sumNum"));//这里获得了卖出的数量

}

pf.setProfit(temp*pf.getTradingNumber());//总利润=单品利润*卖出的数量

sql="select count(t.trading_id) times from trading t where t.trading_goods_id= "+pf.getGoodsId();

rs2=st2.executeQuery(sql);

while(rs2.next()){

pf.setTradingNumber(rs1.getInt("times"));//这里获得了卖出的数量

}

list.add(pf);//那我们取得的结果集pf(利润)放到List集合里

}

} catch (SQLException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

return list;

}

提问者：believestudy 2019-05-09 11:38

为什么我这里没有显示鼠标的悬停可改变页面颜色，以为什么我加载了mysql的jar文件还是不能显示报表的内容呢？

个回答