Oracle存储过程的编写以及程序的实现
package com.ac.procedure.core.dao.impl;import java.util.List;import org.junit.Test;import com.ac.procedure.core.dm.SysUsers;public class SysUsersDaoImplTest { SysUsersDaoImpl sysusers=new SysUsersDaoImpl();@Testpublic void testSaveUsers() {SysUsers users=new SysUsers();users.setId(1000000000);users.setUsername("闫小甲");users.setPassword("123456");users.setSex("男");users.setStruts("启用");String result = sysusers.saveUsers(users);System.out.println("保存用户："+result);}@Testpublic void testDeleteUsers() {String result= sysusers.deleteUsers(1000000000);System.out.println("删除用户："+result);}@Testpublic void testGetUserAll() {List<SysUsers> list=sysusers.getUserAll();for (SysUsers sysUsers : list) {System.out.println("编号："+sysUsers.getId()+"\t用户名："+sysUsers.getUsername());}}}