MySQL数据库连接

MySQL数据库连接方式

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

//定义数据库连接类DBUtilTest
public class DBUtilTest {
 public static Connection getConnection() {
  Connection con = null;
  
  try {
   Class.forName("com.mysql.jdbc.Driver");
   final String url = "jdbc:mysql://localHost:3306/mydb";
   final String userName = "root";
   final String userPassword = "sa123";
   try {
    con = DriverManager.getConnection(url, userName, userPassword);
   } catch (SQLException e) {
    // TODO Auto-generated catch block
    e.printStackTrace();
   }
  } catch (ClassNotFoundException e) {
   // TODO Auto-generated catch block
   e.printStackTrace();
  } finally {
   return con;
  }
 }
 public static void main(String[] args){
     DBUtil db=new DBUtil();
     Connection connection=db.getConnection();
     System.out.println("连接成功！");
     System.out.println(connection .getClass().getName());
    }
}

运行结果：

 

本文用到的jar包下载链接地址：http://download.csdn.net/detail/u013003837/7413045

MySQL数据库、MySQL图形界面及破解注册机下载链接：http://download.csdn.net/detail/u013003837/7413147

PS:建议结合Sql Server数据库连接方式一起看，链接地址：http://blog.csdn.net/u013003837/article/details/27334897