Java学生管理系统项目案例

分代码如下

package com.student.util;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DbUtil {
        private String dbUrl="jdbc:mysql://localhost:3306/db_student";
        private String user="root";
        private String password="123456";
        private String jdbcName="com.mysql.jdbc.Driver";
        public Connection getCon() throws Exception{
                Class.forName(jdbcName);
                Connection con=DriverManager.getConnection(dbUrl, user, password);
                return con;
        }
        public void close(Connection con)throws Exception{
                if(con!=null){
                        con.close();
                }
        }
        public static void main(String[] args){
                Connection con=null;
                try {
                        con = new DbUtil().getCon();
                        System.out.println(con);
                } catch (Exception e) {
                        e.printStackTrace();
                }finally{
                        if(con!=null){
                                try {
                                        con.close();
                                } catch (SQLException e) {
                                        e.printStackTrace();
                                }
                        }
                }
        }
}

package com.student.model;

public class Student {
        private int id;
        private String studentnumber;
        private String name;
        private String birthday;
        private String nativeplace;
        private int classid;
        private String studentremark;

        public Student() {
                super();
        }

        public Student(String studentnumber, String name, String birthday,
                        String nativeplace, int classid, String studentremark) {
                super();
                this.studentnumber = studentnumber;
                this.name = name;
                this.birthday = birthday;
                this.nativeplace = nativeplace;
                this.classid = classid;
                this.studentremark = studentremark;
        }

        public Student(int id, String studentnumber, String name, String birthday,
                        String nativeplace, int classid, String studentremark) {
                super();
                this.id = id;
                this.studentnumber = studentnumber;
                this.name = name;
                this.birthday = birthday;
                this.nativeplace = nativeplace;
                this.classid = classid;
                this.studentremark = studentremark;
        }

        public int getId() {
                return id;
        }

        public void setId(int id) {
                this.id = id;
        }

        public String getStudentnumber() {
                return studentnumber;
        }

        public void setStudentnumber(String studentnumber) {
                this.studentnumber = studentnumber;
        }

        public String getName() {
                return name;
        }

        public void setName(String name) {
                this.name = name;
        }

        public String getBirthday() {
                return birthday;
        }

        public void setBirthday(String birthday) {
                this.birthday = birthday;
        }

        public String getNativeplace() {
                return nativeplace;
        }

        public void setNativeplace(String nativeplace) {
                this.nativeplace = nativeplace;
        }

        public int getClassid() {
                return classid;
        }

        public void setClassid(int classid) {
                this.classid = classid;
        }

        public String getStudentremark() {
                return studentremark;
        }

        public void setStudentremark(String studentremark) {
                this.studentremark = studentremark;
        }

}

效果图
 

 

详细说明： http://java.662p.com/thread-3620-1-1.html