参考资料 1 ibatis3.0存储过存的一些细节 http://blog.csdn.net/axman/archive/2010/03/05/5349349.aspx 2 ibatis3.X如何调用Oracle存储过程定义的in数组 http://topic.c ...
参考资料 对于MyIbatis调用存储过程的一个特点是:使用Map传递参数 一 环境:XP3+Oracle10g+MyEclipse6+(Tomcat)+JDK1.5 二 Oracle存储过程 1 添加用户
Java代码
- create or replace procedure addUser(u_id in varchar2,u_name in varchar2,u_age in integer,u_sex in varchar2,u_address in varchar2,u_pwd in varchar2,message out varchar2) is
- begin
- insert into users (id,name,age,sex,address,password)VALUES(u_id,u_name,u_age,u_sex,u_address,u_pwd);
- message := '插入用户表成功';
- commit;
- EXCEPTION
- WHEN OTHERS THEN
- message :='插入用户表失败';
- end addUser;
2 修改用户 Java代码
- create or replace procedure updateUser(u_id in varchar2,u_name in varchar2,u_age in integer,u_sex in varchar2,u_address in varchar2,u_pwd in varchar2,message out varchar2) is
- begin
- update users u set name=u_name,age=u_age,sex=u_sex,address=u_address,password=u_pwd where id=u_id;
- message := '更新用户表成功';
- commit;
- EXCEPTION
- WHEN OTHERS THEN
- message :='更新用户表失败';
- end updateUser;
三 UserMapper.java Java代码
- public interface UserMapper{
-
- public int checkUserExits(User user);
-
- public void addUser(User user);
- //测试存储过程插入
- public void addUserProc(Map user);
- public List<User> getAllUser(Map map);
- public void selectByProc(Map<String,Integer> p);
- public void editUserProc(Map map);
- public void delUserProc(Map map);
- public void testCounts(Map map);
- }
Java代码
- package com.liuzd.ssm.service;
-
- import java.util.HashMap;
- import java.util.List;
- import java.util.Map;
-
- import org.apache.commons.lang3.RandomStringUtils;
- import org.junit.AfterClass;
- import org.junit.BeforeClass;
- import org.junit.Test;
- import org.springframework.context.ApplicationContext;
- import org.springframework.context.support.ClassPath
-
- import com.liuzd.ssm.entity.User;
-
- public class UserServiceTestProc {
-
- private static ApplicationContext ctx;
-
- @BeforeClass
- public static void beforeClass() {
- ctx = new ClassPath"applicationContext.
- }
-
- @AfterClass
- public static void afterClass() {
- ctx = null;
- }
-
- public UserService getUserService(){
- return (UserService)ctx.getBean("userService");
- }
-
- @Test
- public void testAddUser(){
- Map user = new HashMap();
- user.put("age",23);
- user.put("id",RandomStringUtils.randomAlphanumeric(32));
- user.put("name","李风");
- user.put("address","南京市");
- user.put("password","123");
- user.put("sex","1");
- getUserService().addUser2(user);
- System.out.println(user.get("message"));
- }
-
-
-
- @Test
- public void testUpdateUserProc(){
- Map user = new HashMap();
- user.put("id","7MhpyKczvyh5GaevvZdl49Box2nXvhHx");
- user.put("age",98);
- user.put("name","李风所");
- user.put("address","南京市");
- user.put("password","123");
- user.put("sex","1");
- getUserService().editUser2(user);
- System.out.println(user.get("message"));
- }
-
- @Test
- public void testDelUser(){
- Map map = new HashMap();
- map.put("id", "rl8hxuCW21hsZnVPopKmu0VohRow7yCk");
- getUserService().delUser2(map);
- System.out.println(map.get("message"));
- }
-
- @Test
- public void testGetUserListProc(){
- Map map = new HashMap();
- getUserService().getAllUser(map);
- List<User> list = (List<User>) map.get("userList");
- for (User user : list) {
- System.out.println(user.getAge() + "," + user.getName());
- }
- System.out.println("size :" + list.size());
- }
- }
海外公司注册、海外银行开户、跨境平台代入驻、VAT、EPR等知识和在线办理:https://www.xlkjsw.com
原标题:MyIbatis:存储过程(增,删,改,查)
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。