学生信息管理系统设计
suser.setSname(request.getParameter(\).trim()); suser.setSex(request.getParameter(\).trim()); suser.setSid(request.getParameter(\).trim());
suser.setAddress(request.getParameter(\).trim()); suser.setTel(request.getParameter(\).trim());
// suser.setPhoto(request.getParameter(\
suser.setScore(Integer.parseInt(request.getParameter(\).trim()));
suser.setGoodstu(request.getParameter(\).trim()); suser.setPrise(request.getParameter(\).trim()); suser.setXibu(request.getParameter(\).trim()); suser.setZhuanye(request.getParameter(\).trim()); if(new StuDll().updataStuInfo(suser)==0){
out.print(\language='javascript'>alert('修改成功！！返回查看
修改后信息
');window.location.href='/StudentManage/stuinfo.jsp?sno=\+suser.getSno()+\;\);
out.print(\language='javascript'>alert('修改失败！！重新}else{
修改该学生信息
');window.location.href='/StudentManage/updatastu.jsp?sno=\+suser.getSno()+\);
}
if(type2.trim().equals(\)){
request.setCharacterEncoding(\); LiuYan liuyan=new LiuYan();
liuyan.setLname(request.getParameter(\)); liuyan.setTel(request.getParameter(\)); liuyan.setEmail(request.getParameter(\)); liuyan.setTheme(request.getParameter(\)); liuyan.setMessage(request.getParameter(\)); if(new LiuYanDll().insertStu(liuyan)){
out.print(\留言成功，谢谢你}
的参与！！返回首页
');window.location.href='/StudentManage/index.jsp';\);
}else{
out.print(\！！留言失败！！
重新留言');window.location.href='/StudentManage/index.jsp';\);
}
- 17 -
学生信息管理系统设计
}
if(type2.trim().equals(\)){
FileUploadBean TheBean=new FileUploadBean(); TheBean.setSavePath(\);
System.out.print(\上传成功！！\);
response.sendRedirect(\);
TheBean.doUpload(request);
4.1.3 系统应用页面
4.1.4 系统留言板页面
- - 18
学生信息管理系统设计
package dao;
import java.sql.Connection; import java.sql.SQLException; import java.sql.Statement; import model.LiuYan; public class LiuYanDao {
private Connection conn = new Connecter().getConnenction(); Statement sta = null;
public boolean insertStu(LiuYan liuyan) {
if (liuyan.getLname() == null) return false; //必须填写的不能为空 if(liuyan.getEmail()==null){ liuyan.setEmail(\未填写\ if(liuyan.getTheme()==null)
liuyan.setTheme(\未填写\
if(liuyan.getMessage()==null) liuyan.setMessage(\未填写\
}
Statement sta = null;
String insertOrderSQL = \ \
+\e()+\
try {
- 19 -
学生信息管理系统设计
sta = conn.createStatement(); sta.execute(insertOrderSQL); }catch (SQLException e) { e.printStackTrace(); return false; }
return true; } }
- 20
-
