Sagewire Logo

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



Programming | Sports | Autos

copyright 2006
Valid XHTML 1.0 Transitional