java 的JDBC链接

public class jdbc001_demo {
	public static void main(String[] args) throws SQLException {
		//1、注册驱动
		DriverManager.registerDriver(new SQLServerDriver());		
		//2、创建连接
		Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433;databaseName=ZLITS_ITMP_VPMM;username=sa;password=Rfid123456");
		//Connection con = DriverManager.getConnection("jdbc:sqlserver://127.0.0.1:1433/ZLITS_ITMP_VPMM","sa","Rfid123456");
		//3、得到执行sql语句的Statement对象
		Statement stmt = con.createStatement();
		//4、执行sql语句，并返回结果
		String sql = "select * from CHEMICALS_COMPANY_INFO";
		ResultSet rs = stmt.executeQuery(sql);
		//5、处理结果
		while(rs.next()){
			System.out.println(rs.getObject(2));
			System.out.println("-----------------");
		}
		//6关闭资源
		rs.close();
		stmt.close();
		con.close();
	}

}