Java+javabean+JDBC學(xué)生管理系統(tǒng)一、 項(xiàng)目結(jié)構(gòu)本項(xiàng)目是使用javabean和jdbc做的，這個(gè)包是實(shí)體包這個(gè)是菜單包，源碼不會(huì)再發(fā)這些，自己寫就好了。二、 項(xiàng)目運(yùn)行結(jié)果三、 源碼廢話不多說，直接上源碼：這兩個(gè)是關(guān)鍵源碼，是負(fù)責(zé)登錄和學(xué)生信息操作的邏輯類：public class AdminDaoImpl extends DBHelper implements AdminDao Admin admin = null;/* * 登錄 */SuppressWarnings("resource")Overridepublic Admin login(String name) String sql = "select * from admin where username=?"Object param = name;Object obj = this.excute(sql, param);ResultSet rs = (ResultSet) obj;try while (rs.next() admin = new Admin();String username = rs.getString("username");String password = rs.getString("password");admin.setUsername(username);admin.setPassword(password); catch (SQLException e) System.out.println("未找到此name");return admin;public class StudentDaoImpl extends DBHelper implements StudentDao Student stu = null;List<Student> list = null;SuppressWarnings("resource")Overridepublic Student getInfoByid(int id) String sql = "select * from student where id=?"Object param = id ;Object obj = this.excute(sql, param);ResultSet rs = (ResultSet) obj;stu = new Student();try while (rs.next() stu.setId(rs.getInt("id");stu.setName(rs.getString("name");stu.setAge(rs.getInt("age");stu.setGender(rs.getString("gender");stu.setGrade(rs.getString("grade");stu.setPhone(rs.getLong("phone");stu.setEmail(rs.getString("email");stu.setAddress(rs.getString("address"); catch (SQLException e) e.printStackTrace(); finally this.closeAll();return stu;SuppressWarnings("resource")Overridepublic List<Student> getAllStu() String sql = "select * from student"Object obj = this.excute(sql, null);ResultSet rs = (ResultSet) obj;list = new ArrayList<Student>();try while (rs.next() stu = new Student();stu.setId(rs.getInt("id");stu.setName(rs.getString("name");stu.setAge(rs.getInt("age");stu.setGender(rs.getString("gender");stu.setGrade(rs.getString("grade");stu.setPhone(rs.getLong("phone");stu.setEmail(rs.getString("email");stu.setAddress(rs.getString("address");list.add(stu); catch (SQLException e) e.printStackTrace(); finally this.closeAll();return list;SuppressWarnings("resource")Overridepublic String getNameById(int id) String name = null;String sql = "select name from student where id=?"Object param = id ;Object obj = this.excute(sql, param);ResultSet rs = (ResultSet) obj;try while (rs.next() name = rs.getString("name"); catch (SQLException e) e.printStackTrace(); finally this.closeAll();return name;SuppressWarnings("resource")Overridepublic int getidByIntput(int id) int num = 0;String sql = "select id from student where id=?"Object param = id ;Object obj = this.excute(sql, param);ResultSet rs = (ResultSet) obj;try while (rs.next() num = rs.getInt("id"); catch (SQLException e) e.printStackTrace(); finally this.closeAll();return num;Overridepublic boolean addStudent(Object param) boolean b = false;String sql = "insert into student values(?,?,?,?,?,?,?,?)"Object obj = this.excute(sql, param);b = (boolean) obj;return b;Overridepublic boolean removeStuById(int id) boolean b = false;String sql = "delete from student where id=?"Object param = id ;Object obj = this.excute(sql, param);b = (boolean) obj;return b;Overridepublic boolean modifyAllStuById(Student stu) boolean b = false;String sql = "update student set age = ?,grade=?,address=?,phone=?,email=? where id = ?"Object param = stu.getAge(), stu.getGrade(), stu.getAddress(),stu.getPhone(), stu.getEmail(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj;return b;Overridepublic boolean modifyPartStuById(Student stu, String attr) boolean b = false;if (attr.equals("age") String sql = "update student set age =? where id=?"Object param = stu.getAge(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj; else if (attr.equals("grade") String sql = "update student set grade =? where id=?"Object param = stu.getGrade(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj; else if (attr.equals("address") String sql = "update student set address =? where id=?"Object param = stu.getAddress(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj; else if (attr.equals("phone") String sql = "update student set phone =? where id=?"Object param = stu.getPhone(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj; else if (attr.equals("email") String sql = "update student set email =? where id=?"Object param = stu.getEmail(), stu.getId() ;Object obj = this.excute(sql, param);b = (boolean) obj;return b;好吧，到此為止，邏輯算是完成了，接下來就是工具包，也就是JDBC通式public class DBHelper private static final String url = "jdbc:mysql:/localhost:3306/sms?characterEncoding=utf-8"private static final String Driver = "com.mysql.jdbc.Driver"private static final String name = "root"private static final String pwd = "sa123456"private Connection conn = null;private PreparedStatement pstmt = null;private ResultSet rs = null;/* * 創(chuàng)建數(shù)據(jù)庫連接 * * return */public Connection Getconn() try Class.forName(Driver);conn = DriverManager.getConnection(url, name, pwd); catch (ClassNotFoundException e) System.out.println("注冊(cè)驅(qū)動(dòng)失敗"); catch (SQLException e) System.out.println("驅(qū)動(dòng)包路徑錯(cuò)誤");return conn;public Object excute(String sql, Object param) int a = 0;Object o = null;this.Getconn();try pstmt = conn.prepareStatement(sql);if (param != null) for (int i = 0; i < param.length; i+) pstmt.setObject(i + 1, parami);boolean b = pstmt.execute();if (b) rs = pstmt.getResultSet();o = rs; else a = pstmt.getUpdateCount();if (a > 0) o = true; else o = false;closeAll(); catch (SQLException e) e.printStackTrace();return o;/* * 關(guān)閉數(shù)據(jù)庫 */public void closeAll() try if (rs != null) rs.close();if (pstmt != null) pstmt.close();if (conn != null) conn.close(); catch (SQLException e) System.out.println("錯(cuò)誤關(guān)閉");至于這個(gè)類，是一些控制臺(tái)輸入信息判斷，當(dāng)然可以貼出來供大家參考/* * 匹配信息 * * author Administrator * */public class Matches Scanner input = new Scanner(System.in);static String id = null;static String gender = null;static String age = null;static String grade = null;static String phone = null;static String email = null;/* * 匹配id * * return */public String matchesId() id = input.next();if (Pattern.matches("0-91,$", id) else System.out.println("輸入錯(cuò)誤，只能輸入數(shù)字：");this.matchesId();return id;/* * 匹配性別 * * return */public String matchesGender() gender = input.next();if (!(gender.equals("男") | gender.equals("女") System.out.println("性別只能是男或者女:");this.matchesGender();return gender;/* * 匹配年齡 * * return */public int matchesAge() age = input.next();if (!Pattern.matches("0-91,$", age) System.out.println("以上輸入不合法，只能輸入1-120之內(nèi)的數(shù)字：");this.matchesAge(); else if (Integer.valueOf(age) < 1 | Integer.valueOf(age) > 120) System.out.println("以上輸入不合法，只能輸入1-120之內(nèi)的數(shù)字：");this.matchesAge();return Integer.parseInt(age);/* * 匹配年級(jí) * * return */public String matchesGrade() grade = input.next();if (!(grade.equals("初級(jí)") | grade.equals("中級(jí)") | grade.equals("高級(jí)") System.out.println("無此年級(jí)設(shè)置，年級(jí)只能輸入初級(jí)、中級(jí)或高級(jí)，請(qǐng)重新輸入:");this.matchesGrade();return grade;/* * 匹配手機(jī)號(hào) * * return */public long matchesPhone() phone = input.next();if (!Pattern.matches("0-911$", phone) System.out.println("輸入有誤，電話號(hào)碼只能是11位數(shù)字,請(qǐng)重新輸入：");this.matchesPhone();return Long.parseLong(phone);/* * 匹配email * * return */public String matchesEmail() email = input.next();if (!Pattern.matches("0-9a-zA-Z+0-9a-zA-Z+.0-9a-zA-Z+$", email) System.out.println("郵箱格式有誤，請(qǐng)輸入正確的電子郵箱（包含和.com）");this.matchesEmail();return email;好了，別的我就不說了，怎么調(diào)用，我更就不用說了吧？本文為原創(chuàng)作品，轉(zhuǎn)載需注明出處