mymodifybean.java

来自「采用j2ee架构做的bbs」· Java 代码 · 共 54 行

/*
 * 创建日期 2006-5-24
 *
 * TODO 要更改此生成的文件的模板，请转至
 * 窗口 － 首选项 － Java － 代码样式 － 代码模板
 */
package net.icefish.bean;
import java.sql.*;

import net.icefish.bean.Conn;
public class MymodifyBean {


private Connection conn;
	
	public MymodifyBean(){
		this.conn=Conn.connection();
	}
	
        
	public void xgBe(UserBean a){
		PreparedStatement pstmt=null;
	 	try{	
	//	pstmt=conn.prepareStatement("update icefish_user set user_secondname=?,user_birthday=? where user_id=?");		
		pstmt=conn.prepareStatement("update icefish_user set user_secondname=?,user_sex=?,user_birthday=?,user_QQ=?,user_group=?,user_face=?,user_sign=?,user_truename=?,user_Email=?,user_tel=?,user_blood=?,user_shengxiao=?,user_nation=?,user_province=?,user_city=? where user_id=?");

		pstmt.setString(1, a.getUser_Secondname());
		pstmt.setString(2, a.getUser_Sex());
		pstmt.setString(3, a.getUser_Birthday());
		pstmt.setString(4, a.getUser_QQ());
		pstmt.setString(5, a.getUser_Group());
		pstmt.setString(6, a.getUser_Face());
		pstmt.setString(7, a.getUser_Sign());
		pstmt.setString(8, a.getUser_Truename());
		pstmt.setString(9, a.getUser_Email());
		pstmt.setString(10, a.getUser_Tel());
		pstmt.setString(11, a.getUser_Blood());
		pstmt.setString(12, a.getUser_Shengxiao());
		pstmt.setString(13, a.getUser_Nation());
		pstmt.setString(14, a.getUser_Province());
		pstmt.setString(15, a.getUser_City());
        pstmt.setString(16, a.getUser_ID());
    	pstmt.executeUpdate();
  
	 	pstmt.close();
	 	conn.close();
	 	}
	 	catch(SQLException e){
	 	System.out.println(e);
	 	}	
	}
}