Java code/**
* 修改员工信息
* @param name
* @param age
* @param sex
* @param position
* @param salary
* @param birthday
* @throws Exception
*/
public void modifyInfo(String name,int age,String sex,String position,float salary,
java.sql.Date birthday)throws Exception{
Connection con=null;
PreparedStatement prepStmt=null;
//ResultSet rs=null;
employees=new ArrayList();
try{
con=getConnection();
String sql="update employees set name=?,age=?,sex=?,position=?,salary=?,birthday=? where name=?";
prepStmt=con.prepareStatement(sql);
prepStmt.setString(1, name);
prepStmt.setInt(2, age);
prepStmt.setString(3, sex);
prepStmt.setString(4, position);
prepStmt.setFloat(5, salary);
prepStmt.setDate(6, birthday);
prepStmt.setString(7, name);
prepStmt.executeUpdate();
prepStmt.close();
}catch(Exception e){
e.printStackTrace();
}
finally{
//closeResultSet(rs);
closeConnection(con);
}
}