symbol barcode reader c# example PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT in Font

Encoder PDF417 in Font PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT

targetSqlType: The SQL type (as defined in java.sql.Types) to be sent to the database. The scale argument may further qualify this type. scale: For java.sql.Types.DECIMAL or java.sql.Types.NUMERIC types, this is the number of digits after the decimal point. For all other types, this value will be ignored. This throws a SQLException if a database access error occurs.

This shows how to set up the MySQL database: mysql> use octopus; Database changed mysql> CREATE TABLE resume ( -> id BIGINT(20) PRIMARY KEY, -> name VARCHAR(255), -> content TEXT, -- CLOB data type -> date_created DATETIME -> ); Query OK, 0 rows affected (0.23 sec) mysql> desc resume; +--------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------------+------+-----+---------+-------+ | id | bigint(20) | | PRI | 0 | | | name | varchar(255) | YES | | NULL | | | content | text | YES | | NULL | | | date_created | datetime | YES | | NULL | | +--------------+--------------+------+-----+---------+-------+ 4 rows in set (0.01 sec)

This shows how to set up the Oracle database: $ sqlplus scott/tiger SQL*Plus: Release 10.1.0.2.0 - Production on Mon Jul 11 14:14:13 2005 SQL> CREATE TABLE resume ( 2 id NUMBER(20) PRIMARY KEY, 3 name VARCHAR2(255), 4 content CLOB, 5 date_created DATE 6 ); Table created. SQL> desc resume; Name Null Type ----------------------------------------- -------- ------------ID NAME CONTENT DATE_CREATED NOT NULL NUMBER(20) VARCHAR2(255) CLOB DATE

Here s the solution: import java.util.*; import java.io.*; import java.sql.*; import jcb.util.DatabaseUtil; import jcb.db.VeryBasicConnectionManager; /** * @author: Mahmoud Parsian */ public class Demo_PreparedStatement_SetObject { public static void main(String[] args) { System.out.println("-- Demo_PreparedStatement_SetObject begin--"); ResultSet rs = null; Connection conn = null; PreparedStatement pstmt = null; PreparedStatement pstmt2 = null; try { String dbVendor = args[0]; // { "mysql", "oracle" } conn = VeryBasicConnectionManager.getConnection(dbVendor); System.out.println("conn="+conn); System.out.println("---------------"); // table column names String [] columnNames = {"id", "name", "content", "date_created"}; // inputValues contains the data to put in the database Object [] inputValues = new Object[columnNames.length];

// fill input values inputValues[0] = new inputValues[1] = new inputValues[2] = new inputValues[3] = new

java.math.BigDecimal(100); String("Alex Taylor"); String("This is my resume."); Timestamp ( (new java.util.Date()).getTime() );

// prepare blob object from an existing binary column String insert = "insert into resume (id, name, content, date_created)"+ "values( , , , )"; pstmt = conn.prepareStatement(insert); // set input parameter values pstmt.setObject(1, inputValues[0]); pstmt.setObject(2, inputValues[1]); pstmt.setObject(3, inputValues[2]); pstmt.setObject(4, inputValues[3]); // execute SQL INSERT statement pstmt.executeUpdate();

// now retrieve the inserted record from db String query = "select id, name, content, date_created from resume where id= "; // create PrepareStatement object pstmt2 = conn.prepareStatement(query); pstmt2.setObject(1, inputValues[0]); rs = pstmt2.executeQuery(); Object [] outputValues = new Object[columnNames.length]; if (rs.next()) { // outputValues contains the data retrieved from the database for ( int i = 0; i < columnNames.length; i++) { outputValues[i] = rs.getObject(i+1); } }

// // display retrieved data // if (dbVendor.equalsIgnoreCase("oracle")) { System.out.println("id="+ ((java.math.BigDecimal) outputValues[0]).toString()); System.out.println("name="+ ((String) outputValues[1])); System.out.println("content="+ ((Clob) outputValues[2])); System.out.println("date_created="+ ((java.sql.Date) outputValues[3]).toString()); } else if (dbVendor.equalsIgnoreCase("mysql")) { System.out.println("id="+ ((Long) outputValues[0]).toString()); System.out.println("name="+ ((String) outputValues[1])); System.out.println("content="+ ((String) outputValues[2])); System.out.println("date_created="+ ((java.sql.Timestamp) outputValues[3]).toString()); } System.out.println("---------------"); System.out.println("-- Demo_PreparedStatement_SetObject end--"); } catch(Exception e){ e.printStackTrace(); System.exit(1); } finally { // release database resources DatabaseUtil.close(rs); DatabaseUtil.close(pstmt); DatabaseUtil.close(pstmt2); DatabaseUtil.close(conn); } } }

This shows how to run the solution for the Oracle database: $ java Demo_PreparedStatement_SetObject oracle -- Demo_PreparedStatement_SetObject begin-conn=oracle.jdbc.driver.T4CConnection@341960 --------------id=100 name=Alex Taylor content=oracle.sql.CLOB@ccc588 date_created=2005-07-11 ---------------- Demo_PreparedStatement_SetObject end--

This shows the Oracle database after running the solution: SQL> select * from resume; ID NAME CONTENT 100 Alex Taylor This is my resume. SQL> DATE_CREATED 11-JUL-05

This shows how to run the solution for the MySQL database: $ java Demo_PreparedStatement_SetObject mysql -- Demo_PreparedStatement_SetObject begin-conn=com.mysql.jdbc.Connection@1dd46f7 --------------id=100 name=Alex Taylor content=This is my resume. date_created=2005-07-11 14:44:29.0 ---------------- Demo_PreparedStatement_SetObject end--