prepared statement
3 Message(s) by 3 Author(s) originally posted in java programmer
| From: mamta81 |
Date: Saturday, October 27, 2007
|
hi all,
I am trying to insert
data into a
table using preparedStatement
because I have to insert single quote(') in one of the
columns.Whenever I am a trying to insert a single quote it isn't
working though in other columns new data gets inserted.
the
query is
sqlQuery="insert into
po_item(po_no,po_item_cd,po_itemdesc,po_item_uom,po_item_unit_cost,po_item_qty,po_item_tax,po_item_dis,po_item_cost,SRL_NO)values
(?,?,?,?,?,?,?,?,?,?)";
desc po_item
Name Null
Type
------------------------------ --------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PO_NO NOT NULL
NUMBER(5)
PO_ITEM_CD NOT NULL
CHAR(12)
PO_ITEMDESC
VARCHAR2(2000)
PO_ITEM_UNIT_COST
NUMBER(12,2)
PO_ITEM_UOM
CHAR(6)
PO_ITEM_QTY
NUMBER(12,2)
PO_ITEM_COST
NUMBER(12,2)
PO_ITEM_TAX
NUMBER(5)
PO_ITEM_DIS
NUMBER(4,2)
PO_ITEM_RECV_QTY
NUMBER(10)
SRL_NO
NUMBER(2)
db_connection.setPreparedStatement(sqlQuery);
db_connection.getPreparedStatement().setInt(1,po_no);
db_connection.getPreparedStatement().setString(2,poTable.getValueAt(i,
0).toString().trim());
db_connection.getPreparedStatement().setString(3,poTable.getValueAt(i,
1).toString().trim());
db_connection.getPreparedStatement().setString(4,poTable.getValueAt(i,
2).toString().trim());
db_connection.getPreparedStatement().setDouble(5,Double.parseDouble(poTable.getValueAt(i,
3).toString().trim()));
db_connection.getPreparedStatement().setDouble(6,Double.parseDouble(poTable.getValueAt(i,
4).toString().trim()));
db_connection.getPreparedStatement().setDouble(7,Double.parseDouble(poTable.getValueAt(i,
5).toString().trim()));
db_connection.getPreparedStatement().setDouble(8,Double.parseDouble(poTable.getValueAt(i,
6).toString().trim()));
db_connection.getPreparedStatement().setDouble(9,Double.parseDouble(poTable.getValueAt(i,
7).toString().trim()));
db_connection.getPreparedStatement().setInt(10,serialNo);
PLS HELP!!!!!!!!!!!!!!!!!
| From: Lew |
Date: Saturday, October 27, 2007
|
wrote in message:
i [sic] am trying to insert data into a table using preparedStatement
Do you mean "PreparedStatement", as in JAVA.sql.PreparedStatement?
Case matters in JAVA.
because I [sic] have to insert single quote(') in one of the
columns.Whenever I [sic] am a trying to insert a single quote it isn't
working though in other columns new data gets inserted.
the query is
sqlQuery="insert into
po_item(po_no,po_item_cd,po_itemdesc,po_item_uom,po_item_unit_cost,po_item_qty,po_item_tax,po_item_dis,po_item_cost,SRL_NO)values
(?,?,?,?,?,?,?,?,?,?)";
desc po_item
Name Null
Type
------------------------------ --------
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
PO_NO NOT NULL
NUMBER(5)
PO_ITEM_CD NOT NULL
CHAR(12)
PO_ITEMDESC
What is all this?
Where is the
code that tries to insert a single quote?
Could you maybe try formatting your
Usenet posts to be actually readable, hmm?
PLS HELP!!!!!!!!!!!!!!!!!
Lay off the shouting, will you? It is annoying.
Provide an example that shows what you are doing and where it goes wrong, what
you
expect to happen and what's happening instead. There is not the
information in what you gave us to allow assistance.
What column are you trying to add a single-quote to? What data are you
feeding it?
FWIW, it's no problem to insert a single quote into any of the CHARACTER-based
column types using JDBC.
PreparedStatement ps = cxn.prepareStatement( sql );
ps.setString( 1, "'" );
--
Lew
| From: Roedy Green |
Date: Saturday, October 27, 2007
|
On Sat, 27 Oct 2007 04:36:05 -0700, mamta81
<roy.mamta@xxxxxxxxxxx>
wrote in message, quoted or indirectly quoted someone who said :
i am trying to insert data into a table using preparedStatement
because I have to insert single quote(') in one of the
columns.Whenever I am a trying to insert a single quote it isn't
working though in other columns new data gets inserted.
see
http://mindprod.com/jgloss/jdbc.html#LITERALS
--
Roedy
Green Canadian Mind Products
The JAVA Glossary
http://mindprod.com
Next Message: Way too much time spent with Eclipse