import java.sql.*;

/**
?* JDBC訪問SQL Server數據庫測試
?* @author 比爾德
?*
?*/
public class JDBCDemo
{
?public static void main(String[] args)
?{
??String driver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
??String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=test";
??Connection con = null;
??Statement st;
??ResultSet rs;
??
??try
??{
???Class.forName(driver).newInstance();?//裝載數據庫驅動程序???
??}
??catch(Exception e)
??{
???e.printStackTrace();
??}
??//System.out.print("right...");
??try
??{
???con = DriverManager.getConnection(url,"sa",null);? //創建數據庫連接實例
???st = con.createStatement();????? //設置查詢語句
???rs = st.executeQuery("select * from Student");? //保存結果集
???while(rs.next())?//顯示結果集
???{
????System.out.print("st_no = "+rs.getString(1)+"?? ");
????System.out.print("st_name = "+rs.getString(2)+"?? ");
????System.out.print("st_sex = "+rs.getString(3)+"?? ");
????System.out.println("st_grade = "+rs.getString(1));
???}
??}
??catch(Exception e)
??{
???e.printStackTrace();
??}
??finally
??{
???if(con==null) return;
???try
???{
????con.close();?//關閉數據庫連接
???}
???catch(Exception e)
???{
????e.printStackTrace();
???}
??}
??
?
?}

}