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