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

class insert {
public static void main (String args[]) {
String url ="jdbc:microsoft:sqlserver://localhost:1433;User=JavaDB;Password=javadb;DatabaseName=northwind";
//設(shè)置三個(gè)SQL語(yǔ)句
String query = "Select * From FirstTable";

String query1 = "Insert Into FirstTable(ID, Name , Types, Description,Others) Values (6, 'java', 'IT Technology', 'this book is for programmer','great')";

String query2 = "Insert Into FirstTable(ID, Name , Types, Description,Others) Values (7, 'Amercian Culture', 'literature', 'this book is for people who wants to know something about US Culture','good')";

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 ();

		//提交兩個(gè)不同的插入操作
 		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) {

		// 捕獲例外并顯示它的詳細(xì)信息
		ex.printStackTrace ();
	}
}
//-------------------------------------------------------------------
// dispResultSet
// 顯示整個(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 ();
		}
}
}