java获取数据库一个属性的所有值

 /**
     * @use 获取某一个属性的所有值
     * @return ArrayList
     */
    public ArrayList<String> getBookType(){
        ArrayList<String> BookType = null;
        Connection con = null;
        Statement stmt = null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            con = DriverManager.getConnection("jdbc:mysql:///library", "root", "root");
            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("SELECT type FROM library.booktype");
            BookType = new ArrayList<String>();
            while(rs.next()){
                String ttype = rs.getString("type");
                BookType.add(ttype);
            }
        } catch (ClassNotFoundException | SQLException e) {
            e.printStackTrace();
        }
        return BookType;
    }