Uncategorized

how to call mysql function from java

Class.forName(“com.mysql.jdbc.Driver”);
Connection con=DriverManager.getConnection(“”,””,””);
String stmt = “{? = CALL ISLSTDB.fn_amz_GetFinalPrice1(?,?,?)}”;
CallableStatement cs = con.prepareCall(stmt);
cs.registerOutParameter(1, java.sql.Types.FLOAT);
cs.setString(2,”MBT”);
cs.setString(3, “000799100721”);
cs.setInt(4,5);
cs.execute();//call the routine
System.out.println(cs.getFloat(1));

another way

String sql=”SELECT ISLSTDB.fn_amz_GetFinalPrice1(‘”+skucmb+”‘,'”+upc+”‘,”+Integer.parseInt(getdomaincode(domaincmb))+”)”;
//System.out.println(sql);
Statement s=conn.createStatement();
ResultSet rs1= s.executeQuery(sql);
while (rs1.next()) {
Float type = (Float) rs1.getFloat(1);
pc.setfinal_price( type);        //assign result to price checker object
}

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s