bc... [密码]
Home » Source Code » Telecom billing system » AdminMapper.xml

AdminMapper.xml ( File view )

  • By mumu93 2015-03-30
  • View(s):0
  • Download(s):17
  • Point(s): 0
			<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC "-//ibatis.apache.org//DTD Mapper 3.0//EN" 
	"http://ibatis.apache.org/dtd/ibatis-3-mapper.dtd">
<mapper namespace="com.tarena.dao.AdminDao">
	
	<!-- 查询所有的管理员数据,并且查询出管理员所拥有的角色 -->
	<select id="findByPage" parameterType="com.tarena.entity.page.AdminPage" resultMap="adminMap">
		SELECT * FROM (
			SELECT  a.*, ROWNUM r FROM(
				SELECT * FROM admin_info_eddyli ai
				WHERE ai.admin_id in(
					SELECT ai.admin_id FROM admin_info_eddyli ai
					LEFT JOIN admin_role_eddyli ar
					ON ar.admin_id = ai.admin_id
					LEFT JOIN role_info_eddyli ri
					ON ar.role_id = ri.role_id
					LEFT JOIN role_module_eddyli rm
					ON ri.role_id = rm.role_id
					LEFT JOIN module_info_eddyli mi
					ON rm.module_id = mi.module_id
					<where>
						<if test="module_id != null &amp;&amp; module_id != -1">
							AND mi.module_id = #{
module_id
}
						</if>
						<if test="role_name != null &amp;&amp; role_name.length() > 0">
							AND ri.name LIKE '%${
role_name
}%'
						</if>
					</where>
				)
				ORDER BY admin_id
			) a
		)
		WHERE r > #{
begin
} AND r&lt; #{
end
} 
	</select>
	<select id="findRoleByAdminId" parameterType="int" resultType="com.tarena.entity.Role">
		SELECT * FROM role_info_eddyli
		WHERE role_id in(
			SELECT role_id FROM admin_role_eddyli
			WHERE admin_id = #{
admin_id
}
		)
	</select>
	<resultMap id="adminMap" type="com.tarena.entity.Admin">
		<id column="admin_id" property="admin_id"/>
		<collection property="roles"
					javaType="arraylist"
					ofType="com.tarena.entity.Role"
					column="admin_id"
					select="findRoleByAdminId">
		
		</collection>
	</resultMap>
	
	<!-- 查询所有的行数 -->
	<select id="findRows" parameterType="com.tarena.entity.page.AdminPage" resultType="int">
		SELECT COUNT(*) FROM admin_info_eddyli ai
		WHERE ai.admin_id in(
					SELECT ai.admin_id FROM admin_info_eddyli ai
					LEFT JOIN admin_role_eddyli ar
					ON ar.admin_id = ai.admin_id
					LEFT JOIN role_info_eddyli ri
					ON ar.role_id = ri.role_id
					LEFT JOIN role_module_eddyli rm
					ON ri.role_id = rm.role_id
					LEFT JOIN module_info_eddyli mi
					ON rm.module_id = mi.module_id
					<where>
						<if test="module_id != null &amp;&amp; module_id != -1">
							AND mi.module_id = #{
module_id
}
						</if>
						<if test="role_name != null &amp;&amp; role_name.length() > 0">
							AND ri.name LIKE '%${
role_name
}%'
						</if>
					</where>
				)
	</select>
	
	<!-- 查询所有的角色信息进行下拉选的初始化 -->
	<select id="findAllRole" resultType="com.tarena.entity.Role">
		SELECT * FROM role_info_eddyli
	</select>
	
	<!-- 保存管理员信息 -->
	<insert id="save" parameterType="com.tarena.entity.Admin">
		<!-- 先根据序列查询出序列值 -->
		<selectKey keyProperty="admin_id" order="BEFORE" resultType="int">
			SELECT admin_eddyli_seq.NEXTVAL FROM DUAL
		</selectKey>
		INSERT INTO admin_info_eddyli VALUES(
			#{
admin_id
},
			#{
admin_code
},
			#{
password
},
			#{
name
},
			#{
telephone
},
			#{
email
},
			#{
enrolldate
}
		)
	</insert>
	
	<!-- 保存管理员角色中间表信息 -->
	<insert id="saveAdminRole" parameterType="hashmap">
		INSERT INTO admin_role_eddyli VALUES(
			#{
admin_id
},#{
role_id
}
		)
	</insert>
	
	<!-- 重置密码功能 -->
	<update id="resetPassword" parameterType="hashmap">
		UPDATE admin_info_eddyli
		SET password=#{
