PreparedStatement ResultSet

public int searchProblemDistinctCount() throws Exception {
        DBOperator dbo = getDBOperator();
        try {
            PatientproblemTableAdapter adapter = new PatientproblemTableAdapter(dbo);
            PreparedStatement st = dbo.prepareStatement("select distinct patientid from "
                    + adapter.getSchemaName() + "."
                    + adapter.getTableName() + " where status='active' and (deletedflag <> '1' or deletedflag is null)");
            ResultSet rs =st.executeQuery();
            int count=0;
            while(rs.next())
            {
                count++;
            }
            return count;
        } catch (Exception e) {
            dbo.rollback();
            throw e;
        } finally {
            dbo.close();
        }
    }

 

posted @ 2014-01-23 20:46  quietwalk  阅读(416)  评论(0编辑  收藏  举报