The sub-code is as follows
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 {C On.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 Nativepl Ace, 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; }}
Detailed Description: http://java.662p.com/thread-3620-1-1.html
Java Student Management System project case