想用java访问mysql数据库,下载了一个驱动,然后根据网上说的,配置了classpath,结果失败,原因是ClassNotFoundException,然后继续往上搜索,最后将该驱动放置到jdk\lib\ext目录下,...
想用java访问mysql数据库,下载了一个驱动,然后根据网上说的,配置了classpath,结果失败,原因是ClassNotFoundException,然后继续往上搜索,最后将该驱动放置到jdk\lib\ext目录下,还是老毛病,总是失败,忙活半晚上依然是同一个问题。不知道谁能给个痛快点的解决办法。20分送上。
程序如下:
import java.sql.*;
class ConMysql
{
public static void main(String[] args) throws SQLException
{
//show details
//1.load the driver
Class.forName("com.mysql.jdbc.Driver");
//2.use DriverManager to get the connection with the mysql database
Connection conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/twq","root","220323");
//3.use Connection to create a Statement object
Statement stmt=conn.createStatement();
//4.execute sql sentences
ResultSet rs=stmt.executeQuery("select * from student");
//5.show the result
while(rs.next())
{
System.out.println(rs.getString(1)+"\t"+rs.getInt(2)+"\t"+rs.getString(3));
}
//6.release all the resources
if(rs != null)
{
rs.close();
}
if(stmt != null)
{
stmt.close();
}
if(conn != null)
{
conn.close();
}
}
}
我用的是jcreator和eclipse,配置了环境变量classpath,均不能成功编译,原因均是java.lang.ClassNotFoundException。在eclipse导入了那个jar包,仍然失败。
展开