weiweichen1985

永久域名 http://weiweichen1985.javaeye.com

连接mssql2005 | 单文件上传

2007-10-26

连接mssql2000

关键字: 连接mssql2000

	private static void connect2000() {

		try {
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
			Connection conn = DriverManager
					.getConnection(
							"jdbc:microsoft:sqlserver://192.168.6.45:1433;DatabaseName=pubs",
							"sa", "sa");

			PreparedStatement pstm = conn
					.prepareStatement("select * from jobs");
			ResultSet rs = pstm.executeQuery();
			while (rs.next()) {
				System.out.println("job_id=" + rs.getInt("job_id"));
			}
			if (rs != null) {
				rs.close();
			}
			if (pstm != null) {
				pstm.close();
			}
			if (conn != null) {
				conn.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}

	}