demo程序没问题,替换为数据库
为mysql 有问题,真坑,还没分析出来原因
替换内容
public Connection getConnection() {
Connection conn = null;
String url = "jdbc:mysql://IP:port/db?"
+ "user=root&password=PWd&useUnicode=true&autoReconnect=true&characterEncoding=UTF8";
try {
Class.forName("com.mysql.jdbc.Driver");/
conn = DriverManager.getConnection(url);
} catch (Exception e) {
e.printStackTrace();
} finally {
// conn.close();
}
return conn;
}
init 变化:
String sql = "select id,p_id,p_name,p_url,p_info,p_imgurl from product";
FRContext.getLogger().info("Sql查询: " +sql);
Connection con = getConnection();
Statement stmt;
try {
stmt = con.createStatement();
java.sql.ResultSet rs = stmt.executeQuery(sql);
// 用对象保存数据
Object[] objArray = null;
while (rs.next()) {
objArray = new Object[6];
for (int i = 0; i < 6; i++) {
objArray[i] = rs.getObject(i + 1);
FRContext.getLogger().info("列内容: " + rs.getObject(i + 1));
}
valueList.add(objArray);
}
rs.close();
stmt.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
附件原始内容 ,实在分析不出来原因