java 连接mysql编码设置_Java连接MySQL中文乱码处理

/************************************************************

* Add resident

*************************************************************/publicbooleanaddResident(String userID,String realName,String gender,

String birth,String addr,String tel,String email,String checkin) {

Connection conn=this.getConnection();

CallableStatement stmt=null;

Date birthDate=null;

Date checkinDate=null;if(birth!=null&& (!birth.equals(""))) {

birthDate=Date.valueOf(birth);

}if(checkin!=null&& (!checkin.equals(""))) {

checkinDate=Date.valueOf(checkin);

}try{

stmt=conn.prepareCall("{call ICommunity.addResident(?,?,?,?,?,?,?,?,?)}");

stmt.setString(1, userID);

stmt.setString(2, realName);

stmt.setString(3, gender);

stmt.setDate(4, birthDate);

stmt.setString(5, addr);

stmt.setString(6, tel);

stmt.setString(7, email);

stmt.setDate(8, checkinDate);

stmt.registerOutParameter(9, Types.BOOLEAN);

stmt.execute();returnstmt.getBoolean(9);

}catch(SQLException e) {//TODO Auto-generated catch blocke.printStackTrace();returnfalse;

}finally{try{

conn.close();

stmt.close();

}catch(SQLException e) {//TODO Auto-generated catch blocke.printStackTrace();

}

}

}