Java链接sqlserver数据库工具类

直接上代码

public class SqlUtils {
	private static final String DRIVERCLASS;
	private static final String URL;
	private static final String USERNAME;
	private static final String PASSWORD;

	static {
		DRIVERCLASS = ResourceBundle.getBundle("SqlServerJdbc").getString("driverClass");
		URL = ResourceBundle.getBundle("SqlServerJdbc").getString("url");
		USERNAME = ResourceBundle.getBundle("SqlServerJdbc").getString("username");
		PASSWORD = ResourceBundle.getBundle("SqlServerJdbc").getString("password");
	}

	static {
		try {
			Class.forName(DRIVERCLASS);
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		}
	}

	public static Connection getConnection() throws SQLException {

		// 2.获取连接
		Connection con = DriverManager.getConnection(URL, USERNAME, PASSWORD);
		// Connection con = DriverManager.getConnection(URL, USERNAME, PASSWORD);

		return con;
	}

	// 关闭操作
	public stat