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();
  }




}