java实现JDBC连接MySql及引用驱动程序包2016-08-20
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class ConnectToDataBase {public static Connection getDataBaseConnection(){String driver="com.mysql.jdbc.Driver";String url="jdbc:mysql://localhost:3306/db_pms";String user="root";String password="123456";//加载驱动程序try {Class.forName(driver);//URL:http://www.bianceng.cn/Programming/Java/201608/50376.htm//System.out.println("驱动程序加载成功");} catch (ClassNotFoundException e) {e.printStackTrace();}//链接数据库Connection conn=null;try {conn=DriverManager.getConnection(url, user, password);if (!conn.isClosed()) {System.out.println("连接数据库成功");}} catch (SQLException e) {System.out.println("链接数据库失败: "+e.getMessage());}return conn;}}
Connectionconn=ConnectToDataBase.getDataBaseConnection();