我这个项目运行很久了,今天突然报错说找不到驱动
而且错误都是出现在JSP页面上,我同一个项目下的java程序链接数据库都没问题,请问这是什么原因?我试过重新下载一个驱动,还是同样结果,java程序运行没问题,JSP就报错
以下是JSP页面代码,求助求助!<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<HTML>
<HEAD>
<TITLE>FusionCharts Free - Database And Connection Class Example</TITLE>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/FusionCharts.js"></SCRIPT>
<style type="text/css">
<!--
body {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.text{
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
</HEAD>
<BODY>
<CENTER>
<h2><a href="http://www.fusioncharts.com" target="_blank">FusionCharts Free</a> Database and Connection Class Example</h2>
<%
Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/rv_mining","root","123123");
Statement st1=null,st2=null;
ResultSet rs1=null,rs2=null;
//strXML will be used to store the entire XML document generated
String strXML="";
//Generate the chart element
strXML = "<graph caption='Factory Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>";
try {
st1=con.createStatement();
rs1=st1.executeQuery("select phone_id from rvm_phoneinfo");
int pid = 0;
//Iterate through each factory
while(rs1.next()) {
pid=rs1.getInt("phone_id");
//Now create second recordset to get details for this factory
//Construct the query to retrieve data
int P = 0;
//int N = 0;
String tid = null;
st2=con.createStatement();
rs2 = st2.executeQuery("select * from rvm_chart where phone_id="+pid+"");
while(rs2.next()){
tid=rs2.getString("para_id");
P = rs2.getInt("P_value");
//N = rs2.getInt("N_value");
strXML += "<set name='" + tid + "' value=" +P+ "/>";
}
rs2.close();
st2.close();
} //end of while
rs1.close();
st1.close();
con.close();
}catch(SQLException e) {
e.printStackTrace();
}
//Finally, close <graph> element
strXML += "</graph>";
//close the resulset,statement,connection
//Create the chart - Pie 3D Chart with data from strXML
%>
<jsp:include page="includes/FusionChartsRenderer.jsp" flush="true">
<jsp:param name="chartSWF" value="FusionCharts/FCF_Pie3D.swf" />
<jsp:param name="strURL" value="" />
<jsp:param name="strXML" value="<%=strXML %>" />
<jsp:param name="chartId" value="FactorySum" />
<jsp:param name="chartWidth" value="650" />
<jsp:param name="chartHeight" value="450" />
<jsp:param name="debugMode" value="false" />
<jsp:param name="registerWithJS" value="false" />
</jsp:include>
<BR>
<BR>
<a href='../NoChart.html' target="_blank">Unable to see the chart above?</a><BR><H5 ><a href='../default.htm'>« Back to list of examples</a></h5>
</CENTER>
</BODY>
</HTML>
而且错误都是出现在JSP页面上,我同一个项目下的java程序链接数据库都没问题,请问这是什么原因?我试过重新下载一个驱动,还是同样结果,java程序运行没问题,JSP就报错
以下是JSP页面代码,求助求助!<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<%@page contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
<HTML>
<HEAD>
<TITLE>FusionCharts Free - Database And Connection Class Example</TITLE>
<SCRIPT LANGUAGE="Javascript" SRC="FusionCharts/FusionCharts.js"></SCRIPT>
<style type="text/css">
<!--
body {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.text{
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
-->
</style>
</HEAD>
<BODY>
<CENTER>
<h2><a href="http://www.fusioncharts.com" target="_blank">FusionCharts Free</a> Database and Connection Class Example</h2>
<%
Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/rv_mining","root","123123");
Statement st1=null,st2=null;
ResultSet rs1=null,rs2=null;
//strXML will be used to store the entire XML document generated
String strXML="";
//Generate the chart element
strXML = "<graph caption='Factory Output report' subCaption='By Quantity' decimalPrecision='0' showNames='1' numberSuffix=' Units' pieSliceDepth='30' formatNumberScale='0'>";
try {
st1=con.createStatement();
rs1=st1.executeQuery("select phone_id from rvm_phoneinfo");
int pid = 0;
//Iterate through each factory
while(rs1.next()) {
pid=rs1.getInt("phone_id");
//Now create second recordset to get details for this factory
//Construct the query to retrieve data
int P = 0;
//int N = 0;
String tid = null;
st2=con.createStatement();
rs2 = st2.executeQuery("select * from rvm_chart where phone_id="+pid+"");
while(rs2.next()){
tid=rs2.getString("para_id");
P = rs2.getInt("P_value");
//N = rs2.getInt("N_value");
strXML += "<set name='" + tid + "' value=" +P+ "/>";
}
rs2.close();
st2.close();
} //end of while
rs1.close();
st1.close();
con.close();
}catch(SQLException e) {
e.printStackTrace();
}
//Finally, close <graph> element
strXML += "</graph>";
//close the resulset,statement,connection
//Create the chart - Pie 3D Chart with data from strXML
%>
<jsp:include page="includes/FusionChartsRenderer.jsp" flush="true">
<jsp:param name="chartSWF" value="FusionCharts/FCF_Pie3D.swf" />
<jsp:param name="strURL" value="" />
<jsp:param name="strXML" value="<%=strXML %>" />
<jsp:param name="chartId" value="FactorySum" />
<jsp:param name="chartWidth" value="650" />
<jsp:param name="chartHeight" value="450" />
<jsp:param name="debugMode" value="false" />
<jsp:param name="registerWithJS" value="false" />
</jsp:include>
<BR>
<BR>
<a href='../NoChart.html' target="_blank">Unable to see the chart above?</a><BR><H5 ><a href='../default.htm'>« Back to list of examples</a></h5>
</CENTER>
</BODY>
</HTML>
解决方案 »
- 有谁做过民生银行接口没啊!公司最近要做个民生的接口,可是它发的哪个文档没怎么看明白
- 在线等:根据xsd生成xml
- Servlet2.5+ jsp2.1 +jstl1.1吗?
- 求教各位达人,关于ext,HttpProxy设置的问题。。。
- 向大侠求救,创建数据库连接太慢?????????100分!!!!!!
- java代码怎么生成GUID啊?有没有代码?急啊!!!!!
- 请各位推荐好书
- 怎样用命令行打开jsp文件?
- HELPME?怎么将WORD、excel文件插入网页请说详细一点
- springMvc+mybatis 存储过程中有mysql inout属性参数,用mybatis 注解如何调用,注意是注解不是xml
- 实现节点管理 Struts2 Spring Hibernate 实现树级菜单带添加节点与删除功能
- LUCENE 查出所有document
Class.forName("com.mysql.jdbc.Driver").newInstance();
顶一个,在调用DriverManager的getConnection方法之前,
要保证相应的Driver类已经被加载到 jvm中,
并且完成了类的初始化工作
或者:com.mysql.jdbc.Driver driver = new com.mysql.jdbc.Driver(); 都可以的