javaweb网上选课mysql_JavaWeb项目-选课系统

最新推荐文章于 2022-05-18 15:21:11 发布

Luyao Zou

最新推荐文章于 2022-05-18 15:21:11 发布

阅读量133

点赞数

文章标签： javaweb网上选课mysql

本文链接：https://blog.csdn.net/weixin_31487521/article/details/114233190

版权

1 packagetest1;2 import java.sql.*;3 importjava.util.regex.Pattern;4

5 public classData {6 //common

7 privateString userid;8 privateString password;9 privateString name;10 privateString sex;11 //teacher

12 privateString school;13 privateString rank;14 //student

15 privateString classe;16 privateString object;17 //ideas

18 publicString getUserid() {19 returnuserid;20 }21 public voidsetUserid(String userid) {22 this.userid =userid;23 }24 publicString getPassword() {25 returnpassword;26 }27 public voidsetPassword(String password) {28 this.password =password;29 }30 publicString getName() {31 returnname;32 }33 public voidsetName(String name) {34 this.name =name;35 }36 publicString getSex() {37 returnsex;38 }39 public voidsetSex(String sex) {40 this.sex =sex;41 }42 publicString getSchool() {43 returnschool;44 }45 public voidsetSchool(String school) {46 this.school =school;47 }48 publicString getRank() {49 returnrank;50 }51 public voidsetRank(String rank) {52 this.rank =rank;53 }54 publicString getClasse() {55 returnclasse;56 }57 public voidsetClasse(String classe) {58 this.classe =classe;59 }60 publicString getObject() {61 returnobject;62 }63 public voidsetObject(String object) {64 this.object =object;65 }66 //class data;

67 privateString classid;68 privateString classname;69 privateString classpup;70 privateString classpupnow;71 privateString classteacher;72 //ideas

73 publicString getClassid() {74 returnclassid;75 }76 public voidsetClassid(String classid) {77 this.classid =classid;78 }79 publicString getClassname() {80 returnclassname;81 }82 public voidsetClassname(String classname) {83 this.classname =classname;84 }85 publicString getClasspup() {86 returnclasspup;87 }88 public voidsetClasspup(String classpup) {89 this.classpup =classpup;90 }91 publicString getClasspupnow() {92 returnclasspupnow;93 }94 public voidsetClasspupnow(String classpupnow) {95 this.classpupnow =classpupnow;96 }97 publicString getClassteacher() {98 returnclassteacher;99 }100 public voidsetClassteacher(String classteacher) {101 this.classteacher =classteacher;102 }103 //连接数据库***********************************************************************

104 public Connection getConnection()//连接数据库

105 {106 try{107 Class.forName("com.mysql.cj.jdbc.Driver");108 //System.out.println("加载驱动成功");

109 }catch(ClassNotFoundException e)110 {111 e.printStackTrace();112 }113 String user="root";114 String password="123456";115 String url = "jdbc:mysql://localhost:3306/ztest01?useSSL=false&serverTimezone=GMT&characterEncoding=utf-8&autoReconnect=true";116 Connection con=null;117 try{118 con=DriverManager.getConnection(url,user,password);119 //System.out.println("数据库连接成功");

120 }catch(SQLException e)121 {122 e.printStackTrace();123 }124 returncon;125 }126 //关闭方法**********************************************************************

127 public voidclose (Connection con)128 {129 try{130 if(con!=null)131 {132 con.close();133 }134 }catch(SQLException e)135 {136 e.printStackTrace();137 }138 }139 public voidclose (PreparedStatement preparedStatement)140 {141 try{142 if(preparedStatement!=null)143 {144 preparedStatement.close();145 }146 }catch(SQLException e)147 {148 e.printStackTrace();149 }150 }151 public voidclose(ResultSet resultSet)152 {153 try{154 if(resultSet!=null)155 {156 resultSet.close();157 }158 }catch(SQLException e)159 {160 e.printStackTrace();161 }162 }163 //数据库操作*******************************************************************

164 public void addstudent(String userid,String name,String sex,String classe,String object,String password)//add student

165 {166 Connection connection =getConnection();167 PreparedStatement preparedStatement=null;168 try{169 String sql = "insert into students (userid,name,sex,classe,object,password) values (?,?,?,?,?,?)";170 preparedStatement=connection.prepareStatement(sql);171 preparedStatement.setString(1,userid);172 preparedStatement.setString(2,name);173 preparedStatement.setString(3,sex);174 preparedStatement.setString(4,classe);175 preparedStatement.setString(5,object);176 preparedStatement.setString(6,password);177 preparedStatement.executeUpdate();178

179 } catch(SQLException e) {180 e.printStackTrace();181 }finally{182 close(preparedStatement);183 close(connection);184 }185 }186 public void addteacher(String userid,String name,String sex,String school,String ranks,String password)//add teacher

187 {188 Connection connection =getConnection();189 PreparedStatement preparedStatement=null;190 try{191 String sql = "insert into teachers (userid,name,sex,school,ranks,password) values (?,?,?,?,?,?)";192 preparedStatement=connection.prepareStatement(sql);193 preparedStatement.setString(1,userid);194 preparedStatement.setString(2,name);195 preparedStatement.setString(3,sex);196 preparedStatement.setString(4,school);197 preparedStatement.setString(5,ranks);198 preparedStatement.setString(6,password);199 preparedStatement.executeUpdate();200

201 } catch(SQLException e) {202 e.printStackTrace();203 }finally{204 close(preparedStatement);205 close(connection);206 }207 }208

209 public void reviseteacher(String userid,String name,String sex,String school,String ranks)//revise teacher

210 {211 Connection connection =getConnection();212 PreparedStatement preparedStatement=null;213 try{214 String sql = "update teachers set name=?, sex=?, school=?, ranks=? where userid=?";215 preparedStatement=connection.prepareStatement(sql);216 preparedStatement.setString(1,name);217 preparedStatement.setString(2,sex);218 preparedStatement.setString(3,school);219 preparedStatement.setString(4,ranks);220 preparedStatement.setString(5,userid);221 preparedStatement.executeUpdate();222 } catch(SQLException e) {223 e.printStackTrace();224 }finally{225 close(preparedStatement);226 close(connection);227 }228 }229 public void revisestudent(String userid,String name,String sex,String classe,String object)//revise student

230 {231 Connection connection =getConnection();232 PreparedStatement preparedStatement=null;233 try{234 String sql = "update students set name=?, sex=?, classe=?, object=? where userid=?";235 preparedStatement=connection.prepareStatement(sql);236 preparedStatement.setString(1,name);237 preparedStatement.setString(2,sex);238 preparedStatement.setString(3,classe);239 preparedStatement.setString(4,object);240 preparedStatement.setString(5,userid);241 preparedStatement.executeUpdate();242 } catch(SQLException e) {243 e.printStackTrace();244 }finally{245 close(preparedStatement);246 close(connection);247 }248 }249

250 public void addclass(String classid,String classname,String classpup,String classpupnow,String classteacher,String teacherid) //add class

251 {252 Connection connection =getConnection();253 PreparedStatement preparedStatement=null;254 try{255 String sql = "insert into classes (classid,classname,classpup,classpupnow,classteacher,teacherid) values (?,?,?,?,?,?)";256 preparedStatement=connection.prepareStatement(sql);257 preparedStatement.setString(1,classid);258 preparedStatement.setString(2,classname);259 preparedStatement.setString(3,classpup);260 preparedStatement.setString(4,classpupnow);261 preparedStatement.setString(5,classteacher);262 preparedStatement.setString(6,teacherid);263 preparedStatement.executeUpdate();264

265 } catch(SQLException e) {266 e.printStackTrace();267 }finally{268 close(preparedStatement);269 close(connection);270 }271 }272 public void addBeChosenClass(String studentid,String classid,String classpupnow,String teacherid) { //classpupnow++

273 Connection connection =getConnection();274 PreparedStatement preparedStatement1=null;275 PreparedStatement preparedStatement2=null;276 try{277 String sql1 = "insert into beChosenClasses (studentid,classid,teacherid) values (?,?,?)";278 preparedStatement1=connection.prepareStatement(sql1);279 preparedStatement1.setString(1,studentid);280 preparedStatement1.setString(2,classid);281 preparedStatement1.setString(3,teacherid);282 String sql2 = "update classes set classpupnow=? where classid=?";283 preparedStatement2=connection.prepareStatement(sql2);284 preparedStatement2.setString(1,classpupnow);285 preparedStatement2.setString(2,classid);286

287 preparedStatement1.executeUpdate();288 preparedStatement2.executeUpdate();289 } catch(SQLException e) {290 e.printStackTrace();291 }finally{292 close(preparedStatement1);293 close(preparedStatement2);294 close(connection);295 }296 }297 public void changepasswordStudent(String userid,String password) { //change password student

298 Connection connection =getConnection();299 PreparedStatement preparedStatement=null;300 try{301 String sql = "update students set password=? where userid=?";302 preparedStatement=connection.prepareStatement(sql);303 preparedStatement.setString(1,password);304 preparedStatement.setString(2,userid);305 preparedStatement.executeUpdate();306 } catch(SQLException e) {307 e.printStackTrace();308 }finally{309 close(preparedStatement);310 close(connection);311 }312 }313

314 public void changepasswordTeacher(String userid,String password) { //change password teacher

315 Connection connection =getConnection();316 PreparedStatement preparedStatement=null;317 try{318 String sql = "update teachers set password=? where userid=?";319 preparedStatement=connection.prepareStatement(sql);320 preparedStatement.setString(1,password);321 preparedStatement.setString(2,userid);322 preparedStatement.executeUpdate();323 } catch(SQLException e) {324 e.printStackTrace();325 }finally{326 close(preparedStatement);327 close(connection);328 }329 }330

331 //判断*********************************************************************************

332 public boolean isNumber(String str) {//judge int

333 Pattern pattern = Pattern.compile("^[-\\+]?[\\d]*$");334 returnpattern.matcher(str).matches();335 }336

337 public boolean teacherexist(String userid) { //have this teacher

338 Connection connection =getConnection();339 PreparedStatement preparedStatement=null;340 ResultSet rs=null;341 try{342 String sql = "select userid from teachers";343 preparedStatement=connection.prepareStatement(sql);344 rs=preparedStatement.executeQuery();345 while(rs.next()){346 if( userid.equals(rs.getObject(1)) )347 return true;348 }349 } catch(SQLException e) {350 e.printStackTrace();351 }finally{352 close(rs);353 close(preparedStatement);354 close(connection);355 }356 return false;357 }358 public boolean studentexist(String userid) { //have this student

359 Connection connection =getConnection();360 PreparedStatement preparedStatement=null;361 ResultSet rs=null;362 try{363 String sql = "select userid from students";364 preparedStatement=connection.prepareStatement(sql);365 rs=preparedStatement.executeQuery();366 while(rs.next()){367 if( userid.equals(rs.getObject(1)) )368 return true;369 }370 } catch(SQLException e) {371 e.printStackTrace();372 }finally{373 close(rs);374 close(preparedStatement);375 close(connection);376 }377 return false;378 }379 public boolean useridisIdRight(String num) {//judge userid

380 int k=0;381 if(num.length()==8) {382 for(int i=0;i<8;i++) {383 char c=num.charAt(i);384 if(c=='0'||c=='1'||c=='2'||c=='3'||c=='4'||c=='5'||c=='6'||c=='7'||c=='8'||c=='9')385 k++;386 }387 if(k==8)388 return true;389 else return false;390 }391 else return false;392 }393 public boolean classidisIdRight(String num) {//judge classid

394 int k=0;395 if(num.length()==6) {396 for(int i=0;i<6;i++) {397 char c=num.charAt(i);398 if(c=='0'||c=='1'||c=='2'||c=='3'||c=='4'||c=='5'||c=='6'||c=='7'||c=='8'||c=='9')399 k++;400 }401 if(k==6)402 return true;403 else return false;404 }405 else return false;406 }407

408 public boolean passwordIsRightStudents(String userid,String password) { //judge password is right-Students

409 Connection connection =getConnection();410 PreparedStatement preparedStatement=null;411 ResultSet rs=null;412 try{413 String sql = "select * from students";414 preparedStatement=connection.prepareStatement(sql);415 rs=preparedStatement.executeQuery();416 while(rs.next()){417 if( userid.equals(rs.getObject(1))&&password.equals(rs.getObject(6)) )418 return true;419 }420 } catch(SQLException e) {421 e.printStackTrace();422 }finally{423 close(rs);424 close(preparedStatement);425 close(connection);426 }427 return false;428 }429 public boolean passwordIsRightTeachers(String userid,String password) { //judge password is right-Teachers

430 Connection connection =getConnection();431 PreparedStatement preparedStatement=null;432 ResultSet rs=null;433 try{434 String sql = "select * from teachers";435 preparedStatement=connection.prepareStatement(sql);436 rs=preparedStatement.executeQuery();437 while(rs.next()){438 if( userid.equals(rs.getObject(1))&&password.equals(rs.getObject(6)) )439 return true;440 }441 } catch(SQLException e) {442 e.printStackTrace();443 }finally{444 close(rs);445 close(preparedStatement);446 close(connection);447 }448 return false;449 }450 public boolean passwordIsRightOp(String userid,String password) { //judge password is right-Op

451 Connection connection =getConnection();452 PreparedStatement preparedStatement=null;453 ResultSet rs=null;454 try{455 String sql = "select * from ops";456 preparedStatement=connection.prepareStatement(sql);457 rs=preparedStatement.executeQuery();458 while(rs.next()){459 if( userid.equals(rs.getObject(1))&&password.equals(rs.getObject(2)) )460 return true;461 }462 } catch(SQLException e) {463 e.printStackTrace();464 }finally{465 close(rs);466 close(preparedStatement);467 close(connection);468 }469 return false;470 }471 public boolean classIsExist(String classid) { //have this class

472 Connection connection =getConnection();473 PreparedStatement preparedStatement=null;474 ResultSet rs=null;475 try{476 String sql = "select classid from classes";477 preparedStatement=connection.prepareStatement(sql);478 rs=preparedStatement.executeQuery();479 while(rs.next()){480 if( classid.equals(rs.getObject(1)) )481 return true;482 }483 } catch(SQLException e) {484 e.printStackTrace();485 }finally{486 close(rs);487 close(preparedStatement);488 close(connection);489 }490 return false;491 }492 public boolean classSame(String studentid,String classid) { //student have chosen this class

493 Connection connection =getConnection();494 PreparedStatement preparedStatement=null;495 ResultSet rs=null;496 try{497 String sql = "select * from bechosenclasses";498 preparedStatement=connection.prepareStatement(sql);499 rs=preparedStatement.executeQuery();500 while(rs.next()){501 if( studentid.equals(rs.getObject(1))&&classid.equals(rs.getObject(2)) )502 return true;503 }504 } catch(SQLException e) {505 e.printStackTrace();506 }finally{507 close(rs);508 close(preparedStatement);509 close(connection);510 }511 return false;512 }513

514

515 //*********************************************************************************

516 public static voidmain(String[] args) {517

518 }519

520 }