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

Create PDF 417 in Font PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT

This shows the Oracle database after running the program: SQL> select * from string_table; STRING_COLUMN -----------------------------------abc 1234567890 hello friend! hello oracle world.

Using MySQL, define a table that has a single column of the VARCHAR type. (In MySQL, the VARCHAR data type has a limitation size of 255 characters: see the following error from the MySQL server.) mysql> create table string_table( -> string_column VARCHAR(255) -> ); mysql> desc string_table; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | string_column | varchar(255) | YES | | NULL | | +---------------+--------------+------+-----+---------+-------+ 1 row in set (0.02 sec) mysql> insert into string_table(string_column) values('abcdef'); mysql> insert into string_table(string_column) values('hello MySQL!'); mysql> commit; mysql> select * from string_table; +------------------+ | string_column | +------------------+ | abcdef | | hello MySQL! | +------------------+ 2 rows in set (0.02 sec)

This shows how to run the solution for the MySQL database: $ javac Demo_PreparedStatement_SetString.java $ java Demo_PreparedStatement_SetString mysql "this is it." --Demo_PreparedStatement_SetString begin-conn=com.mysql.jdbc.Connection@124bbbf --------------rowCount=1 --Demo_PreparedStatement_SetString end-$ java Demo_PreparedStatement_SetString mysql "hello MySQL!!!" --Demo_PreparedStatement_SetString begin-conn=com.mysql.jdbc.Connection@124bbbf --------------rowCount=1

This shows the MySQL database after running the program: mysql> select * from string_table; +------------------+ | string_column | +------------------+ | abcdef | | hello MySQL! | | this is it. | | hello MySQL!!! | +------------------+ 4 rows in set (0.00 sec)

13-18. How Do You Use PreparedStatement s setTime() and setTimestamp()

The following sections show how to pass time-related objects (java.sql.Time and java.sql.Timestamp) to a PreparedStatement object.

You can use the setTime() and setTimestamp() methods on both the Oracle and MySQL databases. In Oracle, when a column data type is DATE, then you can use the setTime() and setTimestamp() methods. Note that in Oracle the DATE data type can represent three distinct data types: Date, Time, and Timestamp. In MySQL, when a column data type is TIME, then you can use the setTime() method, and when a column data type is TIMESTAMP, then you can use the setTimestamp() method. The signatures of setTime() is as follows: public void setTimestamp(int parameterIndex, java.sql.Timestamp x) throws SQLException

This sets the designated parameter to the given java.sql.Timestamp value. The driver converts this to a SQL TIMESTAMP value when it sends it to the database. The parameters are as follows: parameterIndex: The first parameter is 1, the second is 2, and so on. x: The parameter value. This throws a SQLException if a database access error occurs. The signature of setTimestamp() is as follows: public void setTime(int parameterIndex, java.sql.Time x) throws SQLException This sets the designated parameter to the given java.sql.Time value. The driver converts this to a SQL TIME value when it sends it to the database. The parameters are as follows: parameterIndex: The first parameter is 1, the second is 2, and so on. x: The parameter value. This throws a SQLException if a database access error occurs.

Here s the solution: import java.util.*; import java.io.*; import java.sql.*; import jcb.util.DatabaseUtil; import jcb.db.VeryBasicConnectionManager; public class Demo_PreparedStatement_SetTimeAndTimestamp { public static java.sql.Timestamp getCurrentJavaSqlTimestamp() { java.util.Date date = new java.util.Date(); return new java.sql.Timestamp(date.getTime()); } public static java.sql.Time getCurrentJavaSqlTime() { java.util.Date date = new java.util.Date(); return new java.sql.Time(date.getTime()); } public static void main(String[] args) { System.out.println("--SetTimeAndTimestamp begin--"); String dbVendor = args[0]; // database vendor = { "mysql", "oracle" } String id = args[1]; Connection conn = null; PreparedStatement pstmt = null; try { conn = VeryBasicConnectionManager.getConnection(dbVendor); System.out.println("conn="+conn); System.out.println("---------------"); // prepare query String query = "insert into time_table(id, "+ "time_column, timestamp_column) values( , , )"; // create PrepareStatement object pstmt = conn.prepareStatement(query); pstmt.setString(1, id); java.sql.Time time = getCurrentJavaSqlTime(); System.out.println("time="+time); pstmt.setTime(2, time); java.sql.Timestamp timestamp = getCurrentJavaSqlTimestamp(); System.out.println("timestamp="+timestamp); pstmt.setTimestamp(3, timestamp); // execute query, and return number of rows created int rowCount = pstmt.executeUpdate(); System.out.println("rowCount="+rowCount); System.out.println("--SetTimeAndTimestamp end--"); } catch(Exception e){ e.printStackTrace(); System.exit(1); } finally { // release database resources DatabaseUtil.close(pstmt); DatabaseUtil.close(conn); }