1 package smile.stored; 2 3 import java.util.*; 4 import java.sql.*; 5 6 14 public class s_updateSavedSearches extends StoredProcedure implements ProcedureInterface { 15 16 String in_userid; 18 19 String in_search; 20 21 String in_searchName; 22 23 26 public s_updateSavedSearches() { 27 } 28 29 37 public void init(HashMap initData, Connection con) { 38 super.init(initData, con); 40 in_userid = utils.getString(data, "USERID", ""); 42 in_search = utils.getString(data, "SEARCH", ""); 43 in_searchName = utils.getString(data, "SEARCHNAME", ""); 44 } 45 46 52 public void checkParams() throws SQLException { 53 } 54 55 61 public void checkAction() throws SQLException { 62 } 63 64 70 public void executeAction() throws SQLException { 71 StringBuffer v_sb = new StringBuffer (); 72 v_sb.append("INSERT INTO tblpermsavedsearches ").append("(userid, search, searchname) ").append( 73 "VALUES ( '" + in_userid + "', '" + in_search + "', '" + in_searchName + "')"); 74 execStatement(v_sb.toString()); 75 76 execStatementToRS(queryResultOk); 77 } 78 } 79 | Popular Tags |