mybatis直接运行sql

mapper.java

1
2
3
4
5
6
7
List<LinkedHashMap<String, Object>> selectByYear(String sql);

int insert(String sql);

int update(String sql);

int delete(String sql);

mapper.xml

1
2
3
4
5
6
7
8
9
10
11
12
<select id="selectByYear" parameterType="java.lang.String" resultType="java.util.LinkedHashMap">
${value}
</select>
<insert id="insert" parameterType="java.lang.String">
${value}
</insert>
<update id="update" parameterType="java.lang.String">
${value}
</update>
<delete id="delete" parameterType="java.lang.String">
${value}
</delete>