java连接mysql测试代码_java连接mysql 测试代码 | 学步园

package cvit.com.dao;

import java.sql.*;

public class GetConnection {

public Connection getConnection()

{

Connection conn=null;

try

{

try {

Class.forName("com.mysql.jdbc.Driver");

}

catch (ClassNotFoundException ex)

{

System.out.println("加载驱动程序有错误");

}

String url = "jdbc:mysql://localhost:3306/eshop?user=root&password=root&useUnicode=true&characterEncoding=gb2312";

conn = DriverManager.getConnection(url);

System.out.println("成功连接数据库！！");

}

catch (SQLException ex1)

{

System.out.print("取得连接的时候有错误，请核对用户名和密码");

}

return conn;

}

public static void main(String[]args)

{

GetConnection getConn=new GetConnection();

getConn.getConnection();

}

}