import java.sql.*;
import java.net.URL;

class update 
{
	public static void main (String args[]) 
	{
		String url   ="jdbc:microsoft:sqlserver://localhost:1433;User=JavaDB;Password=javadb;DatabaseName=northwind";
		String query = "Select * From FirstTable";
		String query1 = "Update FirstTable Set Name = 'US Culture', Others = 'very good' Where ID = 1";
		String query2 = "Update firstTable Set Name = 'football',Description = 'I like it very much' Where Types = 'ball'";

		try 
		{

			//加載SQL Server JDBC驅(qū)動(dòng)程序
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
				
			Connection con = DriverManager.getConnection (url);

			//建立一個(gè)Statement對(duì)象,用這個(gè)對(duì)象向驅(qū)動(dòng)程序發(fā)送SQL語(yǔ)句
			Statement stmt = con.createStatement ();

			// 執(zhí)行更新操作
			stmt.executeUpdate(query1);
			stmt.executeUpdate(query2);

			ResultSet rs = stmt.executeQuery(query);
		
			//顯示結(jié)果集的所有行和列
			dispResultSet (rs);

			// 關(guān)閉結(jié)果集
			rs.close();

			// 關(guān)閉statement對(duì)象
			stmt.close();

			// 關(guān)閉連接
			con.close();
		}
		catch (SQLException ex) 
		{

			System.out.println ("\n*** SQLException caught ***\n");

			while (ex != null) 
			{
				System.out.println ("SQLState: " + ex.getSQLState ());
				System.out.println ("Message:  " + ex.getMessage ());
				System.out.println ("Vendor:   " + ex.getErrorCode ());
				ex = ex.getNextException ();
				System.out.println ("");
			}
		}
		catch (java.lang.Exception ex) 
		{

			//捕獲其他類型的例外
			ex.printStackTrace ();
		}
	}

	//-------------------------------------------------------------------
	// dispResultSet
	// 現(xiàn)實(shí)整個(gè)結(jié)果屆中的所有的行和列
	//-------------------------------------------------------------------

	private static void dispResultSet (ResultSet rs)
		throws SQLException
	{
		int i;

		// 取得結(jié)果集的元數(shù)據(jù)
		ResultSetMetaData rsmd = rs.getMetaData ();

		// 獲得結(jié)果集的列數(shù)
		int numCols = rsmd.getColumnCount ();

		// 顯示列的標(biāo)題

		for (i=1; i<=numCols; i++) 
		{
			if (i > 1) System.out.print(",     ");
			System.out.print(rsmd.getColumnLabel(i));
		}
		System.out.println("");
		System.out.println("");
	
		// 顯示結(jié)果集中所有數(shù)據(jù)
		boolean more = rs.next ();
		while (more) 
		{
			// 循環(huán)顯示結(jié)果集中的所有數(shù)據(jù)

			for (i=1; i<=numCols; i++) 
			{
				if (i > 1) System.out.print(",  ");
				System.out.print(rs.getString(i));
			}
			System.out.println("");

			// 獲得下一行數(shù)據(jù)
			more = rs.next ();
		}
	}
}