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