MyBatis 通配，实现数据的增删改查

common.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="socket.dao.common" >
<select id="list"  resultType="java.util.Map"  parameterType="java.util.Map" >
${sql}
</select>
 <insert id="insert" parameterType="java.util.Map" >
    ${sql}
  </insert>
  <update id="update" parameterType="java.util.Map" >
    ${sql}
    </update>
    <delete id="delete" parameterType="java.util.Map" >
    ${sql}
  </delete>
</mapper>




common.java
package socket.dao;




import java.util.HashMap;
import java.util.List;
import java.util.Map;




public interface common {
List<HashMap<Object, Object>> list(Map<String, Object> map);
int insert(Map<String, Object> map);
int update(Map<String, Object> map);
int delete(Map<String, Object> map);
}


gatewaymansys_operate.java
package socket.dao;


import java.io.Reader;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;


import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSession;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;


import com.alibaba.fastjson.JSONObject;


import net.sf.json.JSONArray;
import socket.pojo.ub_berth;
import socket.pojo.ub_parking;
import socket.pojo.ub_receiver;
import socket.util.util;


public class gatewaymansys_operate {

    public SqlSessionFactory getSession(){
    SqlSessionFactory sqlSessionFactory=null;
    try {
    Reader reader=Resources.getResourceAsReader("gatewaymansys.xml") ;
            sqlSessionFactory=new SqlSessionFactoryBuilder().build(reader);
} catch (Exception e) {
//log.e(e);
e.printStackTrace();
}
        return sqlSessionFactory;
    }
    


    
    public List ub_parking_list()
    {
    List result=null;
    SqlSession session = getSession().openSession();
        try {
        Map<String, Object> map = new HashMap<String, Object>();
    map.put("sql", "select * from ub_dictionary");
    result =  session.selectList("socket.dao.common.list",map);
        } finally {
        session.close();
        }
    return result;
    }
    public int ub_parking_insert()
    {
    int result=0;
    SqlSession session = getSession().openSession();
        try {
        Map<String, Object> map = new HashMap<String, Object>();
    map.put("sql", "INSERT INTO ub_dictionary VALUES(1,2,'','','')");
    result =  session.insert("socket.dao.common.insert",map);
    session.commit();
        } finally {
        session.close();
        }
    return result;
    }
    public int ub_parking_update()
    {
    int result=0;
    SqlSession session = getSession().openSession();
        try {
        Map<String, Object> map = new HashMap<String, Object>();
    map.put("sql", "update ub_dictionary set dictionary_type=111,dictionary_value=1222 where  dictionary_type=2 and dictionary_value=1");
    result =  session.insert("socket.dao.common.update",map);
    session.commit();
        } finally {
        session.close();
        }
    return result;
    }
    public int ub_parking_delete()
    {
    int result=0;
    SqlSession session = getSession().openSession();
        try {
        Map<String, Object> map = new HashMap<String, Object>();
    map.put("sql", "delete from ub_dictionary where dictionary_type=111 and dictionary_value=1222 ");
    result =  session.insert("socket.dao.common.delete",map);
    session.commit();
        } finally {
        session.close();
        }
    return result;
    }
    
    
    
    public static void main(String[] args) {
    gatewaymansys_operate go=new gatewaymansys_operate();
    util.list_to_JSONArray(go.ub_parking_list());
    //System.out.println(go.ub_parking_insert());
    //System.out.println(go.ub_parking_update());
    //System.out.println(go.ub_parking_delete());
    }
}


gatewaymansys.xml
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <typeAliases> 
    </typeAliases> 


    <environments default="development">
        <environment id="development">
        <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
            <property name="driver" value="com.mysql.jdbc.Driver"/>
            <property name="url" value="jdbc:mysql://127.0.0.1:3306/gatewaymansys" />
            <property name="username" value="gatewayuser"/>
            <property name="password" value="j0175U7922.8"/>
            </dataSource>
        </environment>
    </environments>
    
    <mappers>
        <mapper resource="socket/mapping/common.xml"/>
    </mappers>
    
</configuration>




util.java
package socket.util;


import java.sql.ResultSet;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Map;


import net.sf.json.JSONArray;
import net.sf.json.JSONObject;
import socket.util.log;


public class util {
public static JSONArray rstoarr(ResultSet rs, String... args) {
JSONArray arr = new JSONArray();
try {
while (rs.next()) {
JSONObject o = new JSONObject();
for (String key : args) {
if (key == null) {
// o.put(key, "");
} else {
Object value = rs.getObject(key);
if (value == null)
o.put(key, "");
else
o.put(key, value);
}
}
arr.add(o);
}
} catch (Exception e) {
log.e(e);
}
return arr;
}
public static JSONArray list_to_JSONArray(List<HashMap<Object, Object>> list)
{
JSONArray jsonArray=new JSONArray();
for (int i = 0; i < list.size(); i++) {
HashMap map=(HashMap)list.get(i);
Iterator iter = map.entrySet().iterator();
JSONObject jsonObject=new JSONObject();
while(iter.hasNext()){
Map.Entry entry = (Map.Entry) iter.next();
Object key = entry.getKey();
Object value = entry.getValue();
jsonObject.put((String) key, value);
}
jsonArray.add(jsonObject);
}
System.out.println(jsonArray.toString());
return jsonArray;
}

}