mysql+java',选课系统（MySQL+Java）

1 packagecom.epoint.Dao.Impl;2

3 importjava.sql.Connection;4 importjava.sql.PreparedStatement;5 importjava.sql.ResultSet;6

7 importjavax.swing.plaf.synth.SynthScrollBarUI;8

9 importcom.epoint.Dao.UserDao;10 import com.epoint.utils.*;11 importcom.epoint.model.Course;12 importcom.epoint.model.User;13

14 public class UserDaoImpl implementsUserDao{15

16 @Override17 publicUser login(User user) {18 //TODO Auto-generated method stub

19 Connection con = null;20 PreparedStatement ps= null;21 ResultSet rs=null;22 try{23 con=BaseDao.getCon();24 String sql="select * from user where username=? and password=?";25 ps=con.prepareStatement(sql);26 ps.setString(1, user.getUsername());27 ps.setString(2, user.getPassword());28 rs=ps.executeQuery();29 User users=null;30 if(rs.next()){31 users=newUser();32 //从数据库中获取值设置到实体类的setter方法中

33 users.setUsername(rs.getString("username"));34 users.setPassword(rs.getString("password"));35 returnusers;36 }else{37 return null;38 }39 }40 catch(Exception e) {41 //TODO Auto-generated catch block

42 e.printStackTrace();43 }44 return null;45 }46

47 @Override48 public voidchangePass(User user) {49 //TODO Auto-generated method stub

50 Connection con = null;51 PreparedStatement ps= null;52 ResultSet rs=null;53 try{54 con=BaseDao.getCon();55 String sql = "update user set password=? where username=?";56 ps=con.prepareStatement(sql);57 ps.setString(1, user.getPassword());58 ps.setString(2, user.getUsername());59 int a =ps.executeUpdate();60

61 } catch(Exception e) {62 //TODO Auto-generated catch block

63 e.printStackTrace();64 }65 }66

67 @Override68 public voidchooseCourse(String username,String c_id) {69 //TODO Auto-generated method stub

70 Connection con = null;71 PreparedStatement ps= null;72 ResultSet rs=null;73 try{74 con=BaseDao.getCon();75 String sql ="insert into user_course (username,c_id) values(?,?)";76 ps=con.prepareStatement(sql);77 ps.setString(1, username);78 ps.setString(2, c_id);79 int a =ps.executeUpdate();80 if(a>0){81 System.out.println("选课成功");82 }83 else{84 System.out.println("输入ID有误，选课失败");85 }86 } catch(Exception e) {87 //TODO Auto-generated catch block

88 e.printStackTrace();89 }90 }91 //删除选课

92 @Override93 public voiddeleteCourse(String username,String c_id) {94 //TODO Auto-generated method stub

95

96 Connection con = null;97 PreparedStatement ps= null;98 ResultSet rs=null;99 try{100 con=BaseDao.getCon();101 String sql="delete from user_course where username=? and c_id=? ";102 ps=con.prepareStatement(sql);103 ps.setString(1, username);104 ps.setString(2, c_id);105 int a =ps.executeUpdate();106 if(a>0){107 System.out.println("删除成功");108 }109 else{110 System.out.println("输入ID有误，删除失败");111 }112

113 } catch(Exception e) {114 //TODO Auto-generated catch block

115 e.printStackTrace();116 }117 }118 //查询已选课程

119 @Override120 public voidgetStuCourse(String username) {121 //TODO Auto-generated method stub

122 Connection con = null;123 PreparedStatement ps= null;124 ResultSet rs=null;125 try{126 con=BaseDao.getCon();127

128 String sql ="select * from course where c_id in (select c_id from user_course where username=?)";129 ps=con.prepareStatement(sql);130 ps.setString(1, username);131 rs=ps.executeQuery();132 while(rs.next()) {133 //System.out.println(6);

134 Course course = newCourse();135 course.setC_id(rs.getString("c_id"));136 course.setC_name(rs.getString("c_name"));137 course.setTeacher(rs.getString("teacher"));138

139 System.out.println(course.getC_id()+" "+course.getC_name()+" "+course.getTeacher());140 }141 } catch(Exception e) {142 //TODO Auto-generated catch block

143 e.printStackTrace();144 }145

146

147 }148 //查询可选课程

149 @Override150 public voidgetAvaCourse(String username) {151 //TODO Auto-generated method stub

152 Connection con = null;153 PreparedStatement ps= null;154 ResultSet rs=null;155 try{156 con=BaseDao.getCon();157 String sql = "select * from course where c_id not in (select c_id from user_course where username=?)";158 ps=con.prepareStatement(sql);159 ps.setString(1, username);160 rs=ps.executeQuery();161 while(rs.next()) {162 Course course = newCourse();163 course.setC_id(rs.getString("c_id"));164 course.setC_name(rs.getString("c_name"));165 course.setTeacher(rs.getString("teacher"));166

167 System.out.println(course.getC_id()+" "+course.getC_name()+" "+course.getTeacher());168 }169 } catch(Exception e) {170 //TODO Auto-generated catch block

171 e.printStackTrace();172 }173 }174

175 }