password
}
		WHERE admin_id in
		<foreach collection="ids"
				 open="("
				 close=")"
				 separator=","
				 item="id">
				 #{
id
}
		</foreach>
	</update>
	
	<!-- 删除管理员表数据 -->
	<delete id="delete" parameterType="int">
		DELETE FROM admin_info_eddyli
		WHERE admin_id = #{
admin_id
}
	</delete>
	
	<!-- 删除管理员角色表数据 -->
	<delete id="deleteAdminRole" parameterType="int">
		DELETE FROM admin_role_eddyli
		WHERE admin_id = #{
admin_id
}
	</delete>
	
	<!-- 根据id查询一条管理员数据 -->
	<select id="findById" parameterType="int" resultMap="adminMap">
		SELECT * FROM admin_info_eddyli
		WHERE admin_id = #{
admin_id
}
	</select>
	
	<!-- 更新管理员表数据 -->
	<update id="update" parameterType="com.tarena.entity.Admin">
		UPDATE admin_info_eddyli SET
			name = #{
name, jdbcType=VARCHAR
},
			telephone = #{
telephone, jdbcType=VARCHAR
},
			email = #{
email, jdbcType=VARCHAR
}
			WHERE admin_id = #{
admin_id
}
	</update>
	
	<!-- 根据帐号查询一条管理员信息 -->
	<select id="findByAdminCode" parameterType="string" resultType="com.tarena.entity.Admin">
		SELECT * FROM admin_info_eddyli
		WHERE admin_code = #{
admin_code
}
	</select>
	
	<!-- findModuleByAdmin -->
	<select id="findModulesByAdmin" parameterType="int" resultType="com.tarena.entity.Module">
		SELECT * FROM module_info_eddyli
		WHERE module_id in(
			SELECT mi.module_id FROM module_info_eddyli mi
			INNER JOIN role_module_eddyli rm
			ON rm.module_id = mi.module_id
			INNER JOIN role_info_eddyli ri
			ON ri.role_id = rm.role_id
			INNER JOIN admin_role_eddyli ar
			ON ri.role_id = ar.role_id
			INNER JOIN admin_info_eddyli ai
			ON ai.admin_id = ar.admin_id
			WHERE ai.admin_id = #{
admin_id
}
		)ORDER BY module_id
	</select>
	
	<!-- 更新用户信息user -->
	<update id="updateUser" parameterType="com.tarena.entity.Admin" >
		UPDATE admin_info_eddyli SET
			name = #{
name
},
			telephone = #{
telephone
},
			email = #{
email
}
			WHERE admin_id = #{
admin_id
}
	</update>
	
	<!-- 更新用户的密码password -->
	<update id="updatePassword" parameterType="com.tarena.entity.Admin">
		UPDATE admin_info_eddyli SET
			password = #{
password
}
			WHERE admin_id = #{
admin_id
}
	</update>
	
	<!-- 更新保存头像photo -->
	<update id="updatePhoto" parameterType="com.tarena.entity.Admin">
		UPDATE admin_info_eddyli SET
			photo = #{
photo
}
			WHERE admin_id = #{
admin_id
}
	</update>
</mapper>



			
...
Expand> <Close

Want complete source code? Download it here

Point(s): 0

Download
0 lines left, continue to read

File list

