JDBCUtlls

//相关代码
public class JDBCUtills {
	
	public static Connection getConnection() {
		//pro2的io流
		ClassLoader loader = JDBCUtills.class.getClassLoader();
		//获得src项目下的文件的流
		InputStream is = loader.getResourceAsStream("supermt.properties");
		//读取pro文件
		Properties pro = new Properties();
		Connection conn =null;
		
		//String property = System.getProperty("user.dir");
		//System.out.println(property);
		try {
			pro.load(is);
			String driver = pro.getProperty("driver");
			String url = pro.getProperty("url");
			String user = pro.getProperty("user");
			String password = pro.getProperty("password");
			Class.forName(driver);
			conn = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		
		return conn;
	}
	
	
	
 	public static void close(Statement state, Connection conn) {
		if(state!=null) {
			try {
				state.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}
	
	public static void close(Statement state, Connection conn,ResultSet rs) {
		if(state!=null) {
			try {
				state.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(conn!=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
		if(rs !=null) {
			try {
				conn.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
	}

二 相关的properties的配置

1

        sql server

driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
url=jdbc:sqlserver://localhost:1433; DatabaseName=supermt
user=用户名
password=密码

2

        mysql

driver=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/db1?useSSL=false
user=用户名
password=密码

或者

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/db1?useSSL=false
user=用户名
password=密码