】关于JAVA_JDBC的,求大神赐教!
import java.sql.*;
public class jdbctest {
//获取数据库连接
public static Connection getConnection(String driverClassName,
String dbURL,String userName,String password)
throws ClassNotFoundException,SQLException{
Connection con=null;
//加载连接数据库的驱动类
Class.forName(driverClassName);
//用(URL+用户名+密码)连接数据库
con=DriverManager.getConnection(dbURL,userName,password);
return con;
}
//获得MySQL数据库的连接
public static Connection getmysqk_Con(String driverClassName,
String serverHost,String serverPort,String dbName,
String userName,String password)throws ClassNotFoundException,
SQLException{
//如果没有提供参数,则使用默认值
if(driverClassName==null){
driverClassName="com.mysql.jdbc.Driver";
}
if(serverHost==null){
serverHost="127.0.0.1";
}
if(serverPort==null) {
serverPort="3306";
}
//构建访问SQL server数据库的URL
String dbURL="jdbc:mysql://"+serverHost+":"+serverPort+"/"+dbName;
return getConnection(driverClassName,dbURL,userName,password);
}
public static void main(String[] args)throws ClassNotFoundException,SQLException{
String mysql_Driver="com.mysql.jdbc.Driver";
String dateBase="myuser";
String userName="root";
String password="root";
//getmysql_con
Connection con=jdbctest.getmysqk_Con(mysql_Driver,null,null, dateBase, userName, password);
System.out.println("***MYSQL连接成功!(getmysql_con)***");
con.close();
System.out.println("###成功关闭Mysql数据库###");
//getConnection
String url="jdbc:mysql://127.0.0.1:3306/"+dateBase;
con=getConnection(mysql_Driver, url, userName, password);
System.out.println("***MYSQL连接成功!(getConnection)***");
con.close();
System.out.println("###成功关闭Mysql数据库###");
}
}
运行结果是:
Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at java.net.URLClassLoader$1.run(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at jdbctest.getConnection(jdbctest.java:10)
at jdbctest.getmysqk_Con(jdbctest.java:32)
at jdbctest.main(jdbctest.java:40)
我是大二软开(java)生,刚想入门JDBC的,java基础还可以,这是我看书后根据书上的代码敲的,但是里面的代码有些还是不大能够理解的,而且有些也摸不透,求大神指教怎么修改以及里面一些关键内容的指点~~谢谢·1