控制台简单实现mysql数据库学生管理系统

}

public void setName(String name) {

this.name = name;

}

public int getAge() {

return age;

}

public void setAge(int age) {

this.age = age;

}

public int getId() {

return id;

}

public void setId(int id) {

this.id = id;

}

@Override

public String toString() {

return “Student [name=” + name + “, age=” + age + “, id=” + id + “, score=” + score + “]”;

}

@Override

public int hashCode() {

// TODO Auto-generated method stub

return this.getId();

}

@Override

public boolean equals(Object obj) {

return super.equals(obj);

}

@Override

public int compareTo(Student o) {

// TODO Auto-generated method stub

return getId()-o.getId();

}

}

数据库操作封装类（连接，增删改查）

package com.lipengfei.mysqltest;

import java.io.UnsupportedEncodingException;

import java.sql.Connection;

import java.util.Date;

import com.mysql.jdbc.Statement;

import studentmanager.Student;

import java.sql.DriverManager;

import java.sql.PreparedStatement;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.text.SimpleDateFormat;

import java.util.Calendar;

public class JDBCMySQL {

public static final String DBDRIVER=“org.gjt.mm.mysql.Driver”;

public static final String DBURL=“jdbc:mysql://localhost:3306/student”;

public static final String DBUSER=“root”;

public static final String DBPASS=“admin”;

public static Conn