《java+JDBC小項目《學(xué)生管理系統(tǒng)》源碼帶注解》由會員分享，可在線閱讀，更多相關(guān)《java+JDBC小項目《學(xué)生管理系統(tǒng)》源碼帶注解（12頁珍藏版）》請在裝配圖網(wǎng)上搜索。
1、Java+javabean+JDBC學(xué)生管理系統(tǒng)
一、 項目結(jié)構(gòu)
本項目是使用javabean和jdbc做的，這個包是實體包
這個是菜單包，源碼不會再發(fā)這些，自己寫就好了。
二、 項目運行結(jié)果
三、 源碼
廢話不多說，直接上源碼：
這兩個是關(guān)鍵源碼，是負(fù)責(zé)登錄和學(xué)生信息操作的邏輯類：
public class AdminDaoImpl extends DBHelper implements AdminDao {
Admin admin = null;
/**
* 登錄
*/
@SuppressWarnings("resource"
2、)
@Override
public 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.getSt
3、ring("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 Stude
4、ntDao {
Student stu = null;
List list = null;
@SuppressWarnings("resource")
@Override
public Student getInfoByid(int id) {
String sql = "select * from student where id=?";
Object[] param = { id };
Object obj = this.excute(sql, param);
ResultSet rs = (ResultSet) obj
5、;
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"));
st
6、u.setEmail(rs.getString("email"));
stu.setAddress(rs.getString("address"));
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
this.closeAll();
}
return stu;
}
@SuppressWarnings("resource")
@Override
public List getAllStu() {
String sql =
7、 "select * from student";
Object obj = this.excute(sql, null);
ResultSet rs = (ResultSet) obj;
list = new ArrayList();
try {
while (rs.next()) {
stu = new Student();
stu.setId(rs.getInt("id"));
stu.setName(rs.getString("name"));
stu.setAge(rs.getInt("age"
8、));
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();
9、 } finally {
this.closeAll();
}
return list;
}
@SuppressWarnings("resource")
@Override
public String getNameById(int id) {
String name = null;
String sql = "select name from student where id=?";
Object[] param = { id };
Object obj = this.excute(sql, param);
Result
10、Set rs = (ResultSet) obj;
try {
while (rs.next()) {
name = rs.getString("name");
}
} catch (SQLException e) {
e.printStackTrace();
} finally {
this.closeAll();
}
return name;
}
@SuppressWarnings("resource")
@Override
public int getidByIntput(int id) {
11、 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();
} fi
12、nally {
this.closeAll();
}
return num;
}
@Override
public boolean addStudent(Object[] param) {
boolean b = false;
String sql = "insert into student values(?,?,?,?,?,?,?,?)";
Object obj = this.excute(sql, param);
b = (boolean) obj;
return b;
}
@Override
public
13、 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;
}
@Override
public boolean modifyAllStuById(Student stu) {
boolean b = false;
14、 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;
}
@Ov
15、erride
public 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;
}
16、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 =? w
17、here 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 =
18、 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;
}
}
好吧，到此
19、為止，邏輯算是完成了，接下來就是工具包，也就是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 = "sa
20、123456";
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 (Cl
21、assNotFoundException e) {
System.out.println("注冊驅(qū)動失敗");
} catch (SQLException e) {
System.out.println("驅(qū)動包路徑錯誤");
}
return conn;
}
public Object excute(String sql, Object[] param) {
int a = 0;
Object o = null;
this.Getconn();
try {
pstmt = conn.prepareStatement
22、(sql);
if (param != null) {
for (int i = 0; i < param.length; i++) {
pstmt.setObject(i + 1, param[i]);
}
}
boolean b = pstmt.execute();
if (b) {
rs = pstmt.getResultSet();
o = rs;
} else {
a = pstmt.getUpdateCount();
if (a > 0) {
o = true
23、;
} 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();
}
24、 if (conn != null) {
conn.close();
}
} catch (SQLException e) {
System.out.println("錯誤關(guān)閉");
}
}
}
至于這個類，是一些控制臺輸入信息判斷，當(dāng)然可以貼出來供大家參考~
/**
* 匹配信息
*
* @author Administrator
*
*/
public class Matches {
Scanner input = new Scanner(System.in);
static String id =
25、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-9]{1,}$", id)) {
26、} else {
System.out.println("輸入錯誤，只能輸入數(shù)字：");
this.matchesId();
}
return id;
}
/**
* 匹配性別
*
* @return
*/
public String matchesGender() {
gender = input.next();
if (!(gender.equals("男") || gender.equals("女"))) {
System.out.println("性別只能是男或者女:");
this.ma
27、tchesGender();
}
return gender;
}
/**
* 匹配年齡
*
* @return
*/
public int matchesAge() {
age = input.next();
if (!Pattern.matches("^[0-9]{1,}$", age)) {
System.out.println("以上輸入不合法，只能輸入1-120之內(nèi)的數(shù)字：");
this.matchesAge();
} else if (Integer.valueOf(age) < 1 || I
28、nteger.valueOf(age) > 120) {
System.out.println("以上輸入不合法，只能輸入1-120之內(nèi)的數(shù)字：");
this.matchesAge();
}
return Integer.parseInt(age);
}
/**
* 匹配年級
*
* @return
*/
public String matchesGrade() {
grade = input.next();
if (!(grade.equals("初級") || grade.equals("中級") || g
29、rade.equals("高級"))) {
System.out.println("無此年級設(shè)置，年級只能輸入初級、中級或高級，請重新輸入:");
this.matchesGrade();
}
return grade;
}
/**
* 匹配手機號
*
* @return
*/
public long matchesPhone() {
phone = input.next();
if (!Pattern.matches("^[0-9]{11}$", phone)) {
System.out.println
30、("輸入有誤，電話號碼只能是11位數(shù)字,請重新輸入：");
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("郵箱格式有誤，請輸入正確的電子郵箱（包含@和.com）");
this.matchesEmail();
}
return email;
}
}
好了，別的我就不說了，怎么調(diào)用，我更就不用說了吧？
本文為原創(chuàng)作品，轉(zhuǎn)載需注明出處
java+JDBC小項目《學(xué)生管理系統(tǒng)》源碼帶注解
