lianjie 链接mysql

[java]代码库

//类DBConnect用于数据库的连接

//导入sql包
import java.sql.*;
//创建数据库连接类DBConnect
public class DBConnect {
	public static void main(String[] args)
	{
		DBConnect h=new DBConnect();
		h.getConn();
	}
	 // 定义连接数据库需要的参数
	static String driverName = "com.mysql.jdbc.Driver";
	static String dbURL = "jdbc:mysql://127.0.0.1:3306/test";
	static String userName = "root";
	static String userPwd = "czq894975048";
	private static Connection Conn=null;
	public static Connection getConn(){
		try {
			// 加载驱动
			System.out.println("1");
			Class.forName("com.mysql.jdbc.Driver");
			System.out.println("加载驱动");
			// 连接数据库
			Conn = DriverManager.getConnection(dbURL, userName, userPwd);
			System.out.println("连接数据库");
		}
		catch (Exception e) {
			e.printStackTrace();
		}
		return Conn;
	}
}