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

Maker PDF-417 2d barcode in Font PASSING INPUT PARAMETERS TO PREPAREDSTATEMENT

ID -------id-1 id-2

DATE_COLUMN -------------12-JUN-03 12-DEC-03

This shows how to run the solution for the Oracle database: $ javac Demo_PreparedStatement_SetDate.java $ java Demo_PreparedStatement_SetDate oracle id-200 --Demo_PreparedStatement_SetDate begin-conn=oracle.jdbc.driver.OracleConnection@6e70c7 --------------rowCount=1 --Demo_PreparedStatement_SetDate end-$ java Demo_PreparedStatement_SetDate oracle id-400 --Demo_PreparedStatement_SetDate begin-conn=oracle.jdbc.driver.OracleConnection@6e70c7 --------------rowCount=1 --Demo_PreparedStatement_SetDate end--

This shows the Oracle database after running the solution: SQL> select * from date_table; ID DATE_COLU ---------------id-1 12-JUN-03 id-2 12-DEC-03 id-200 07-NOV-03 id-400 07-NOV-03

Using Oracle, define a table that has a column of the DATE type, as shown next. The Oracle database accepts dates in the dd-MMM-yyyy format, while the MySQL database accepts dates in the yyyy-mm-dd format. mysql> create table date_table(id VARCHAR(12), date_column DATE); Query OK, 0 rows affected (0.14 sec) mysql> desc date_table; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | id | varchar(12) | YES | | NULL | | | date_column | date | YES | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.06 sec) mysql> insert into date_table(id, date_column) values('id-1', '12-JUN-2003'); Query OK, 1 row affected (0.01 sec) mysql> insert into date_table(id, date_column) values('id-2', '12-DEC-2003');

Query OK, 1 row affected (0.00 sec) mysql> select * from date_table; +------+-------------+ | id | date_column | +------+-------------+ | id-1 | 0000-00-00 | | id-2 | 0000-00-00 | +------+-------------+ 2 rows in set (0.13 sec) mysql> insert into date_table(id, date_column) values('id-3', '2003-06-12'); mysql> insert into date_table(id, date_column) values('id-3', '2003-12-12'); mysql> select * from date_table; +------+-------------+ | id | date_column | +------+-------------+ | id-1 | 0000-00-00 | | id-2 | 0000-00-00 | | id-3 | 2003-06-12 | | id-4 | 2003-12-12 | +------+-------------+ 4 rows in set (0.00 sec)

This shows how to run the solution for the MySQL database: $ javac Demo_PreparedStatement_SetDate.java $ java Demo_PreparedStatement_SetDate mysql id-300 --Demo_PreparedStatement_SetDate begin-conn=com.mysql.jdbc.Connection@cd2c3c --------------rowCount=1 --Demo_PreparedStatement_SetDate_MySQL end-$ java Demo_PreparedStatement_SetDate mysql id-500 --Demo_PreparedStatement_SetDate begin-conn=com.mysql.jdbc.Connection@cd2c3c --------------rowCount=1 --Demo_PreparedStatement_SetDate_MySQL end--

This shows the MySQL database after running the solution: mysql> select * from date_table; +--------+-------------+ | id | date_column | +--------+-------------+ | id-1 | 0000-00-00 | | id-2 | 0000-00-00 | | id-3 | 2003-06-12 | | id-4 | 2003-12-12 | | id-300 | 2003-11-07 | | id-500 | 2003-11-07 | +--------+-------------+ 6 rows in set (0.00 sec)

13-13. How Do You Use PreparedStatement s setFloat() and setDouble()

The following sections show how to pass a floating-point value (the Java primitive data types float and double) to a PreparedStatement object.

You can use the PreparedStatement object s setFloat() and setDouble() methods on both the Oracle and MySQL databases. In Oracle, when a column data type is NUMBER, then you can use setFloat() and setDouble(). Oracle uses the NUMBER type for integers and floating-point numbers. In MySQL, when a column data type is FLOAT, REAL, DOUBLE PRECISION, NUMERIC, or DECIMAL, then you can use setFloat() and setDouble(). The signature of setDouble() is as follows: public void setDouble(int parameterIndex, double x) throws SQLException This sets the designated parameter to the given Java double value. The driver converts this to a SQL DOUBLE 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 setFloat() is as follows: public void setFloat(int parameterIndex, float x) throws SQLException This sets the designated parameter to the given Java float value. The driver converts this to a SQL FLOAT 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.