Jakarta dbutils

2022-09-252022
73.1% (267/365)
September
80.3% (24/30)
Week 38
87.1% (6/7)
Day 25 Sun
9.8% (2.3/24)

訪問者

total: 13112
today: 1
yesterday: 1
now: 5

更新

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

目次

訪問者

更新

最新の10件

人気の10件

MenuBar

BLOB †