存储过程添加数据

最新推荐文章于 2024-07-22 09:23:06 发布

一师兄

最新推荐文章于 2024-07-22 09:23:06 发布

阅读量866

点赞数

分类专栏：数据库文章标签：存储 service iterator string path insert

本文链接：https://blog.csdn.net/rocgege/article/details/7794071

版权

数据库专栏收录该内容

52 篇文章 0 订阅

订阅专栏

create or replace procedure save_SERVICE(
service_name in varchar2,
mainnmethod in varchar2,
appenv in varchar2,
ip in varchar2,
isautorun in varchar2,
osenv in varchar2,
path in varchar2,
servicetype in varchar2,
url in varchar2,
service_status in varchar2

) is
begin
insert into bank.cpkservice
(CPKSERVICEID,CPKSERVICENAME,CPKSERVICEMAINMETHOD,
CPKSERVICEAPPENV,CPKSERVICEIP,CPKSERVICEISAUTORUN,
CPKSERVICEOSENV,CPKSERVICEPATH,CPKSERVICETYPE,CPKSERVICEURL,STATUS)
values(bank.bank_seq.nextval,service_name,mainnmethod,appenv,ip,isautorun,osenv,path,servicetype,url,service_status);
end;

/**
	 * insert a record to a table
	 * @param produreName
	 * @param map <int,String>
	 * @return
	 * @throws SQLException
	 */
	public static int execSaveProdure(String produreName,
			Map<String, String> map) throws SQLException {
		int item = 0;

		if (map != null) {
			connection = DBConnPool.getInstance().getConnection();
			int paramSize = map.size();
			StringBuffer params = new StringBuffer();
			for (int i = 0; i < paramSize; i++) {
				params.append("?");
				if (i != paramSize-1) {
					params.append(",");
				}
			}
			StringBuffer produreCMD = new StringBuffer();
			produreCMD.append("{call ").append(produreName).append("(")
					.append(params.toString()).append(")}");
			CallableStatement statement = connection.prepareCall(produreCMD
					.toString());
			Set<String> keySet = map.keySet();
			for (Iterator iterator = keySet.iterator(); iterator.hasNext();) {
				String key = (String) iterator.next();
			
				statement.setString(Integer.parseInt(key), map.get(key));
			}
			item = statement.executeUpdate();
		}

		return item;
	}