Jakarta dbutils

目次

FrontPage
・Windows11
・Chromebook
・Random
・機械学習
・さくらVPS
・Fedora13
・SuSe10
・Docker
・Ansible
・Java
・Scala
・Python
・Ruby
・Lisp
・Computer
・GIS
・HTML
・Culture
・Link

訪問者

total: 15178
today: 1
yesterday: 4
now: 9

更新

最新の10件

人気の10件

MenuBar

整理中

package com.snail.exam.derby;
 
import org.apache.commons.dbutils.BasicRowProcessor;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.ResultSetHandler;
import org.apache.commons.dbutils.RowProcessor;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.apache.commons.dbutils.handlers.MapListHandler;
 
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
 
import java.util.LinkedList;
import java.util.List;
 
public class DerbyExam {
 
  public static void main(String[] args) throws SQLException {
    String connectionURL = "jdbc:derby:C:\\javadb\\firstdb";
 
    try {
      Connection con = DriverManager.getConnection(connectionURL);
      QueryRunner qr = new QueryRunner();
      ResultSetHandler rsh = new MapListHandler();
      List result = (List) qr.query(con,"SELECT * FROM MAGIC", rsh);
      
      for(Object m:result){
          System.out.println(m);
      }
    } catch (SQLException ex) {
      ex.printStackTrace();
    }
  }
}

BLOB †

   QueryRunner qr = new QueryRunner();
   qr.update(con,"DELETE FROM BLOB_TEST");
   qr.update(con,"INSERT INTO BLOB_TEST VALUES(?,EMPTY_BLOB())",new Object[]{1});

   QueryRunner qr = new QueryRunner();
   ResultSetHandler rsh = new MapListHandler();
   List result = (List) qr.query(con, "SELECT * FROM BLOB_TEST", rsh);
   Map record = (Map)result.get(0);
   Blob blob = (Blob)record.get("blob1");
   System.out.println(new String(blob.getBytes(1, (int)blob.length())));

   QueryRunner qr = new QueryRunner();
   ResultSetHandler rsh = new MapListHandler();
   List result = (List) qr.query(con, "SELECT * FROM BLOB_TEST FOR UPDATE", rsh);
   Map record = (Map)result.get(0);
   Blob blob = (Blob)record.get("blob1");
   blob.truncate(0L);
   blob.setBytes(1, sentence);

   QueryRunner qr = new QueryRunner();
   ResultSetHandler rsh = new MapListHandler();
   List result = (List) qr.query(con, "SELECT * FROM BLOB_TEST FOR UPDATE", rsh);
   Map record = (Map)result.get(0);
   Blob blob = (Blob)record.get("blob1");
   blob.truncate(0L);
   OutputStream out = blob.setBinaryStream(0L);
   out.write(sentence);
   out.close();

Java