//opr
//修改
public boolean update(Teacher teacher){
int flag = 0;
sql = "update Teacher set tname=?,password=?,tage=?,tcollege=?,tsex=? where tno=?";
try {
psmt = con.prepareStatement(sql);
psmt.setString(1, teacher.getTname());
psmt.setString(2, teacher.getPassword());
psmt.setString(3, teacher.getTcollege());
psmt.setString(4, teacher.getTsex());
psmt.setString(5, teacher.getTno());
psmt.setInt(6, teacher.getTage());
flag = psmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag>0?true:false;
}
//servlet
if(oprType.equals("update")){//图书修改
//1.接收表单参数
String tno = new String(request.getParameter("teno").getBytes("ISO-8859-1"),"utf-8");
String password = new String(request.getParameter("tepassword").getBytes("ISO-8859-1"),"utf-8");
String tname = new String(request.getParameter("tename").getBytes("ISO-8859-1"),"utf-8");
String tsex = new String(request.getParameter("tesex").getBytes("ISO-8859-1"),"utf-8");
String tage = new String(request.getParameter("teage").getBytes("ISO-8859-1"),"utf-8");
String tcollege = new String(request.getParameter("tecollege").getBytes("ISO-8859-1"),"utf-8");
//2.封装student对象
Teacher tea = new Teacher();
tea.setTno(tno);
tea.setPassword(password);
tea.setTname(tname);
tea.setTsex(tsex);
tea.setTage(Integer.parseInt(tage));
tea.setTcollege(tcollege);
//3.调用StudentOpr的添加方法
boolean flag = so.update(tea);
//4.根据结果显示页面
if(flag){
nextPage = "TeacherInfoServlet?type=list";
}else{
out.print("<h3>修改失败,请重试!</h3>");
}
//修改
public boolean update(Teacher teacher){
int flag = 0;
sql = "update Teacher set tname=?,password=?,tage=?,tcollege=?,tsex=? where tno=?";
try {
psmt = con.prepareStatement(sql);
psmt.setString(1, teacher.getTname());
psmt.setString(2, teacher.getPassword());
psmt.setString(3, teacher.getTcollege());
psmt.setString(4, teacher.getTsex());
psmt.setString(5, teacher.getTno());
psmt.setInt(6, teacher.getTage());
flag = psmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return flag>0?true:false;
}
//servlet
if(oprType.equals("update")){//图书修改
//1.接收表单参数
String tno = new String(request.getParameter("teno").getBytes("ISO-8859-1"),"utf-8");
String password = new String(request.getParameter("tepassword").getBytes("ISO-8859-1"),"utf-8");
String tname = new String(request.getParameter("tename").getBytes("ISO-8859-1"),"utf-8");
String tsex = new String(request.getParameter("tesex").getBytes("ISO-8859-1"),"utf-8");
String tage = new String(request.getParameter("teage").getBytes("ISO-8859-1"),"utf-8");
String tcollege = new String(request.getParameter("tecollege").getBytes("ISO-8859-1"),"utf-8");
//2.封装student对象
Teacher tea = new Teacher();
tea.setTno(tno);
tea.setPassword(password);
tea.setTname(tname);
tea.setTsex(tsex);
tea.setTage(Integer.parseInt(tage));
tea.setTcollege(tcollege);
//3.调用StudentOpr的添加方法
boolean flag = so.update(tea);
//4.根据结果显示页面
if(flag){
nextPage = "TeacherInfoServlet?type=list";
}else{
out.print("<h3>修改失败,请重试!</h3>");
}
我“软包学院”的这个数值定义的是nvarchar型我就是不知道哪里出错了
try {
psmt = con.prepareStatement(sql);
psmt.setString(1, teacher.getTname());
psmt.setString(2, teacher.getPassword());
psmt.setString(3, teacher.getTcollege());
psmt.setString(4, teacher.getTsex());
psmt.setString(5, teacher.getTno());
psmt.setInt(6, teacher.getTage());
flag = psmt.executeUpdate();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}红色部分,楼主看看是否合适,年龄给的值是大学名???
from 表
where isnumeric(字段) = 1