Java JDBCÖ±Á¬

public class www {
public static void main(String[]args) throws Exception {
//µÚÒ»²½£º¼ÓÔØÇý¶¯£¨Çý¶¯jar°ü±ØÐë¼ÓÈëclasspathÖУ©
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
//µÚ¶þ²½£º½¨Á¢Á¬½Ó£¨¸ù¾Ýʵ¼ÊÇé¿öÌæ»»Êý¾Ý¿âµÄÖ÷»úµØÖ·¡¢¶Ë¿ÚºÅ¡¢Êý¾Ý¿âÃ÷¡¢µÇ¼Ãû¡¢ÃÜÂ룩
Connection conn = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=shijiuban1", "sa", "111111");
System.out.println("µ±Ç°Á¬½Óµ½µÄÊý¾Ý¿â="+conn.getCatalog());//²é¿´µ±Ç°Á¬½Óµ½µÄÊý¾Ý¿âÃû
//µÚÈý²½£º´´½¨Statement¶ÔÏó
Statement stmt = conn.createStatement();//Ö»¶ÁµÄ½á¹û¼¯
//Statement stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);//¿É¸üеĽá¹û¼¯
//µÚËIJ½£ºÖ´ÐвÙ×÷£¨Ôöɾ¸Ä²é£©
ResultSet rs = stmt.executeQuery("select * from stt");
//´¦Àí½á¹û
while(rs.next()){
System.out.println(rs.getString("1"));
}
//µÚÎå²½£º¹Ø±ÕÁ¬½Ó
conn.close();
}
}