update语句

最新推荐文章于 2021-01-30 12:35:28 发布

原创最新推荐文章于 2021-01-30 12:35:28 发布 · 181 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#QQ #SQL

错误日志专栏收录该内容

26 篇文章

订阅专栏




/**
	 * 编辑学员信息
     * 姓名 常用邮箱 email 性别sex 婚恋状态 marry 生日birthday 血型blood 家乡 居住地 QQ MSN
	 * 
	 * @param int
	 * @return Boolean
	 */

	public boolean updateSpacefieldByUid(String username,
			String email,
			int sex,
			int marry,
			String blood,
			String  birthcity    , 
			String  birthprovince     , 
			String  resideprovince    , 
			String  residecity    , 
			String  qq    , 
			String  msn   , 
			int  birthday     ,
			int  birthyear      ,
			int  birthmonth     ,
			int uid) {
		String sql = "update uchome_spacefield spacefield, uchome_member member set username='"
				+ username
				+ "',member.email='"
				+ email
				+ "',spacefield.email='"
				+ email
				+ "',sex='"
				+ sex
				+ "',marry='"
				+ marry
				+ "',blood='"
				+ blood
				+ "',birthday ='"
				+ birthday
				+ "',birthmonth='"
				+ birthmonth
				+ "',birthyear ='"
				+ birthyear
				+ "',birthcity='"
				+ birthcity
				+ "',birthprovince='"
				+ birthprovince
				+ "',resideprovince='"
				+ resideprovince
				+ "',residecity='"
				+  residecity
				+ "',qq='"
				+  qq 
				+ "',msn='"
				+  msn
				+ "'where member.uid="
				+ uid
				+ " and spacefield.uid="
				+ uid + "";

		getJdbcTemplate().execute(sql);

		return true;
	}