Package org.apache.commons.dbutils.handlers

Examples of org.apache.commons.dbutils.handlers.MapHandler

294
295
296
297
298
299
300
301
302
303
304
   */
  public int updateRecord(String tableName, String primaryKeyName, Map columnMap) 
    throws ControllerException, UpdaterException  {
   
    QueryRunner queryRunner = new QueryRunner();
    ResultSetHandler rsh = new MapHandler();
    String sql = null;

    try {
      sql = "select * from " + tableName;
      sql += " where (" + primaryKeyName + "=?)";
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
  public Map findDefaultContactDetails(int clientID)
    throws ControllerException  {
   
      DataSource dataSource = DataSourceHandler.getDataSource();
      QueryRunner queryRunner = new QueryRunner(dataSource);
      ResultSetHandler rsh = new MapHandler();
      String sql = null;

      try {
        sql = "select * from contact_detail INNER JOIN contact_type ON (contact_detail.contact_type_id=contact_type.contact_type_id)";
        sql += " where (";
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
  public List findInvoices(int clientID)
      throws ControllerException  {
   
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler mapListRsh = new MapListHandler();
    ResultSetHandler mapRsh = new MapHandler();
    String sql = null;
 
    try {
      // Get connection from the connection pool
      sql = "select * from invoice";
View Full Code Here
79
80
81
82
83
84
85
86
87
88
89
    DataSourceHandler.setUserName(userName);
    DataSourceHandler.setPassword(passWordInPlainText);
    DataSource dataSource = DataSourceHandler.getDataSource();
   
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rshMap = new MapHandler();
    ResultSetHandler rshList = new MapListHandler();

    try {
      String sql =
        "select * from person" + " where (" + " (user_name=?)" + " )";
View Full Code Here
189
190
191
192
193
194
195
196
197
198
199
   */
  public static void logoffPerson() {

    DataSource dataSource = DataSourceHandler.getDataSource();
    QueryRunner queryRunner = new QueryRunner(dataSource);
    ResultSetHandler rshMap = new MapHandler();

    try {
      String sql =
        "update login"
          + " set logoff_date=CURRENT_TIMESTAMP"
View Full Code Here
35
36
37
38
39
40
41
42
43
44
45
      System.out.println(se.getMessage());
      return;
    }
   
    QueryRunner runner = new QueryRunner();
    ResultSetHandler rsh = new MapHandler();
    String sql = null;
    Map clientMap = null;
    Object obj = null;
   
    try {
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
93
94
  public static Map<String, Object> getById(Connection conn,String sql,
      Object[] params) {
    Map<String, Object> map = null;
    try {
      if (params == null) {
        map = qr.query(conn, sql, new MapHandler());
      } else {
        map = qr.query(conn, sql, new MapHandler(), params);
      }
    } catch (Exception e) {
      System.err.println("��ѯ�����쳣!ԭ��:" + e);
    }
    return map;
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
135
136
     */ 
    public Map<String, Object> findFirst(String sql, Object[] params) {  
        Map<String, Object> map = null; 
        try { 
            if (params == null) { 
                map = (Map<String, Object>) qr.query(sql, new MapHandler()); 
            } else { 
                map = (Map<String, Object>) qr.query(sql, new MapHandler(), params); 
            } 
        } catch (SQLException e) {  
            System.err.println("findFirst.��ѯһ����¼����" + e); 
        } 
        return map; 
View Full Code Here
TOP

Related Classes of org.apache.commons.dbutils.handlers.MapHandler

  • cn.chen.core.DBhelp
  • nz.co.transparent.client.controller.GenericController
  • nz.co.transparent.client.controller.GenericTransactionController
  • nz.co.transparent.client.controller.LoginController
  • nz.co.transparent.client.controller.SpecificController
  • nz.co.transparent.client.controller.SystemDBController
  • test.TestDbUtils
  • test.TestDbUtils2
  • test.TestDbUtils3
  • test.TestException
    • 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.