Course_Select.zip_java_选课系统

package com.course.dao; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.util.ArrayList; import java.util.List; import com.course.bean.CourseTable; public class CourseTableDao { public List<CourseTable> showCourseTableList(String id) throws Exception{ List<CourseTable> courseTableList=new ArrayList<CourseTable>(); Connection conn=null; PreparedStatement pstm=null; ResultSet rs=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/course_system","root","root"); String sql="select id, cid, cname, time, teacher from course_table where id=001 "; pstm = conn.prepareStatement(sql); rs=pstm.executeQuery(); while(rs.next()){ CourseTable courseTable =new CourseTable(); courseTable.setId(rs.getString("id")); courseTable.setCid(rs.getString("cid")); courseTable.setCname(rs.getString("cname")); courseTable.setTime(rs.getString("time")); courseTable.setTeacher(rs.getString("teacher")); courseTableList.add(courseTable); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return courseTableList; } public List<CourseTable> queryCourseList(String keyword ,String id) { List<CourseTable> courseTableList=new ArrayList<CourseTable>(); Connection conn=null; PreparedStatement pstm=null; ResultSet rs=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/course_system","root","root"); String sql; if(keyword==null) { // 没有任何查询条件 sql = "select cid, cname, time, teacher from course_table where id="+id+" " ; } else { // 有查询条件 sql = "select cid,cname,time,teacher from course_table where id="+id + " and cid like ? or id="+id + " and cname like ? or id="+id + " and time like ? or id="+id + " and teacher like ?" ; } pstm=conn.prepareStatement(sql); if(keyword!=null){ pstm.setString(1,"%"+keyword+"%") ;// 存在查询条件 pstm.setString(2,"%"+keyword+"%") ; pstm.setString(3,"%"+keyword+"%") ; pstm.setString(4,"%"+keyword+"%") ; } rs=pstm.executeQuery(); while(rs.next()){ CourseTable courseTable =new CourseTable(); courseTable.setId(rs.getString("id")); courseTable.setCid(rs.getString("cid")); courseTable.setCname(rs.getString("cname")); courseTable.setTime(rs.getString("time")); courseTable.setTeacher(rs.getString("teacher")); courseTableList.add(courseTable); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return courseTableList; } } /* public List<CourseTable> addCourseTable(String id, String cid, String cname, String time, String teacher) throws Exception{ List<CourseTable> courseTableList=new ArrayList<CourseTable>(); Connection conn=null; PreparedStatement pstm=null; ResultSet rs=null; try { Class.forName("com.mysql.jdbc.Driver"); conn=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/course_system","root","root"); String sql="insert id, cid, cname, time, teacher into courseTable"; pstm = conn.prepareStatement(sql); rs=pstm.executeQuery(); while(rs.next()){ CourseTable courseTable =new CourseTable(id, cid, cname, time, teacher); courseTable.setId(rs.getString("id")); courseTable.setCid(rs.getString("cid")); courseTable.setCname(rs.getString("cname")); courseTable.setTime(rs.getString("time")); courseTable.setTeacher(rs.getString("teacher")); courseTableList.add(courseTable); } } catch (ClassNotFoundException e) { e.printStackTrace(); } catch (SQLException e) { e.printStackTrace(); } return courseTableList;*/