jdbc2.java

SQL SERVER数据库连接java源代码,

import java.sql.*;
import java.util.*;

/**
 * @author 
 *
 */
public class JDBC2 {

	/**
	 * @param args
	 */
	 public static void main  (String[] args) throws Exception{
	        Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
	        Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost;user=***;password=***;database=***");
	               DatabaseMetaData dbmd = conn.getMetaData();
	               System.out.println("Driver version is " + dbmd.getDriverVersion() );

	               Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
	               try {stmt.executeUpdate("drop table TimeZoneTable");}
	               catch (Exception e) {}
	               stmt.executeUpdate("create table TimeZoneTable (col1 datetime)");

	               ResultSet rs;

	               TimeZone.setDefault(TimeZone.getTimeZone("America/Los_Angeles"));
	               System.out.println("My time zone is " + TimeZone.getDefault());

	               stmt.executeUpdate("insert into TimeZoneTable (col1) values (N'4/2/2006 02:00:00.008')");	

	               rs = stmt.executeQuery("select cast (col1 as char(25)) from TimeZoneTable");
	               rs.next();
	               System.out.println("\nTime from database (as string): " + rs.getString(1));	
	               rs = stmt.executeQuery("select col1 from TimeZoneTable");
	               rs.next();
	               System.out.println("Returned time with no Calendar: " + rs.getTimestamp(1));
	               System.out.println("Returned time with America/New_York Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/New_York"), Locale.US)));
	               System.out.println("Returned time with America/Phoenix Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Phoenix"), Locale.US)));
	               System.out.println("Returned time with America/Denver Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Denver"), Locale.US)));
	               System.out.println("Returned time with America/Indianapolis Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("America/Indianapolis"), Locale.US)));
	               System.out.println("Returned time with Pacific/Honolulu Calendar: " + rs.getTimestamp(1, Calendar.getInstance(TimeZone.getTimeZone("Pacific/Honolulu"), Locale.US)));

	    }
	}