Public map<string, string> push (final Pushbean pb) throws Exception {StringBuffer sql = new StringBuffer (); Sql.appen D ("{Call Adumwpush_mac (?,?,?,?,?,?,?,?,?,?,?)}"); map<string, string> map = new hashmap<string, string> (); map = Jdbctemplateuas.execute (sql.tostring (), New Callablestatementcallback<map<string, string>> () {public map<string, string> Doincallablestatement (final CallableStatement cs) throws Sqlexception,dataaccessexception {Cs.setint (1, Pb.getUid ()) ; Cs.setint (2, Pb.getadid ()), Cs.setint (3, Pb.gettemp ()), cs.setstring (4, Pb.getmac ()), cs.setstring (5, Pb.geturl ()); Cs.setstring (6, pb.gethurlaction ()); Cs.setstring (7, Pb.getadcontenttype ()); Cs.setstring (8, Pb.getstartime ()); Cs.setstring (9, Pb.getend ()); Cs.registeroutparameter (Java.sql.Types.INTEGER); Cs.registeroutparameter (11, Java.sql.Types.INTEGER); Cs.execute (); map<string, string> map = new hashmap<string, string> (); Map.put ("RESULT", cs.getstring); Map.put ("F_ Price ", Cs.getstriNg (one)); return map;}}); return map;}
Reference: http://blog.csdn.net/hu_shengyang/article/details/7896782