连接数据库，取数据库元素存进数组，但数组返回NULL。代码如下。不知道怎么回事

Question

连接数据库，取数据库元素存进数组，但数组返回NULL。代码如下。不知道怎么回事

public List getVoteList() {
DBConn dbconn = new DBConn();
List list = new ArrayList();

    Connection conn = dbconn.getConn();
    String sqltemp="select * from vote order by id DESC";
    try {
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery(sqltemp);
        conn.commit();

       while(rs.next()) {     
           Vote vote=new Vote();
           vote.setId(rs.getInt("id"));
           vote.setLid(rs.getInt("lid"));
           vote.setVcount(rs.getInt("vcount"));
           vote.setVname(rs.getString("vname"));
            list.add(vote);

        }        
        st.close();
        rs.close();

        conn.close();
        return list;
    }
    catch (Exception e) {
    return null;
    }

Answer 1

preparedStatement = connection.prepareStatement(sql);
resultSet = preparedStatement.executeQuery();
试试