// 更新一个老师数据(后台)
public boolean updateTh(Teacher teacher) {
Connection conn = null;
PreparedStatement st = null;
ResultSet rs = null;
String sql =
"update teacher set name=?,tel=?,bank=?,banknum=?,score=?,introduction=? where id=?";
try {
conn = JdbcUtil.getConnection();
st = conn.prepareStatement(sql);
st.setString(1, teacher.getName());
st.setString(2, teacher.getTel());
st.setString(3, teacher.getBank());
st.setString(4, teacher.getBanknum());
st.setInt(5, teacher.getScore());
st.setString(6, teacher.getIntroduction());
st.setInt(7, teacher.getId());
st.executeUpdate();
} catch (SQLException e) {
e.printStackTrace();
return false;
} finally {
JdbcUtil.release(conn, st, rs);
}
return true;
}
