建立配置文件db.properties
driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc\:sqlserver\://127.0.0.1\:1433;databaseName\= 数据库名
user=数据库用户名
password=数据库连接密码
建立连接数据库的Java文件DbConnection.java
//需要导入的包
import java.io.IOException;
import java.sql.*;
import java.util.Properties;
//创造DbConnect类
public class DbConnect {
static Connection con = null;
public Connection getCon(){
//实例化Properties对象
Properties properties = new Properties();
try{
//加载配置文件,配置文件放置在根路径下,即src下
properties.load(this.getClass().getResourceAsStream("/db.properties"));
//从配置文件中加载数据
String driver = properties.getProperty("driver");
String url = properties.getProperty("url");
String user = properties.getProperty("user");
String password = properties.getProperty("password");
try{
Class.forName(driver);
}catch(ClassNotFoundException e){
e.printStackTrace();
}
try{
//连接数据库
con = DriverManager.getConnection(url,user,password);
System.out.println("连接成功");
}catch(SQLException e){
System.out.println("数据库连接失败");
}
}catch(IOException e){
e.printStackTrace();
}
return con;
}
//查询数据库方法,返回结果集
public ResultSet querySql(String sql) throws SQLException{
Statement SQL;
ResultSet rs;
SQL = con.createStatement();
rs = SQL.executeQuery(sql);
return rs;
}
//数据库插入数据方法
public void Insert(String sql)throws SQLException{
Statement SQL;
SQL = con.createStatement();
SQL.execute(sql);
}
//关闭连接的方法
public void close() throws SQLException{
if(!con.isClosed()){
con.close();
}
}
}