package book;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import DB.ConnDB;
public class book_operate {
public book_operate() {
super();
// TODO Auto-generated constructor stub
}
public List<book_information> get_allbook() throws SQLException{
int num=0;
List<book_information> book=new ArrayList<book_information>();
ConnDB conn=new ConnDB();
String sql="select suoshuhao,book_name,chubanshe,banben,zuozhe,isbn,dingjia,shuliang,shengyu from book_information group by suoshuhao";
ResultSet rs=conn.executeQuery(sql);
while(rs.next()) {
String suoshuhao=rs.getString("suoshuhao");
String book_name=rs.getString("book_name");
String banben=rs.getString("banben");
String chubanshe=rs.getString("chubanshe");
String zuozhe=rs.getString("zuozhe");
String isbn=rs.getString("isbn");
double dingjia=rs.getDouble("dingjia");
int shuliang=rs.getInt("shuliang");
int shengyu=rs.getInt("shengyu");
String sql1="select sum(shengyu) as num from book_information where suoshuhao='"+suoshuhao+"'";
ResultSet rs1=conn.executeQuery(sql1);
if (rs1.next()) {
num=rs1.getInt("num");
}
conn.close();
book_information information=new book_information( suoshuhao, book_name, banben, chubanshe, zuozhe, isbn, dingjia, shuliang,num);
book.add(information);
}
return book;
}
public List<book_information> get_book(String name) throws SQLException{
List<book_information> book=new ArrayList<book_information>();
ConnDB conn=new ConnDB();
String sql="select suoshuhao,book_name,chubanshe,banben,zuozhe,isbn,weizhi,dingjia,shuliang,shengyu from book_information where book_name like '%"+name+"%'";
ResultSet rs=conn.executeQuery(sql);
while(rs.next()) {
String suoshuhao=rs.getString("suoshuhao");
String book_name=rs.getString("book_name");
String banben=rs.getString("banben");
String chubanshe=rs.getString("chubanshe");
String zuozhe=rs.getString("zuozhe");
String isbn=rs.getString("isbn");
String weizhi=rs.getString("weizhi");
double dingjia=rs.getDouble("dingjia");
int shuliang=rs.getInt("shuliang");
int shengyu=rs.getInt("shengyu");
book_information information=new book_information( suoshuhao, book_name, banben, chubanshe, zuozhe, isbn,weizhi, dingjia, shuliang,shengyu);
book.add(information);
}
conn.close();
return book;
}
public List<book_information> get_borrowbook(String name) throws SQLException{
List<book_information> book=new ArrayList<book_information>();
ConnDB conn=new ConnDB();
String sql="select tiaoma,suoshuhao,book_name,chubanshe,banben,zuozhe,isbn,weizhi,dingjia,shuliang,shengyu from book_information where book_name like '%"+name+"%'";
ResultSet rs=conn.executeQuery(sql);
while(rs.next()) {
String tiaoma=rs.getString("tiaoma");
String suoshuhao=rs.getString("suoshuhao");
String book_name=rs.getString("book_name");
String banben=rs.getString("banben");
String chubanshe=rs.getString("chubanshe");
String zuozhe=rs.getString("zuozhe");
String isbn=rs.getString("isbn");
String weizhi=rs.getString("weizhi");
double dingjia=rs.getDouble("dingjia");
int shuliang=rs.getInt("shuliang");
int shengyu=rs.getInt("shengyu");
book_information information=new book_information( tiaoma,suoshuhao, book_name, banben, chubanshe, zuozhe, isbn,weizhi, dingjia, shuliang,shengyu);
book.add(information);
}
conn.close();
return book;
}
public int insert_book(String tiaoma,String suoshuhao,String book_name,String banben,String chubanshe,String zuozhe,String weizhi,String isbn,String dingjia
,int shuliang) {
int x=0;
ConnDB conn=new ConnDB();
String sql="insert into book_information(tiaoma,suoshuhao,book_name,banben,chubanshe,zuozhe,weizhi,isbn,dingjia,shuliang) value ('"+tiaoma+"','"
+suoshuhao+"','"+book_name+"','"+banben+"','"+chubanshe+"','"+zuozhe+"','"+weizhi+"','"+isbn+"','"+dingjia+"',"+shuliang+")";
x=conn.executeUpdate(sql);
return x;
}
public List<book_information> get_book_bysuoshu(String name) throws SQLException{
List<book_information> book=new ArrayList<book_information>();
ConnDB conn=new ConnDB();
String sql="select tiaoma,suoshuhao,book_name,chubanshe,banben,zuozhe,isbn,weizhi,dingjia,shuliang,shengyu from book_information where suoshuhao ='"+name+"'";
ResultSet rs=conn.executeQuery(sql);
while(rs.next()) {
String tiaoma=rs.getString("tiaoma");
String suoshuhao=rs.getString("suoshuhao");
String book_name=rs.getString("book_name");
String banben=rs.getString("banben");
String chubanshe=rs.getString("chubanshe");
String zuozhe=rs.getString("zuozhe");
String isbn=rs.getString("isbn");
String weizhi=rs.getString("weizhi");
double dingjia=rs.getDouble("dingjia");
int shuliang=rs.getInt("shuliang");
int shengyu=rs.getInt("shengyu");
book_information information=new book_information( tiaoma,suoshuhao, book_name, banben, chubanshe, zuozhe, isbn,weizhi, dingjia, shuliang,shengyu);
book.add(information);
}
conn.close();
return book;
}
}
【毕设】基于ssm的jsp图书馆管理系统课程设计.zip
版权申诉
95 浏览量
2023-05-18
15:41:59
上传
评论 1
收藏 14.54MB ZIP 举报
【毕设】基于ssm的jsp图书馆管理系统课程设计.zip （474个子文件） 
book_operate.class 6KB student_information_operate.class 5KB book_information_operate.class 4KB student_information.class 4KB book_information.class 4KB upload.class 4KB email_zhuce.class 4KB order_book_operate.class 3KB user_book.class 3KB ConnDB.class 3KB user_information.class 3KB register_admin.class 3KB email_jieshu.class 3KB register.class 3KB change_student_servlet.class 3KB change_informartion_operate.class 3KB borrow.class 3KB head_image.class 3KB login.class 3KB change_book_servlet.class 3KB book_information.class 3KB change_information_servlet.class 3KB Insert_servlet.class 3KB weigui_information_operate.class 3KB finsh_order_borrow_servlet.class 3KB delete_servlet.class 3KB BasicController.class 2KB borrow_book_operate.class 2KB sendphone_yzm.class 2KB order.class 2KB renew.class 2KB back.class 2KB finsh_order_servlet.class 2KB delete_student_servlet.class 2KB user_login_operate.class 2KB AlipayConfig.class 2KB borrow_book_history.class 2KB change_information.class 2KB sendphone.class 2KB renew_operate.class 2KB order_information.class 2KB delete_book_servlet.class 2KB weigui_information.class 2KB user_register_operate.class 2KB book_history.class 2KB borrow_information.class 2KB change_head_image.class 2KB DbConnection.class 1KB DbUtil.class 1KB user_register.class 1KB finsh_order.class 1KB head.class 1KB phone_yzm.class 983B borrowtime.class 892B user_login.class 864B head_inform.class 860B .classpath 3KB org.eclipse.wst.common.component 473B org.eclipse.wst.jsdt.ui.superType.container 49B bootstrap.css 186KB bootstrap.min.css 118KB layui.css 58KB jquery.mCustomScrollbar.css 52KB backHome.css 15KB layer.css 14KB layui.mobile.css 10KB frameStyle.css 9KB login.css 8KB style.css 7KB laydate.css 7KB iconfontStyle.css 6KB zTreeStyle.css 6KB base.css 5KB cropper.min.css 5KB load.css 4KB iconfont.css 4KB style_3.css 3KB style_3.css 3KB style_2.css 2KB base1.css 2KB reportForm.css 2KB slidercaptcha.css 2KB formRL.css 2KB sitelogo.css 2KB login1.css 1KB register.css 1KB dropSort.css 1KB timePage.css 1KB code.css 1KB errorPage.css 460B Thumbs.db 31KB Thumbs.db 31KB iconfont.eot 38KB iconfont.eot 18KB
59.gif 10KB 22.gif 10KB 24.gif 8KB 13.gif 7KB 16.gif 7KB 39.gif 6KB共 474 条
- 1
- 2
- 3
- 4
- 5
资源评论
Matlab科研辅导帮
- 粉丝: 2w+
- 资源: 7621
最新资源
- PID资源代码：PID 控制器源代码，能够实现Pid算法的仿真控制
- MySQL安装和配置的步骤，适用于Windows系统： Windows系统上安装MySQL: 下载MySQL:
- MySQL安装和配置的步骤，适用于Windows系统： Windows系统上安装MySQL: 下载MySQL:
- C#学习小案例源代码工程文件（小白参考学习）.zip
- JavaScript面试题.md
- MySQL安装和配置的步骤，适用于Windows系统： Windows系统上安装MySQL: 下载MySQL:
- 基于ASP.NET MVC的购物商城网站代码
- Visual Basic + SQL Server 实现图书管理系统 + 课程设计文档
- yolo2资源代码：yolo算法的实现，使用tensorflow进行实现的源代码
- H5手机端向右滑动验证跳转特效
资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！
点击此处反馈
