Sunday, 15 July 2012

sql - how to pass another database in stored procedure as a parameter in java -



sql - how to pass another database in stored procedure as a parameter in java -

i want pass database stored procedure in java phone call sel_rptdaywiseproduction(?) how pass dierp database in sp in java in callable statement please help give thanks you.

edit: code comment

callablestatement cs = con.preparecall("{call sel_rptdaywiseproduction(?)}"); cs.setstring(1, "dierp"); resultset rs1 = cs.executequery(); while (rs1.next()) { system.out.println("mat_code = "); }

java sql stored-procedures

No comments:

Post a Comment