Java串連資料庫的標準方式

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SQL {

    public static void main(String[] args) {
        String dirverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";// 載入JDBC驅動
        String URL = "jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=sic_itemSystem";//DatabaseName=sic_itemSystem資料庫名稱可以寫錯誤了,要與你資料裡看到的一個樣子
        String SqlUsername = "sa";
        String SqlPwd = "sa";

        Connection conn = null;
        Statement stmt = null;
        ResultSet rset = null;

        String pd = null;
        try {
            Class.forName(dirverName);
            conn = DriverManager.getConnection(URL, SqlUsername, SqlPwd);
            stmt = conn.createStatement();
            rset = stmt.executeQuery("SELECT * FROM user");
            while (rset.next()) {
                pd = rset.getString("userName");
                System.out.println(pd);
            }
        } catch (ClassNotFoundException e1) {
            e1.printStackTrace();
        } catch (SQLException e2) {
            e2.printStackTrace();
        } catch (Exception e3) {
            e3.printStackTrace();
        } finally {
            try {
                conn.close();
                stmt.close();
                rset.close();
            } catch (SQLException e) {

            }
        }
    }
}