Package dao

Examples of dao.DataBase

12
13
14
15
16
17
18
* connect me:419723443@qq.com
*/
public class GridTreeDao {
  private DataBase dao  = null;
  public GridTreeDao(){
    dao = new DataBase();
  }
View Full Code Here
17
18
19
20
21
22
23
24
25
26
27
    dao = new DataBase();
  }
 
  public int getFirstLevelCount(){
    int ans = 0;
    dao = new DataBase();
    ResultSet rs = dao.getResultSet("SELECT COUNT(1) FROM OM_DIS_T T WHERE  T.DIS_PARENT IS NULL");
    try {
      while(rs.next()){
        ans = rs.getInt(1);
      }
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
    return ans;
  } 
 
  public List getList(int start,int end){
    List ans = new ArrayList();
    dao = new DataBase();
    String sql = "SELECT * FROM OM_DIS_T WHERE  DIS_PARENT  is NULL";
    sql = getRealQuerySql(sql,start-1,end-1);
    ResultSet rs = dao.getResultSet(sql);
    try {
      while(rs.next()){
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
    return ans;
  }
 
  public List getCommonList(int start,int end){
    List ans = new ArrayList();
    dao = new DataBase();
    String sql = "select * from om_dis_t t2 , (SELECT  dis_id FROM OM_DIS_T WHERE  DIS_PARENT  is NULL limit "+ (start-1) +","+(end-start)+") t1"+
        " where t2.dis_parent = t1.dis_id or t2.dis_id = t1.dis_id;";
    ResultSet rs = dao.getResultSet(sql);
    try {
      while(rs.next()){
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
    buf.append(queryStr).append(" limit "+start+" ,"+(end-start));
    return buf.toString();
  }
 
  public String isLeaf(String id) {
    dao = new DataBase();
    ResultSet rs = dao
        .getResultSet("SELECT T.DIS_PARENT FROM OM_DIS_T T WHERE  T.DIS_PARENT ='"
            + id + "'");
    try {
      while(rs.next()){
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
    return "0";
  }
 
  public List getListByParent(String parentId){
    List ans = new ArrayList();
    dao = new DataBase();
    ResultSet rs = dao.getResultSet("SELECT * FROM OM_DIS_T T WHERE  T.DIS_PARENT = '"+parentId+"'");
    try {
      while(rs.next()){
        DisBean bean = new DisBean();
        bean.setDisid(rs.getString(1));
View Full Code Here
TOP

Related Classes of dao.DataBase

  • testGridTree.GridTreeDao
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.