本文的目的就是通过图书管理系统掌握数据库编程技术，能正确连接数据库，能对数据库中信息进行查询、插入、删除、修改。
内容：在数据库中创建一张书目信息表，包括书名、作者、出版社、出版日期、书号、价格字段。设计一个gui界面进行书目管理。在该界面上有四个选项卡，分别是查询、插入、删除、修改。点击查询选项卡，出现的界面上有书名、作者、出版社、书号四个文本框，一个按钮和一个只读文本区。文本框内容可以为空，输入相应的查询信息后（例如根据书名查询可以仅输入书名），点击界面上的“查询”按钮，可以在界面下方的文本区中显示出符合条件的书目详细信息。点击插入选项卡，出现的界面上有书名、作者、出版社、出版日期、书号、价格文本框，一个按钮。在文本框中输入信息后，点击“插入”按钮，该书目信息插入数据库表中。点击删除选项卡，出现的界面上有书名文本框和一个按钮，输入书名后点击“删除”按钮，该书目信息从数据库表中删除。点击修改选项卡，出现的界面上有书名、作者、出版社、出版日期、书号、价格文本框，一个按钮。输入的书名必须是已存在的，否则会弹出消息框显示出错信息。输入信息后，点击“修改”按钮，数据库表中的相应书目信息被修改为新值。
源码：
bookinfo.java
我要评论
* 项目名称:图书管理系统
* 版本: 1.0
* 创建者: 张俊强
* 创建时间:2016/5/26
* */
package librarysystem;
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.*;
@suppresswarnings("serial")
public class bookinfo extends jframe implements actionlistener{
//主角面上的控件
private jlabel inputlabel;
private jtextfield inputtext;
private jbutton searchbut;
private jtable booktable;
private jscrollpane bookscroll;
private jbutton addbut;
private jbutton modifybut;
private jbutton deletebut;
private jbutton refreshbut;
private booktablemodel booktablemodel;
public static void main(string[] args) throws sqlexception {
// todo auto-generated method stub
bookinfo bookinfo=new bookinfo();
bookinfo.setdefaultcloseoperation(jframe.exit_on_close);
bookinfo.setbounds(350, 150, 600, 400);
bookinfo.setvisible(true);
// bookinfo.importsql();//导出数据
bookinfo.setminwindowlayout();//设置数据
}
public bookinfo() throws sqlexception{
//创建主界面上的控件
inputlabel=new jlabel("请输入书名:");
inputtext=new jtextfield(10);
searchbut=new jbutton("查询");
booktablemodel=new booktablemodel();
booktable=new jtable(booktablemodel);
bookscroll=new jscrollpane(booktable);
addbut=new jbutton("添加");
modifybut=new jbutton("修改");
deletebut=new jbutton("删除");
refreshbut=new jbutton("刷新");
searchbut.addactionlistener(this);
addbut.addactionlistener(this);
refreshbut.addactionlistener(this);
modifybut.addactionlistener(this);
deletebut.addactionlistener(this);
}
void setminwindowlayout(){
//主界面布局
container con1=new container();
con1.setlayout(new flowlayout());
con1.add(inputlabel);
con1.add(inputtext);
con1.add(searchbut);
con1.add(refreshbut);
container con2=new container();
con2.setlayout(new flowlayout());
con2.add(addbut);
con2.add(modifybut);
con2.add(deletebut);
this.setlayout(new borderlayout());
this.add(con1,borderlayout.north);
this.add(bookscroll,borderlayout.center);
this.add(con2,borderlayout.south);
this.validate();
}
@override
public void actionperformed(actionevent e) {
// todo auto-generated method stub
if(e.getsource()==searchbut){
if(!this.inputtext.gettext().equals("")){
string bookname=this.inputtext.gettext();
string sql="select * from book_info where book_name ='"+bookname+"'";
try {
booktablemodel=new booktablemodel(sql);
booktable.setmodel(booktablemodel);
} catch (sqlexception e1) {
// todo auto-generated catch block
e1.printstacktrace();
}
}else{
joptionpane.showmessagedialog(this,"输入不能为空", "提示",joptionpane.plain_message);
}
}
else if(e.getsource()==addbut){
@suppresswarnings("unused")
addbookdialog addwin=new addbookdialog(this,"添加图书",true);
this.refreshtable();
}
else if(e.getsource()==refreshbut){
this.refreshtable();
}
else if(e.getsource()==deletebut){
int rownum=booktable.getselectedrow();
if(rownum<0||rownum>booktable.getrowcount()){
joptionpane.showmessagedialog(this,"未选中", "提示",joptionpane.plain_message);
}
else{
//system.out.print(bookname);
int n = joptionpane.showconfirmdialog(null, "确认删除吗?", "确认删除框", joptionpane.yes_no_option);
if (n == joptionpane.yes_option) {
string booknum=(string) booktable.getvalueat(rownum, 0);
string sql="delete from book_info where book_num= '"+booknum+"'";
booktablemodel.deletebook(sql);
this.refreshtable();
joptionpane.showmessagedialog(this,"删除成功", "提示",joptionpane.plain_message);
} else if (n == joptionpane.no_option) {
return;
}
}
}
else if(e.getsource()==modifybut){
booktable.setmodel(booktablemodel);
int rownum=booktable.getselectedrow();
if(rownum<0||rownum>booktable.getrowcount()){
joptionpane.showmessagedialog(this,"未选中", "提示",joptionpane.plain_message);
}
else{
@suppresswarnings("unused")
modifybook modifywin=new modifybook(this,"修改信息",true,booktablemodel,rownum);
this.refreshtable();
}
}
}
public void refreshtable(){
booktablemodel searchbook;
try {
searchbook = new booktablemodel("select * from book_info");
booktable.setmodel(searchbook);
booktablemodel=searchbook;
} catch (sqlexception e1) {
// todo auto-generated catch block
e1.printstacktrace();
}
}
}
booktablemodel.java
package librarysystem;
import java.sql.*;
import java.util.*;
/*
* 图书表模型
* */
import javax.swing.table.*;
@suppresswarnings("serial")
public class booktablemodel extends abstracttablemodel{
//表的元素
private vector<vector<string>> rowdata;
private vector<string> colname;
// 数据库
private preparedstatement stmt;
private resultset result;
public booktablemodel(string sql) throws sqlexception{
this.initdata(sql);
}
public booktablemodel() throws sqlexception{
this.initdata("select * from book_info");
}
public void initdata(string sql) throws sqlexception{
setrowdata(new vector<vector<string>>());
setcolname(new vector<string>());
getcolname().add("书号");
getcolname().add("书名");
getcolname().add("作者");
getcolname().add("出版社");
getcolname().add("出版时间");
getcolname().add("价格");
/*
* 数据库的导入
* */
try {
class.forname("com.mysql.jdbc.driver");
} catch (classnotfoundexception e) {
// todo auto-generated catch block
e.printstacktrace();
}
string url= "jdbc:mysql://localhost:3306/device";
string user="root";
string password="zjq1314520";
connection con=drivermanager.getconnection(url,user,password);
stmt = con.preparestatement(sql);
result=stmt.executequery();
importsql();
}
void importsql() throws sqlexception{
// todo auto-generated method stub
@suppresswarnings("unused")
boolean signnull=true;
while(result.next()){
vector<string> item=new vector<string>();
for(int i=1;i<7;i++){
item.add(result.getstring(i));
}
getrowdata().add(item);
signnull=false;
}
result.close();
}
@override
public int getcolumncount() {//得到列数
// todo auto-generated method stub
return this.colname.size();
}
@override
public int getrowcount() {//得到行数
// todo auto-generated method stub
return this.rowdata.size();
}
@override
public object getvalueat(int row, int col) {//得到某行某列的数据
// todo auto-generated method stub
return (this.rowdata.get(row)).get(col);
}
@override
public string getcolumnname(int column) {
// todo auto-generated method stub
return this.colname.get(column);
}
public vector<vector<string>> getrowdata() {
return rowdata;
}
public void setrowdata(vector<vector<string>> rowdata) {
this.rowdata = rowdata;
}
public vector<string> getcolname() {
return colname;
}
public void setcolname(vector<string> colname) {
this.colname = colname;
}
public void addbook(string sql){
try {
stmt.executeupdate(sql);
} catch (sqlexception e) {
// todo auto-generated catch block
e.printstacktrace();
}
// initdata("select * from book_info");
}
public void deletebook(string sql){
try {
stmt.executeupdate(sql);
} catch (sqlexception e1) {
// todo auto-generated catch block
e1.printstacktrace();
}
}
}
addbookdialog.java
package librarysystem;
import java.awt.*;
import java.awt.event.*;
import java.sql.sqlexception;
import javax.swing.*;
@suppresswarnings("serial")
public class addbookdialog extends jdialog implements actionlistener{
private jlabel booknumlabel;
private jlabel booknamelabel;
private jlabel bookwriterlabel;
private jlabel bookpublishlabel;
private jlabel bookpricelabel;
private jlabel booktimelabel;
private jtextfield booknumtext;
private jtextfield booknametext;
private jtextfield bookwritertext;
private jtextfield bookpublishtext;
private jtextfield bookpricetext;
private jtextfield booktimetext;
private jbutton submitbut;
private jbutton cancelbut;
public addbookdialog(frame owner,string title,boolean model){
//父窗口,窗口名,是否是模式窗口
super(owner,title,model);
booknumlabel=new jlabel("书 号:");
booknamelabel=new jlabel("书 名:");
bookwriterlabel=new jlabel("作 者:");
bookpublishlabel=new jlabel("出版社:");
bookpricelabel=new jlabel("价 格:");
booktimelabel=new jlabel("出版时间:");
booknumtext=new jtextfield(10);
booknametext=new jtextfield(10);
bookwritertext=new jtextfield(10);
bookpublishtext=new jtextfield(10);
bookpricetext=new jtextfield(10);
booktimetext=new jtextfield(9);
submitbut=new jbutton("确认");
cancelbut=new jbutton("取消");
submitbut.addactionlistener(this);
cancelbut.addactionlistener(this);
this.setbounds(350,150,400,260);
this.setresizable(false);
this.setlayout(new borderlayout());
initlayout();
}
public void initlayout(){
container[] con1=new container[6];
for(int i=0;i<6;i++) con1[i]=new container();
con1[0].setlayout(new flowlayout());
con1[0].add(booknumlabel);
con1[0].add(booknumtext);
con1[1].setlayout(new flowlayout());
con1[1].add(booknamelabel);
con1[1].add(booknametext);
con1[2].setlayout(new flowlayout());
con1[2].add(bookwriterlabel);
con1[2].add(bookwritertext);
con1[3].setlayout(new flowlayout());
con1[3].add(bookpublishlabel);
con1[3].add(bookpublishtext);
con1[4].setlayout(new flowlayout());
con1[4].add(bookpricelabel);
con1[4].add(bookpricetext);
con1[5].setlayout(new flowlayout());
con1[5].add(booktimelabel);
con1[5].add(booktimetext);
container con2=new container();
con2.setlayout(new borderlayout());
con2.add(con1[0],borderlayout.north);
con2.add(con1[1],borderlayout.center);
con2.add(con1[2],borderlayout.south);
container con3=new container();
con3.setlayout(new borderlayout());
con3.add(con1[3],borderlayout.north);
con3.add(con1[4],borderlayout.center);
con3.add(con1[5],borderlayout.south);
container con4=new container();
con4.setlayout(new flowlayout());
con4.add(submitbut);
con4.add(cancelbut);
container con5=new container();
con5.setlayout(new borderlayout());
con5.add(con2,borderlayout.north);
con5.add(con3,borderlayout.center);
con5.add(con4,borderlayout.south);
this.add(con5,borderlayout.center);
this.validate();
this.setvisible(true);
}
@override
public void actionperformed(actionevent e) {
// todo auto-generated method stub
if(e.getsource()==submitbut){
if(booknumtext.gettext().equals("")||booknametext.gettext().equals("")||
bookwritertext.gettext().equals("")||bookpublishtext.gettext().equals("")||
bookpricetext.gettext().equals("")||booktimetext.gettext().equals("")){
//system.out.println("输入失败");
joptionpane.showmessagedialog(this,"输入不能有空", "提示",joptionpane.plain_message);
}
else{
//system.out.println("输入成功");
string sql="insert into "
+ "book_info(book_num,book_name,book_writer,publish_house,book_price,publish_time)"
+ "values('"+booknumtext.gettext()+"','"+booknametext.gettext()+"','"+bookwritertext.gettext()+"','"+bookpublishtext.gettext()+"','"+bookpricetext.gettext()+"','"+booktimetext.gettext()+"')";
try {
booktablemodel book=new booktablemodel();
book.addbook(sql);
} catch (sqlexception e1) {
// todo auto-generated catch block
e1.printstacktrace();
}
joptionpane.showmessagedialog(this,"添加成功", "提示",joptionpane.plain_message);
this.setvisible(false);
}
}
if(e.getsource()==cancelbut){
this.setvisible(false);
}
}
}
modifybook.java
package librarysystem;
import java.awt.*;
import java.awt.event.*;
import java.sql.sqlexception;
import javax.swing.*;
@suppresswarnings("serial")
public class modifybook extends jdialog implements actionlistener{
private jlabel booknumlabel;
private jlabel booknamelabel;
private jlabel bookwriterlabel;
private jlabel bookpublishlabel;
private jlabel bookpricelabel;
private jlabel booktimelabel;
private jtextfield booknumtext;
private jtextfield booknametext;
private jtextfield bookwritertext;
private jtextfield bookpublishtext;
private jtextfield bookpricetext;
private jtextfield booktimetext;
private jbutton submitbut;
private jbutton cancelbut;
private booktablemodel bookmodel;
private int rownum;
public modifybook(frame owner,string title,boolean type,booktablemodel model,int row){
super(owner,title,type);
bookmodel=model;
rownum=row;
booknumlabel=new jlabel("书 号:");
booknamelabel=new jlabel("书 名:");
bookwriterlabel=new jlabel("作 者:");
bookpublishlabel=new jlabel("出版社:");
bookpricelabel=new jlabel("价 格:");
booktimelabel=new jlabel("出版时间:");
booknumtext=new jtextfield(10);
booknametext=new jtextfield(10);
bookwritertext=new jtextfield(10);
bookpublishtext=new jtextfield(10);
bookpricetext=new jtextfield(10);
booktimetext=new jtextfield(9);
submitbut=new jbutton("确认修改");
cancelbut=new jbutton("取消");
submitbut.addactionlistener(this);
cancelbut.addactionlistener(this);
this.setbounds(350,150,400,260);
this.setresizable(false);
this.setlayout(new borderlayout());
this.setvalue();
this.initlayout();
}
public void initlayout(){
container[] con1=new container[6];
for(int i=0;i<6;i++) con1[i]=new container();
con1[0].setlayout(new flowlayout());
con1[0].add(booknumlabel);
con1[0].add(booknumtext);
con1[1].setlayout(new flowlayout());
con1[1].add(booknamelabel);
con1[1].add(booknametext);
con1[2].setlayout(new flowlayout());
con1[2].add(bookwriterlabel);
con1[2].add(bookwritertext);
con1[3].setlayout(new flowlayout());
con1[3].add(bookpublishlabel);
con1[3].add(bookpublishtext);
con1[4].setlayout(new flowlayout());
con1[4].add(bookpricelabel);
con1[4].add(bookpricetext);
con1[5].setlayout(new flowlayout());
con1[5].add(booktimelabel);
con1[5].add(booktimetext);
container con2=new container();
con2.setlayout(new borderlayout());
con2.add(con1[0],borderlayout.north);
con2.add(con1[1],borderlayout.center);
con2.add(con1[2],borderlayout.south);
container con3=new container();
con3.setlayout(new borderlayout());
con3.add(con1[3],borderlayout.north);
con3.add(con1[4],borderlayout.center);
con3.add(con1[5],borderlayout.south);
container con4=new container();
con4.setlayout(new flowlayout());
con4.add(submitbut);
con4.add(cancelbut);
container con5=new container();
con5.setlayout(new borderlayout());
con5.add(con2,borderlayout.north);
con5.add(con3,borderlayout.center);
con5.add(con4,borderlayout.south);
this.add(con5,borderlayout.center);
this.validate();
this.setvisible(true);
}
public void setvalue(){
this.booknumtext.settext((string) bookmodel.getvalueat(rownum, 0));
this.booknumtext.seteditable(false);
this.booknametext.settext((string) bookmodel.getvalueat(rownum, 1));
this.bookwritertext.settext((string) bookmodel.getvalueat(rownum, 2));
this.bookpublishtext.settext((string) bookmodel.getvalueat(rownum, 3));
this.booktimetext.settext((string) bookmodel.getvalueat(rownum, 4));
this.bookpricetext.settext((string) bookmodel.getvalueat(rownum, 5));
this.validate();
}
@override
public void actionperformed(actionevent e) {
// system.out.println(bookpricetext.gettext());
// todo auto-generated method stub
if(e.getsource()==submitbut){
if(booknumtext.gettext().equals("")||booknametext.gettext().equals("")||
bookwritertext.gettext().equals("")||bookpublishtext.gettext().equals("")||
bookpricetext.gettext().equals("")||booktimetext.gettext().equals("")){
//system.out.println("输入失败");
joptionpane.showmessagedialog(this,"修改不能有空", "提示",joptionpane.plain_message);
}
else{
int n = joptionpane.showconfirmdialog(null, "确认修改吗?", "确认修改框", joptionpane.yes_no_option);
if (n == joptionpane.yes_option) {
string sql="update book_info set book_name ='"+booknametext.gettext()+"', book_writer= '"+bookwritertext.gettext()+"',publish_house='"+bookpublishtext.gettext()+"',book_price='"+bookpricetext.gettext()+"',publish_time='"+booktimetext.gettext()+"' where book_num = '"+booknumtext.gettext()+"' ";
try {
booktablemodel book=new booktablemodel();
book.addbook(sql);
} catch (sqlexception e1) {
// todo auto-generated catch block
e1.printstacktrace();
}
joptionpane.showmessagedialog(this,"修改成功", "提示",joptionpane.plain_message);
this.setvisible(false);
} else if (n == joptionpane.no_option) {
return;
}
}
}
if(e.getsource()==cancelbut){
this.setvisible(false);
}
}
}
程序运行结果：
主界面：
查询界面：
添加图书界面：
修改界面：
删除操作：
数据库界面：
关于管理系统的更多内容请点击《管理系统专题》进行学习
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持移动技术网。
如对本文有疑问， 点击进行留言回复！！
Springboot项目因为kackson版本问题启动报错解决方案
Java多线程下的其他组件之CyclicBarrier、Callable、Future和FutureTask详解
网友评论