Examples of realcix20.utils.DAO.query()

realcix20.utils.DAO.query()

        private int getNewLayout() {
            
                int layout = -1;
            
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_MAX_LAYOUT_SQL);
                dao.setInt(1, object.getClsId());
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next())
                        layout = rs.getInt(1) + 1;

View Full Code Here

                DefaultMutableTreeNode favoritesNode = new DefaultMutableTreeNode(new ObjectInfo(-1, 
                    TxtManager.getTxt("VIEW.MAINFRAME.TREE.DAILYREPORT"), "dailyReport"));
                bookNode.add(favoritesNode);
                
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_ALL_CLS_SQL);
                ResultSet rs = dao.executeQuery();
                try {


                    while (rs.next()) {
                        int clsId = rs.getInt("CLSID");

View Full Code Here

                        DefaultMutableTreeNode objectNode = new DefaultMutableTreeNode(new ObjectInfo(clsId, 
                                TxtManager.getTxt(str), "object"));
                        //test
                        if (isMyBook)
                            bookNode.add(objectNode);
                        dao.query(Resources.SELECT_CLS_ALL_LAYOUTS_SQL);
                        dao.setObject(1, clsId);
                        ResultSet rs1 = dao.executeQuery();
                        try {                            
                            while (rs1.next()) {
                                str = new String("CL." + clsId + "." + rs1.getInt("LAYOUT"));

View Full Code Here

                                
                DefaultMutableTreeNode bookSettingsNode = new DefaultMutableTreeNode(new ObjectInfo(-1, 
                    TxtManager.getTxt("VIEW.MAINFRAME.TREE.ACCOUNTSETTINGNODE"), "accountSettings"));
                
                dao = DAO.getInstance();
                dao.query(Resources.SELECT_ALL_MOD_SQL);
                rs = dao.executeQuery();
                try {                   
                    
                    while (rs.next()) {
                        String mod = rs.getString("MOD");

View Full Code Here

                    
                    while (rs.next()) {
                        String mod = rs.getString("MOD");
                        DefaultMutableTreeNode moduleNode = new DefaultMutableTreeNode(new ObjectInfo(-1,
                                TxtManager.getTxt("MOD.".concat(mod)), "module"));
                        dao.query(Resources.SELECT_MOD_PROPERTIES_SQL);
                        dao.setString(1, mod);
                        ResultSet rs1 = dao.executeQuery();
                        boolean isMyBookSettings = false;
                        while (rs1.next()) {
                            isMyBookSettings = true;

View Full Code Here

                            String str = new String("CLS." + clsId);
                            DefaultMutableTreeNode objectNode = new DefaultMutableTreeNode(new ObjectInfo(clsId, 
                                    TxtManager.getTxt(str), "object"));
                            //test
                            
                            dao.query(Resources.SELECT_CLS_ALL_LAYOUTS_SQL);
                            dao.setObject(1, clsId);
                            ResultSet rs2 = dao.executeQuery();
                            try {
                                while (rs2.next()) {
                                    str = new String("CL." + clsId + "." + rs2.getInt("LAYOUT"));

View Full Code Here

        
        public void updateReportViewTable(int layoutId) {
            currentObject = ClassManager.createClass(currentObject.getClsId()); 
            setCurrentObject(currentObject);
            DAO dao = DAO.getInstance();
            dao.query(Resources.SELECT_CL_SQL);
            dao.setInt(1, currentObject.getClsId());
            dao.setInt(2, layoutId);
            ResultSet rs = dao.executeQuery();
            String report_basic_sql = null;
            //fix CSQL

View Full Code Here

    private boolean isRegCleared(Row regRow) {                    
        boolean result = false;
        int r = (Integer)ObjectUtil.findNewCell(regRow, "RI", "R").getColumnValue();
        int ri = (Integer)ObjectUtil.findNewCell(regRow, "RI", "RI").getColumnValue();
        DAO dao = DAO.getInstance();
        dao.query(Resources.REGS_MANAGER_R_RI_SQL);
        dao.setInt(1, r);
        dao.setInt(2, ri);
        ResultSet rs = dao.executeQuery();
        try {
            if (rs.next()) {

View Full Code Here

             
    //��ȡ��GV�����GVGroup���ϲ������ӦGV��
    public static Vector generateGVGroups() {        
        Vector gvGroups = new Vector();            
        DAO dao = DAO.getInstance();
        dao.query(Resources.SELECT_GROUPS_FROM_GV_SQL);
        ResultSet rs = dao.executeQuery();
        try {
            while (rs.next()) {
                GVGroup gvGroup = new GVGroup(rs.getString("GRP"), new Vector());
                gvGroups.add(gvGroup);

View Full Code Here

            }
            rs.close();
        } catch (Exception e) {
            e.printStackTrace();
        }                   
        dao.query(Resources.SELECT_GV_SQL);
        rs = dao.executeQuery();
        try {
            while (rs.next()) {                    
                String vid = rs.getString("VID");
                String vvalue = rs.getString("VVALUE");

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.