Java练手项目实战——图书管理系统（Javaswing+JDBC）.pdfVIP

Java练⼿项⽬实战——图书管理系统（Javaswing+JDBC）

⽬录

基于Javaswing的图书管理系统

1、源码下载链接

2、效果展⽰

3、部分源码展⽰

ookDao.java

package;

importConnection;

importPreparedStatement;

importResultSet;

importSQLxception;

importStatement;

importArrayList;

importDbUtil;

import;

import;

import;

publicclassbookDao{

privateDbUtildbUtil;

privateConnectionconnection;

publicArrayListbookgetAll(){

ArrayListbookarrayList=newArrayList();

Statementstat;

try{

dbUtil=newDbUtil();

connection=dbUtil.getCon();

stat=connection.createStatement();

Stringsql=select*frombook;//

ResultSetrs=stat.executeQuery(sql);

while(rs.next()){

//System.out.println(1111111111111);

bookb=newbook();

b.setBook_id(rs.getString(1));

b.setIsbn(rs.getString(2));

b.setBook_name(rs.getString(3));

b.setWriter(rs.getString(4));

b.setPublisher(rs.getString(5));

b.setPubdate(rs.getDate(6));

b.setBook_shelf_no(rs.getString(7));

b.setBook_status(rs.getInt(8));

b.setDel(rs.getInt(9));

arrayList.add(b);

}

rs.close();

stat.close();

dbUtil.closeCon(connection);

}catch(xceptione){

//TODO:handleexception

returnarrayList;

}

returnarrayList;

}

publicArrayListbookfindID(Stringid){

ArrayListbookarrayList=newArrayList();

try{

dbUtil=newDbUtil();

connection=dbUtil.getCon();

Stringsql=select*frombookwherebook_id=?;//

PreparedStatementpre=connection.prepareStatement(sql);

pre.setString(1,id);

ResultSetrs=pre.executeQuery();