Bean部分:
public class DBbean {
private Connection conn = null;
public DBbean(){
try {
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/test2","root","pan");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
if(conn != null){
System.out.println("conn连接成功");
}
}
jsp部分
<body>
<jsp:useBean id="dbb" class="bean.DBbean" scope="session" />
<%
try{
request.setCharacterEncoding("utf-8");}catch(Exception e){}
%>
<jsp:setProperty name="dbb" property="selectType" param="selectType" />
<form action="" method = post name = form>
请请输入排序类型:工资<input type="radio" value="工资" name="selectType" checked>姓名<input type="radio" value="姓名" name="selectType">
<input type="submit" value="Go" name= "submit">
</form>
</body>我在bean里面写了个Main方法测试,控制台输入连接成功 而且我还用这个conn成功查询出了mysql数据库里面的一张表 。但打开jsp页面时总是提示ClassNotFoundException,报错在java.lang.ClassNotFoundException: com.mysql.jdbc.Driver ,不知道到底怎么回事。
public class DBbean {
private Connection conn = null;
public DBbean(){
try {
// DriverManager.registerDriver(new com.mysql.jdbc.Driver());
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection("jdbc:mysql://localhost/test2","root","pan");
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
if(conn != null){
System.out.println("conn连接成功");
}
}
jsp部分
<body>
<jsp:useBean id="dbb" class="bean.DBbean" scope="session" />
<%
try{
request.setCharacterEncoding("utf-8");}catch(Exception e){}
%>
<jsp:setProperty name="dbb" property="selectType" param="selectType" />
<form action="" method = post name = form>
请请输入排序类型:工资<input type="radio" value="工资" name="selectType" checked>姓名<input type="radio" value="姓名" name="selectType">
<input type="submit" value="Go" name= "submit">
</form>
</body>我在bean里面写了个Main方法测试,控制台输入连接成功 而且我还用这个conn成功查询出了mysql数据库里面的一张表 。但打开jsp页面时总是提示ClassNotFoundException,报错在java.lang.ClassNotFoundException: com.mysql.jdbc.Driver ,不知道到底怎么回事。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货