--創(chuàng)建名為 PERSON_PROC 的無參數(shù)、無返回值的存儲(chǔ)過程
create procedure PERSON_PROC
as
begin
 --往person表插入一條數(shù)據(jù)
 insert into person(name) values ('chenjy')
end

--執(zhí)行存儲(chǔ)過程
execute PERSON_PROC

--創(chuàng)建名為 PERSON_PROC2 的有輸入?yún)?shù)、有返回值的存儲(chǔ)過程
create procedure PERSON_PROC2
@Name nvarchar(10)='chenjy'  --設(shè)置默認(rèn)值
as
begin
  insert into person(name) values (@Name)
  
  select * from person
  
end


--執(zhí)行名為 PERSON_PROC2 的有輸入?yún)?shù)的存儲(chǔ)過程
execute PERSON_PROC2 'chenmm'

import java.sql.CallableStatement;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;

import com.jfinal.plugin.activerecord.DbKit;
import com.jfinal.plugin.activerecord.ICallback;
import com.jfinal.plugin.activerecord.Record;
import com.jfinal.plugin.activerecord.RecordBuilder;

public class TestCallBack implements ICallback {
  public String name = "chenjy";  

	public ResultSet rs = null;
	CallableStatement proc = null;
	public List<Record> result = null;

	@Override
	public Object call(Connection conn) throws SQLException {
		try { 
			// 調(diào)用存儲(chǔ)過程 PERSON_PROC2
			proc = conn.prepareCall("{call dbo.PERSON_PROC2(?)}");   
			// 輸入?yún)?shù)name
			proc.setString(1, name);  
			rs = proc.executeQuery();
			// 返回值
			result = RecordBuilder.build(DbKit.getConfig(), rs);
			proc.close();
		} catch (SQLException e) {
			System.out.println(e.toString());
		}
		return result;
	}

}

   TestCallBack cb = new TestCallBack();
   // 輸入?yún)?shù) name=chenjynew
   cb.name = "chenjynew";
   Db.execute(cb);
   // 打印返回值					
   System.out.print(cb.result.toString());