Examples of org.fto.jthink.jdbc.Column

org.fto.jthink.jdbc.Column

列, 用于描述Select语句返回的数据列. 构建的列可以是标准的表字段,也可以是一个表达式或一个SQL子查询.

 以下是可以构建的列的几种形式: 表字段: fieldName1, fieldName2, fieldName3 AS tmpfieldName3 表达式: (fieldName1*100-50) AS tmpfieldName1, (3+2-5) AS tmpfieldName2 SQL了查询: (select table2.fieldName1 from table2 where table2.id = table1.id) AS tmpfieldName1

 历史更新记录: 2005-07-30  创建此类型

@author wenjian @version 1.0 @since JThink 1.0

    condn.add(new ConditionItem("F5", "=", "5"));
    condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
    
    
    Column[] columns = new Column[]{
        new Column("DEPT_ID"),
        new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
        new Column("F1"),
        new Column("F2"),
        new Column("F3"),
        new Column("F4"),
        new Column("F5"),
        new Column("F6"),
    };
    
    /* constructSQLForSelect测试开始 */
    {
      double totalUseTime = 0;

View Full Code Here

    
    printObjects(sqlStatement.getValues());
    
    Condition userNameCDN = new Condition();
    userNameCDN.add(new ConditionItem("Users.UserId", "=", "Departments.UserId", true));
    SQL userNameSQL = sqlBuilder.constructSQLForSelect("Users", new Column[]{new Column("UserName")}, userNameCDN);
    
    Column[] columns = new Column[]{
      new Column("DeptId"),
      new Column("DeptName", "DeptName"),
      new Column("DeptXXX1", "DeptName"),
      new Column("DeptXXX2", "DeptId*100/6"),
      new Column("DeptXXX3", (String)null),
      new Column("UserName", userNameSQL),
    };
//    new String[]{"DeptId, DeptName, DeptDesc"}


    //System.out.println("str comp:"+("DeptName"=="DeptName"));

View Full Code Here

    condn.add(new ConditionItem("F5", "=", "5"));
    condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
    
    
    Column[] columns = new Column[]{
        new Column("DEPT_ID"),
        new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
        new Column("F1"),
        new Column("F2"),
        new Column("F3"),
        new Column("F4"),
        new Column("F5"),
        new Column("F6"),
    };
    
    /* constructSQLForSelect测试开始 */
    {
      double totalUseTime = 0;
      int count = 0;
      for(int i=0;i<2000;i++){//在此设置测试次数
          long stime = System.nanoTime();        
          
          condn = new Condition();
          condn.add(new ConditionItem("DEPT_NAME", "IN", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)));
          condn.add(new ConditionItem("DEPT_NO", "IS", "NOT NULL"));
          condn.add(new ConditionItem("F1", "=", "1"));
          condn.add(new ConditionItem("F2", "=", "2"));
          condn.add(new ConditionItem("F3", "=", "3"));
          condn.add(new ConditionItem("F4", "=", "4"));
          condn.add(new ConditionItem("F5", "=", "5"));
          condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
          
          
          columns = new Column[]{
              new Column("DEPT_ID"),
              new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
              new Column("F1"),
              new Column("F2"),
              new Column("F3"),
              new Column("F4"),
              new Column("F5"),
              new Column("F6"),
          };          
          
          /* 测试代码 开始 */
          hsqlBuilder.constructSQLForSelect("departments",false, columns, condn, "DeptId", "DeptName", 5, 20).getSQLString();
          /* 测试代码 结束 */

View Full Code Here

    condn.add(new ConditionItem("F5", "=", "5"));
    condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
    
    
    Column[] columns = new Column[]{
        new Column("DEPT_ID"),
        new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
        new Column("F1"),
        new Column("F2"),
        new Column("F3"),
        new Column("F4"),
        new Column("F5"),
        new Column("F6"),
    };
    
    /* constructSQLForSelect测试开始 */
    {
      double totalUseTime = 0;
      int count = 0;
      for(int i=0;i<2000;i++){//在此设置测试次数
          long stime = System.nanoTime();        
          
          Condition condnA = new Condition();
          condnA.add(new ConditionItem("DEPT_NAME", "IN", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=?", new Object[]{1})));
          condnA.add(new ConditionItem("DEPT_NAME", "IN", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID in (?)", new Object[]{1, 2, 3, 4})));
          condnA.add(new ConditionItem("DEPT_NO", "IS", "NOT NULL"));
          condnA.add(new ConditionItem("F1", "=", "1"));
          condnA.add(new ConditionItem("F2", "=", "2"));
          condnA.add(new ConditionItem("F3", "=", "3"));
          condnA.add(new ConditionItem("F4", "=", "4"));
          condnA.add(new ConditionItem("F5", "=", "5"));
          condnA.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
          
          
          columns = new Column[]{
              new Column("DEPT_ID"),
              new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
              new Column("F1"),
              new Column("F2"),
              new Column("F3"),
              new Column("F4"),
              new Column("F5"),
              new Column("F6"),
          };
          
          /* 测试代码 开始 */
          mssqlSQLBuilder.constructSQLForSelect("departments",false, columns, condnA, "DeptId", "DeptName", 5, 20).getSQLString();
          /* 测试代码 结束 */

View Full Code Here

    condn.add(new ConditionItem("F5", "=", "5"));
    condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
    
    
    Column[] columns = new Column[]{
        new Column("DEPT_ID"),
        new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
        new Column("F1"),
        new Column("F2"),
        new Column("F3"),
        new Column("F4"),
        new Column("F5"),
        new Column("F6"),
    };
    
    /* constructSQLForSelect测试开始 */
    {
      double totalUseTime = 0;
      int count = 0;
      for(int i=0;i<2000;i++){//在此设置测试次数
          long stime = System.nanoTime();        
          
          
          condn = new Condition();
          condn.add(new ConditionItem("DEPT_NAME", "IN", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)));
          condn.add(new ConditionItem("DEPT_NO", "IS", "NOT NULL"));
          condn.add(new ConditionItem("F1", "=", "1"));
          condn.add(new ConditionItem("F2", "=", "2"));
          condn.add(new ConditionItem("F3", "=", "3"));
          condn.add(new ConditionItem("F4", "=", "4"));
          condn.add(new ConditionItem("F5", "=", "5"));
          condn.add(new ConditionItem("F6", "in", new Object[]{"1", "2", "3", "4"}));
          
          
          columns = new Column[]{
              new Column("DEPT_ID"),
              new Column("DEPT_NAME", new SQL(SQL.SELECT, "SELECT DEPT_NAME FROM ALL_DEPTS WHERE D.DEPT_ID=C.DEPT_ID", null)),
              new Column("F1"),
              new Column("F2"),
              new Column("F3"),
              new Column("F4"),
              new Column("F5"),
              new Column("F6"),
          };
          
          /* 测试代码 开始 */
          mysqlSQLBuilder.constructSQLForSelect("departments",false, columns, condn, "DeptId", "DeptName", 5, 20).getSQLString();
          /* 测试代码 结束 */

View Full Code Here

    assertEquals(condn.getConditionString().trim(), "NOT DeptName like ? AND ( DeptId != ? OR ( DeptId = ? OR DeptId Between ? AND ? ) ) AND NOT DeptDesc like ?");
    printObjects(condn.getValues());
    
    Condition deptCondn = new Condition();
    deptCondn.add(new ConditionItem("Depts.DeptId", "=", "Users.DeptId", true));
    SQL sql = sqlBuilder.constructSQLForSelect("Depts", new Column[]{new Column("DeptName")},deptCondn);
    
    condn = new Condition();
    condn.add(new ConditionItem("DeptName", "like", "%部%", true));
    condn.add(new ConditionItem("Depts.DeptId", "=", "Users.DeptId", true));
    condn.add(new ConditionItem("DeptName", "=", sql));

View Full Code Here

    try{
      transaction.begin();
      
      /* 返回的列 */
      Column[] column = {
        new Column("RevertContent"),
        new Column("Reverter"),
      };
      
      /* 条件 */
      Condition condition = new Condition();
      condition.add(new ConditionItem("ID","=", request.getParameter("ID")));

View Full Code Here

    try{
      transaction.begin();
      
      /* 返回的列 */
      Column[] column = {
        new Column("RevertContent"),
        new Column("Reverter"),
      };
      
      /* 条件 */
      Condition condition = new Condition();
      condition.add(new ConditionItem("ID","=", request.getParameter("ID")));

View Full Code Here

    try{
      transactionManager.begin();
      
      /* 返回的列 */
      Column[] column = {
        new Column("RevertContent"),
        new Column("Reverter"),
      };
      
      /* 条件 */
      Condition condition = new Condition();
      condition.add(new ConditionItem("ID","=", request.getParameter("ID")));

View Full Code Here

TOP

Related Classes of org.fto.jthink.jdbc.Column

org.fto.jthink.jdbc.ConditionTestCase

org.fto.jthink.jdbc.SQLBuilderTestCase

org.fto.jthink.lang.ObjectBuffered

org.fto.jthink.lang.StringBuffered

org.fto.jthink.sample.mboard.MBoardBusinessBean

org.fto.jthink.sample.mboard.MBoardJBean

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.