首页下载资源后端JavaWeb实验五 综合训练至尊版

ZIPJavaWeb实验五 综合训练至尊版

wv7573.57MB需要积分:1

资源文件列表:

实验五 综合训练【至尊版】.zip 大约有58个文件
  1. lab6/
  2. lab6/.classpath 1.09KB
  3. lab6/.project 904B
  4. lab6/.settings/
  5. lab6/.settings/.jsdtscope 567B
  6. lab6/.settings/org.eclipse.jdt.core.prefs 364B
  7. lab6/.settings/org.eclipse.wst.common.component 464B
  8. lab6/.settings/org.eclipse.wst.common.project.facet.core.xml 345B
  9. lab6/.settings/org.eclipse.wst.jsdt.ui.superType.container 49B
  10. lab6/.settings/org.eclipse.wst.jsdt.ui.superType.name 6B
  11. lab6/build/
  12. lab6/build/classes/
  13. lab6/build/classes/bean/
  14. lab6/build/classes/bean/Student.class 1.33KB
  15. lab6/build/classes/dao/
  16. lab6/build/classes/dao/Impl/
  17. lab6/build/classes/dao/Impl/StudentDaoImpl.class 4.8KB
  18. lab6/build/classes/dao/StudentDao.class 515B
  19. lab6/build/classes/service/
  20. lab6/build/classes/service/impl/
  21. lab6/build/classes/service/impl/StudentServiceImpl.class 1.68KB
  22. lab6/build/classes/service/StudentService.class 527B
  23. lab6/build/classes/servlet/
  24. lab6/build/classes/servlet/BaseServlet.class 1.89KB
  25. lab6/build/classes/servlet/StudentServlet.class 3.71KB
  26. lab6/build/classes/util/
  27. lab6/build/classes/util/DatabaseBean.class 1.54KB
  28. lab6/src/
  29. lab6/src/bean/
  30. lab6/src/bean/Student.java 833B
  31. lab6/src/dao/
  32. lab6/src/dao/Impl/
  33. lab6/src/dao/Impl/StudentDaoImpl.java 4.27KB
  34. lab6/src/dao/StudentDao.java 949B
  35. lab6/src/service/
  36. lab6/src/service/impl/
  37. lab6/src/service/impl/StudentServiceImpl.java 1.48KB
  38. lab6/src/service/StudentService.java 622B
  39. lab6/src/servlet/
  40. lab6/src/servlet/BaseServlet.java 1.02KB
  41. lab6/src/servlet/StudentServlet.java 3.65KB
  42. lab6/src/util/
  43. lab6/src/util/DatabaseBean.java 990B
  44. lab6/WebContent/
  45. lab6/WebContent/addStudent.jsp 1.19KB
  46. lab6/WebContent/index.jsp 322B
  47. lab6/WebContent/META-INF/
  48. lab6/WebContent/META-INF/MANIFEST.MF 39B
  49. lab6/WebContent/showStudent.jsp 2.06KB
  50. lab6/WebContent/showStudent2.jsp 2.13KB
  51. lab6/WebContent/update.jsp 1.59KB
  52. lab6/WebContent/WEB-INF/
  53. lab6/WebContent/WEB-INF/lib/
  54. lab6/WebContent/WEB-INF/lib/jstl-1.2.jar 404.53KB
  55. lab6/WebContent/WEB-INF/lib/mysql-connector-java-5.1.20-bin.jar 783.91KB
  56. lab6/WebContent/WEB-INF/lib/mysql-connector-java-8.0.19.jar 2.25MB
  57. lab6/WebContent/WEB-INF/lib/standard-1.1.2.jar 384.04KB
  58. lab6/WebContent/WEB-INF/web.xml 650B

资源介绍:

【没错,这个就是你要找的学习通的实验!】 实验五 综合训练 一、实验目的 1.了解MVC思想。 2.熟悉Java Web的各种开发技术。 二、实验学时 4H 三、实验性质 综合性实验 四、实验内容 1.创建表t_student,其中包含学号stuno,姓名stuname,性别stusex三个字段,在表中插入一些测试数据。(5分) 2.实现下述功能:
package dao.Impl; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import bean.Student; import dao.StudentDao; import util.DatabaseBean; public class StudentDaoImpl implements StudentDao { Connection conn = null; PreparedStatement pstmt = null; ResultSet rs = null; @Override public List findAll() { List students = new ArrayList(); try { conn = DatabaseBean.getConnection(); String sql = "select stuno,stuname,stusex from t_student"; pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()) { Student stu = new Student(); stu.setStuno(rs.getString("stuno")); stu.setStuname(rs.getString("stuname")); stu.setStusex(rs.getString("stusex")); students.add(stu); } } catch (Exception e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return students; } @Override public List selectStudentByStuname(String stuname) { // 上转型对象 List students = new ArrayList(); try { conn = DatabaseBean.getConnection(); String sql = "select stuno,stuname,stusex from t_student where stuname like ?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, "%" + stuname + "%"); rs = pstmt.executeQuery(); while (rs.next()) { Student stu = new Student(); stu.setStuno(rs.getString("stuno")); stu.setStuname(rs.getString("stuname")); stu.setStusex(rs.getString("stusex")); students.add(stu); } } catch (Exception e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return students; } @Override // 精确查找 public Student selectStudentByStuno(String stuno) { Student stu = new Student(); try { conn = DatabaseBean.getConnection(); // String sql = "SELECT * FROM students WHERE stuno = ?"; // 就是因为这条语句是从实验二粘贴过来的,所以导致了后面的错误,终于找出错误了! String sql = "SELECT * FROM t_student WHERE stuno = ?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, stuno); rs = pstmt.executeQuery(); while (rs.next()) { stu.setStuno(rs.getString("stuno")); stu.setStuname(rs.getString("stuname")); stu.setStusex(rs.getString("stusex")); } } catch (SQLException e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return stu; } @Override public boolean deleteStudent(String stuno) { try { conn = DatabaseBean.getConnection(); String sql = "delete from t_student where stuno=?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, stuno); int result = pstmt.executeUpdate(); // pstmt.close(); // conn.close(); if (result > 0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return false; } @Override // 修改学生信息 public boolean saveStudent(Student stu) { try { conn = DatabaseBean.getConnection(); String sql = "update t_student set stuname=?,stusex=? where stuno=?"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, stu.getStuname()); pstmt.setString(2, stu.getStusex()); pstmt.setString(3, stu.getStuno()); int result = pstmt.executeUpdate(); // pstmt.close(); // conn.close(); if (result > 0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return false; } @Override // 添加学生信息 public boolean addStudent(Student stu) { try { conn = DatabaseBean.getConnection(); String sql = "insert into t_student(stuno,stuname,stusex) values(?,?,?)"; pstmt = conn.prepareStatement(sql); pstmt.setString(1, stu.getStuno()); pstmt.setString(2, stu.getStuname()); pstmt.setString(3, stu.getStusex()); int result = pstmt.executeUpdate(); if (result > 0) { return true; } } catch (Exception e) { e.printStackTrace(); } finally { DatabaseBean.close(rs, pstmt, conn); } return false; } }
100+评论
captcha