package bookstore;
import java.sql.*;

public class UserList
{
    //獲取HTML下拉框的用戶列表代碼
    public static String getUserListHTML() {
        Connection conn = null;
        StringBuffer sBuf = new StringBuffer();
        try {
            conn = DBConnection.getConnection();
            PreparedStatement pStat = conn.prepareStatement(
                "select USER_ID,USER_NAME from T_USER");
            ResultSet rs = pStat.executeQuery();
            while (rs.next()) {
                sBuf.append("<option value='" + rs.getString("USER_ID") + "'>" +
                            rs.getString("USER_NAME") + "</option>\n");
            }
            return sBuf.toString();
        } catch (SQLException ex) {
            ex.printStackTrace();
            return "";
        } finally {
            try {
                if (conn != null) {
                    conn.close();
                    conn = null;
                }
            } catch (SQLException ex1) {
            }
        }
    }

    public static void main(String[] args) {
        System.out.println(""+getUserListHTML());
    }
}