Tips: You can preview the content of files by clicking file names^_^
Name Size Date
01.97 kB
01.97 kB
01.97 kB
01.97 kB
MANIFEST.MF39.00 B2014-10-28 09:27
01.97 kB
01.97 kB
account_list.jsp13.87 kB2014-10-28 09:27
add_account.jsp11.32 kB2014-10-28 09:27
update_account.jsp11.54 kB2014-10-28 09:27
01.97 kB
add_admin.jsp6.09 kB2014-10-28 09:26
admin_list.jsp11.50 kB2014-10-28 09:26
update_admin.jsp5.99 kB2014-10-28 09:26
01.97 kB
bill_list.jsp8.62 kB2014-10-28 09:27
01.97 kB
applicationContext.xml5.26 kB2014-10-28 09:26
01.97 kB
01.97 kB
01.97 kB
MyBatisDAO.class162.00 B2014-10-28 09:26
01.97 kB
ExceptionLogger.class2.88 kB2014-10-28 09:26
01.97 kB
AccountController.class4.48 kB2014-10-28 09:26
AdminController.class5.40 kB2014-10-28 09:26
BaseController.class796.00 B2014-10-28 09:26
BillController.class632.00 B2014-10-28 09:26
CostController.class3.87 kB2014-10-28 09:26
LoginController.class4.39 kB2014-10-28 09:26
PasswordContorller.class2.65 kB2014-10-28 09:26
ReportController.class648.00 B2014-10-28 09:26
RoleController.class4.13 kB2014-10-28 09:26
ServiceController.class5.46 kB2014-10-28 09:26
UserController.class3.68 kB2014-10-28 09:26
01.97 kB
AccountDao.class729.00 B2014-10-28 09:26
AdminDao.class1.13 kB2014-10-28 09:26
CostDao.class719.00 B2014-10-28 09:26
RoleDao.class837.00 B2014-10-28 09:26
ServiceDao.class744.00 B2014-10-28 09:26
01.97 kB
Account.class5.69 kB2014-10-28 09:26
AccountMapper.xml3.96 kB2014-10-28 09:26
Admin.class3.36 kB2014-10-28 09:26
AdminMapper.xml5.70 kB2014-10-28 09:26
Cost.class3.04 kB2014-10-28 09:26
CostMapper.xml2.40 kB2014-10-28 09:26
Module.class1.13 kB2014-10-28 09:26
Role.class1.96 kB2014-10-28 09:26
RoleMapper.xml2.67 kB2014-10-28 09:26
Service.class3.12 kB2014-10-28 09:26
ServiceMapper.xml4.11 kB2014-10-28 09:26
01.97 kB
AccountPage.class1.51 kB2014-10-28 09:26
AdminPage.class1.21 kB2014-10-28 09:26
CostPage.class306.00 B2014-10-28 09:26
Page.class1.70 kB2014-10-28 09:26
RolePage.class306.00 B2014-10-28 09:26
ServicePage.class1.51 kB2014-10-28 09:26
01.97 kB
CheckLoginInterceptor.class2.08 kB2014-10-28 09:26
CheckModuleInterceptor.class2.56 kB2014-10-28 09:26
CurrentModuleInterceptor.class2.25 kB2014-10-28 09:26
01.97 kB
MyTest.class643.00 B2014-10-28 09:26
TestAdminDao.class1.25 kB2014-10-28 09:26
TestCostDao.class3.13 kB2014-10-28 09:26
TestRole.class2.16 kB2014-10-28 09:26
TestServiceDao.class1.71 kB2014-10-28 09:26
01.97 kB
DateEditor.class1.03 kB2014-10-28 09:26
ImageUtil.class2.50 kB2014-10-28 09:26
log4j.properties618.00 B2014-10-28 09:26
netctoss.sql11.32 kB2014-10-28 09:26
01.97 kB
add_cost.jsp7.20 kB2014-10-28 09:26
cost_list.jsp10.53 kB2014-10-28 09:26
update_cost.jsp7.59 kB2014-10-28 09:26
01.97 kB
aopalliance.jar4.36 kB2014-10-28 09:27
aspectjweaver.jar1.47 MB2014-10-28 09:27
c3p0-0.9.5-pre8.jar472.30 kB2014-10-28 09:27
commons-collections-3.1.jar546.26 kB2014-10-28 09:27
commons-dbcp-1.2.2.jar118.90 kB2014-10-28 09:27
commons-fileupload-1.2.1.jar56.42 kB2014-10-28 09:27
commons-io-1.3.2.jar85.72 kB2014-10-28 09:27
commons-logging.jar59.42 kB2014-10-28 09:27
commons-pool.jar60.65 kB2014-10-28 09:27
jackson-annotations-2.4.1.jar37.70 kB2014-10-28 09:27
jackson-core-2.4.1.jar220.03 kB2014-10-28 09:27
jackson-databind-2.4.1.jar1.02 MB2014-10-28 09:27
jstl.jar17.39 kB2014-10-28 09:27
log4j-1.2.11.jar342.41 kB2014-10-28 09:27
mchange-commons-java-0.2.7.jar588.12 kB2014-10-28 09:27
mybatis-3.2.5.jar699.60 kB2014-10-28 09:27
mybatis-spring-1.2.2.jar47.64 kB2014-10-28 09:27
ojdbc6.jar2.01 MB2014-10-28 09:27
spring-aop-3.2.8.RELEASE.jar329.78 kB2014-10-28 09:27
spring-aspects-3.2.8.RELEASE.jar50.25 kB2014-10-28 09:27
spring-beans-3.2.8.RELEASE.jar598.21 kB2014-10-28 09:27
spring-context-3.2.8.RELEASE.jar845.97 kB2014-10-28 09:27
spring-core-3.2.8.RELEASE.jar853.13 kB2014-10-28 09:27
spring-expression-3.2.8.RELEASE.jar191.76 kB2014-10-28 09:27
spring-jdbc-3.2.8.RELEASE.jar396.21 kB2014-10-28 09:27
spring-tx-3.2.8.RELEASE.jar236.75 kB2014-10-28 09:27
spring-web-3.2.8.RELEASE.jar613.73 kB2014-10-28 09:27
spring-webmvc-3.2.8.RELEASE.jar622.95 kB2014-10-28 09:27
standard.jar343.11 kB2014-10-28 09:27
01.97 kB
error.jsp1.93 kB2014-10-28 09:27
index.jsp972.00 B2014-10-28 09:27
loading.jsp4.57 kB2014-10-28 09:27
login.jsp4.35 kB2014-10-28 09:27
menu.jsp4.02 kB2014-10-28 09:27
nopower.jsp2.06 kB2014-10-28 09:27
photo.jsp399.00 B2014-10-28 09:27
taglib.jsp197.00 B2014-10-28 09:27
01.97 kB
update_password.jsp4.92 kB2014-10-28 09:27
01.97 kB
report_list.jsp8.59 kB2014-10-28 09:27
01.97 kB
add_role.jsp5.60 kB2014-10-28 09:27
role_list.jsp6.38 kB2014-10-28 09:27
update_role.jsp5.26 kB2014-10-28 09:27
01.97 kB
add_service.jsp7.63 kB2014-10-28 09:27
service_list.jsp16.41 kB2014-10-28 09:27
update_service.jsp4.79 kB2014-10-28 09:27
01.97 kB
update_user.jsp7.65 kB2014-10-28 09:27
web.xml1.42 kB2014-10-28 09:27
01.97 kB
account_on.png5.71 kB2014-10-28 09:27
account_out.png4.55 kB2014-10-28 09:27
add.png1,018.00 B2014-10-28 09:27
admin_on.png5.79 kB2014-10-28 09:27
admin_out.png4.39 kB2014-10-28 09:27
bill_on.png5.87 kB2014-10-28 09:27
bill_out.png4.57 kB2014-10-28 09:27
body_bg.png3.25 kB2014-10-28 09:27
btn_bg.png2.46 kB2014-10-28 09:27
close.png1.25 kB2014-10-28 09:27
close1.png1.22 kB2014-10-28 09:27
close3.png1.77 kB2014-10-28 09:27
delete.png1.13 kB2014-10-28 09:27
down.png2.46 kB2014-10-28 09:27
error.png394.37 kB2014-10-28 09:27
error_power.png372.28 kB2014-10-28 09:27
fail.png1.36 kB2014-10-28 09:27
fee_on.png6.25 kB2014-10-28 09:27
fee_out.png4.96 kB2014-10-28 09:27
form_btn.png4.41 kB2014-10-28 09:27
form_btn_on.png3.66 kB2014-10-28 09:27
hide.png1.88 kB2014-10-28 09:27
index_bg.jpg37.50 kB2014-10-28 09:27
index_navi_bg.png1.02 kB2014-10-28 09:27
index_on.png5.26 kB2014-10-28 09:27
index_out.png3.76 kB2014-10-28 09:27
information_on.png6.40 kB2014-10-28 09:27
information_out.png5.13 kB2014-10-28 09:27
login_bg.jpg30.85 kB2014-10-28 09:27
login_box.png78.19 kB2014-10-28 09:27
login_btn.png6.29 kB2014-10-28 09:27
logo.png16.11 kB2014-10-28 09:27
modification.png1.09 kB2014-10-28 09:27
navigation.png1,001.00 B2014-10-28 09:27
ok.png1.18 kB2014-10-28 09:27
password_on.png5.71 kB2014-10-28 09:27
password_out.png4.47 kB2014-10-28 09:27
pause.png1.14 kB2014-10-28 09:27
report_on.png4.62 kB2014-10-28 09:27
report_out.png3.25 kB2014-10-28 09:27
role_on.png5.95 kB2014-10-28 09:27
role_out.png4.55 kB2014-10-28 09:27
search.png2.26 kB2014-10-28 09:27
search_large.png1.74 kB2014-10-28 09:27
service_on.png5.70 kB2014-10-28 09:27
service_out.png4.49 kB2014-10-28 09:27
show.png1.85 kB2014-10-28 09:27
start.png1.15 kB2014-10-28 09:27
tab_on.png1.08 kB2014-10-28 09:27
tab_out.png1.11 kB2014-10-28 09:27
top_bg.png30.44 kB2014-10-28 09:27
up.png2.45 kB2014-10-28 09:27
valicode.jpg2.35 kB2014-10-28 09:27
warning.png1.12 kB2014-10-28 09:27
wrong.gif115.00 B2014-10-28 09:27
index.jsp829.00 B2014-10-28 09:27
01.97 kB
jquery-1.4.3.js176.23 kB2014-10-28 09:27
myjs.js426.00 B2014-10-28 09:27
01.97 kB
test1.jpg1.45 kB2014-10-28 09:27
test2.jpg865.00 B2014-10-28 09:27
01.97 kB
mydelete.png6.32 kB2014-10-28 09:27
mypause.png7.65 kB2014-10-28 09:27
01.97 kB
MyJsp.jsp842.00 B2014-10-28 09:27
photo_Eddyli.jpg1.36 kB2014-10-28 09:27
01.97 kB
global.css8.92 kB2014-10-28 09:27
global_color.css7.44 kB2014-10-28 09:27
01.97 kB
applicationContext.xml5.26 kB2014-10-28 09:26
01.97 kB
01.97 kB
01.97 kB
MyBatisDAO.java305.00 B2014-10-28 09:26
01.97 kB
ExceptionLogger.java1.95 kB2014-10-28 09:26
01.97 kB
AccountController.java5.16 kB2014-10-28 09:26
AdminController.java4.78 kB2014-10-28 09:26
BaseController.java720.00 B2014-10-28 09:26
BillController.java453.00 B2014-10-28 09:26
CostController.java2.77 kB2014-10-28 09:26
LoginController.java3.82 kB2014-10-28 09:26
PasswordContorller.java1.93 kB2014-10-28 09:26
ReportController.java453.00 B2014-10-28 09:26
RoleController.java3.73 kB2014-10-28 09:26
ServiceController.java5.02 kB2014-10-28 09:26
UserController.java3.21 kB2014-10-28 09:26
01.97 kB
AccountDao.java1.17 kB2014-10-28 09:26
AdminDao.java1.81 kB2014-10-28 09:26
CostDao.java1.05 kB2014-10-28 09:26
RoleDao.java1.34 kB2014-10-28 09:26
ServiceDao.java1.47 kB2014-10-28 09:26
01.97 kB
Account.java4.26 kB2014-10-28 09:26
AccountMapper.xml3.96 kB2014-10-28 09:26
Admin.java2.07 kB2014-10-28 09:26
AdminMapper.xml5.70 kB2014-10-28 09:26
Cost.java2.09 kB2014-10-28 09:26
CostMapper.xml2.40 kB2014-10-28 09:26
Module.java579.00 B2014-10-28 09:26
Role.java990.00 B2014-10-28 09:26
RoleMapper.xml2.67 kB2014-10-28 09:26
Service.java2.11 kB2014-10-28 09:26
ServiceMapper.xml4.11 kB2014-10-28 09:26
01.97 kB
AccountPage.java946.00 B2014-10-28 09:26
AdminPage.java670.00 B2014-10-28 09:26
CostPage.java132.00 B2014-10-28 09:26
Page.java1.52 kB2014-10-28 09:26
RolePage.java73.00 B2014-10-28 09:26
ServicePage.java887.00 B2014-10-28 09:26
01.97 kB
CheckLoginInterceptor.java1.50 kB2014-10-28 09:26
CheckModuleInterceptor.java1.63 kB2014-10-28 09:26
CurrentModuleInterceptor.java1.76 kB2014-10-28 09:26
01.97 kB
MyTest.java165.00 B2014-10-28 09:26
TestAdminDao.java672.00 B2014-10-28 09:26
TestCostDao.java2.21 kB2014-10-28 09:26
TestRole.java928.00 B2014-10-28 09:26
TestServiceDao.java706.00 B2014-10-28 09:26
01.97 kB
DateEditor.java1.00 kB2014-10-28 09:26
ImageUtil.java2.28 kB2014-10-28 09:26
log4j.properties618.00 B2014-10-28 09:26
netctoss.sql11.32 kB2014-10-28 09:26
...

AdminMapper.xml (12.90 MB)

Need 0 point
Your Point(s)
Download Download

Download failed? Click here to download one by one.

Tip: this source code project contains 2 packages, please click the allow button on the browser pop-up dialog,after you click the download button.

▪ Click to download this source code directly

LOGIN

Don't have an account? Register now
Need any help?
Mail to: support@codeforge.com

切换到中文版?

CodeForge Chinese Version
CodeForge English Version

Where are you going?

^_^"Oops ...

Sorry!This guy is mysterious, its blog hasn't been opened, try another, please!
OK

Warm tip!

CodeForge to FavoriteFavorite by Ctrl+D