第一种:
package dbutil;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class DBUtil {
static {
try {
//加载数据库驱动程序
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
public static Connection getConnection(){
Connection conn=null;
//建立连接
try {
// 这块地getConnection()方法是这样的 public static Connection getConnection(String url, String user, String password)
conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb","root","123456");
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
}
第二种方式:
.properties文件里面保存的是mysql的用户名和密码
package dbutil;
import java.io.File;
import java.io.FileInputStream;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.util.Properties;
import dbutil.DBUtil;
public class DBUtil {
static{
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
// 获取数据库连接对象
public static Connection getDBConnection(String url) {
Properties pro=new Properties();
InputStream input=null;
Connection conn=null;
try {
input=new FileInputStream("d:"+File.separator+"db.properties");
pro.load(input);
//用的方法和第一种的getConnection()不一样 public static Connection getConnection(String url,java.util.Properties info)
conn=DriverManager.getConnection(url,pro);
} catch (Exception e) {
e.printStackTrace();
}
return conn;
}
}