1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
| package com.jason.frame;
import java.awt.*;
import java.awt.event.*;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import javax.swing.JOptionPane;
public class BookAdd extends Frame implements ActionListener{
Toolkit tool= getToolkit();
String url="src/bookbk.png";
Image img=tool.getImage(url);
public void paint(Graphics g){
g.drawImage(img,0,0,this);
}
public void clearAndSetBookId(){
for(int j=0;j<booktxt.length;j++){
booktxt[j].setText("");
}
String str=getInsertOrderedList();
booktxt[0].setEditable(false);
booktxt[0].setText(str);
}
String[] lbname={"图书编号","图书名称","图书页数","图书作者","翻 译","出 版 社","出版时间","定价","库存数量","所属类型"};
Label[] booklb=new Label[10];
TextField[] booktxt=new TextField[10];
Button savebtn=new Button("Save");
Button closebtn=new Button("Close");
Choice booktype=new Choice();
public BookAdd(){
setTitle("添加新书");
setLayout(null);
setSize(500,250);
setResizable(false);
this.setForeground(Color.BLACK);
int lx=50,ly=50;
booktype.add("程序设计");
booktype.add("图形设计");
booktype.add("其他");
booktype.add("科技");
booktype.add("文学");
booktype.add("历史");
booktype.add("百科");
booktype.add("英语");
booktype.add("计算机");
booktype.add("Internet");
booktype.add("数学");
String str=getInsertOrderedList();
for(int i=0;i<booklb.length;i++){
if(lx>240){
lx=50;
ly=ly+30;
}
booklb[i]=new Label(lbname[i]);
booklb[i].setBounds(lx,ly,50,20);
booktxt[i]=new TextField();
booktxt[i].setBounds(lx+60,ly,100,20);
lx=lx+190;
add(booklb[i]);add(booktxt[i]);
}
booktxt[0].setEditable(false);
booktxt[0].setText(str);
booktxt[9].setVisible(false);
booktype.setBounds(300,170,100,20);
add(booktype);
savebtn.setBounds(150,210,80,25);
closebtn.setBounds(280,210,80,25);
add(savebtn);add(closebtn);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
DbOp.close();
dispose();
}
});
savebtn.addActionListener(this);
closebtn.addActionListener(this);
setLocationRelativeTo(null);
setVisible(true);
}
public static String getInsertOrderedList(){
String returnstring="";
String sql="select * from book";
try{
int count=0;
ResultSet rs=DbOp.executeQuery(sql);
while(rs.next()){
count++;
}
String[] allid=new String[count];
int[] intofid=new int[count];
int i=0;
ResultSet rs1=DbOp.executeQuery(sql);
while(rs1.next()){
allid[i]=rs1.getString("id");
String mystr=allid[i].substring(1);
intofid[i]=Integer.parseInt(mystr);
i++;
}
int temp=-1;
for(int j=0;j<intofid.length;j++){
if(intofid[j]>temp){
temp=intofid[j];
}
}
returnstring=String.valueOf(temp+1);
int len=returnstring.length();
for(int f=0;f<5-len;f++){
returnstring="0"+returnstring;
}
returnstring="A"+returnstring;
DbOp.close();
}catch(SQLException ee){
}
return returnstring;
}
public void actionPerformed(ActionEvent e){
Object ob=e.getSource();
if(ob==savebtn){
savebtnActionPerformed();
clearAndSetBookId();
}
if(ob==closebtn){
DbOp.close();
dispose();
}
}
public void savebtnActionPerformed(){
String id=booktxt[0].getText();
String typestr=booktype.getSelectedItem().toString();
String[] inputstring=new String[9];
boolean emptyequals=false;
for(int i=0;i<inputstring.length;i++){
inputstring[i]=booktxt[i].getText();
if(inputstring[i].equals("")){
JOptionPane.showMessageDialog(null,"请务必填写完整");
return;
}
}
if(id.equals("")){
JOptionPane.showMessageDialog(null,"图书编号不能为空");
return;
}
if(IfBookIdExit(id)){
JOptionPane.showMessageDialog(null,"图书编号已存在");
return;
}
try{
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM");
sdf.parse(inputstring[6]);
float price=Float.parseFloat(inputstring[7]);
int stock= Integer.parseInt(inputstring[8]);
int page=Integer.parseInt(inputstring[2]);
String sql="insert into book(id,bookname,booktype,author,translator,publisher,publish_time,price,stock,page)";
sql=sql+"values('"+id+"','"+inputstring[1]+"','"+typestr+"','"+inputstring[3]+"','"+inputstring[4]+"','";
sql=sql+inputstring[5]+"','"+inputstring[6]+"',"+price+","+stock+","+page+")";
int i=DbOp.executeUpdate(sql);
if(i==1){
JOptionPane.showMessageDialog(null,"图书添加成功！");
clearAllText();
}
}catch(ParseException e2){
JOptionPane.showMessageDialog(null,"出版时间格式错误，正确为（年-月）");
}catch(NumberFormatException e1){
JOptionPane.showMessageDialog(null,"库存数量，价格，页数错误，应为数字");
}
}
public boolean IfBookIdExit(String id){
boolean right=false;
String sql="select*from book where id='"+id+"'";
ResultSet rs=DbOp.executeQuery(sql);
try{
while(rs.next()){
right = true;
}
}catch(SQLException e){
JOptionPane.showMessageDialog(null,"无法正常读取数据");
}
return right;
}
public void clearAllText(){
for(int i=0;i<booktxt.length;i++){
booktxt[i].setText("");
}
}
public static void main(String[] args){
new BookAdd();
}
}
|
JavaWeb 图书管理系统springboot + jpa + mybatis + springsecurity +javaex实现图书管理系统
图书管理系统设计与实现—看这篇就够了Java+Jsp+Servlet 实现图书管理系统
基于web的图书管理系统设计与实现（附演示地址）Java+Jsp+Servlet 实现图书管理系统
基于SSH框架的人力资源管理系统设计与实现Spring+SpringMVC+Hibernate实现人力资源管理系统
基于SSM框架的JavaWeb通用权限管理系统Jsp 、SSM（Spring + Spring-MVC + Mybatis）、Shiro 、Mvc、Jdbc、MySQL...
