NetBeans 下 java 程序连结Mysql的问题
我在netbeans 下新建project->general->java application
先写一个连结数据库的类 DataBaseConnection.java
package com.jspdev.util;
import java.sql.*;
public class DataBaseConnection {
public static Connection getConnection()
{
Connection conn=null;
String CLASSFORNAME="org.gjt.mm.mysql.Driver";
String SERVERDB="jdbc:mysql://localhost/mysql_test?user=root&password=mysql";
try
{
Class.forName(CLASSFORNAME);
conn=DriverManager.getConnection(SERVERDB);
}
catch(Exception e)
{
e.printStackTrace();
}
return conn;
}
}
//==================================================
然后在一个新的java程序中调用这个类来连结mysql
import java.sql.*;
import com.jspdev.util.DataBaseConnection;
public class MultiBttons extends JFrame {
public static void main(String[] args)throws java.sql.SQLException
{
// MultiBttons app;
// app=new MultiBttons();
String sEmpNo;
Connection con=DataBaseConnection.getConnection();
Statement stmt=con.createStatement();
ResultSet rst=stmt.executeQuery("select emp_no from emp_desc");
while(rst.next())
{
sEmpNo=rst.getString("emp_no");
}
rst.close();
stmt.close();
con.close();
}
}
运行时报错:java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver
//=====================================================================
但我将这个数据库连结类应用到jsp文件中,可以正常连结mysql,
mysql的驱动文件在jdk1.5的目录下,tomcat目录下都有拷贝,
是不是也要将mysql的驱动拷贝到netbeans的某个目录下,才可以正常加载mysql驱动?