📄 returnbook.java

📁 java实现的图书馆管理系统－设计论文
💻 JAVA
📖 第 1 页 / 共 5 页
字号:
	 		  ResultSet rs = stmt.executeQuery("select * from 读者资料");
	 		  while(rs.next())
	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
	 		    xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
	 		    zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
	 		    lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
	 		    kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
                stmt.executeUpdate("update 读者资料 set 读者状态='"+chaoqi+"'where 读者编号='"+jtf5.getText().trim()+"'");
		      }
		   con.close();
	   }
//设置读者状态为正常///////////////////////////////////////////////////////////////////////////////////////////
     public void zheng() throws SQLException
	 		{ String chaoqi="正常";
	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
	 		  String strurl=
	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	 		  catch (ClassNotFoundException eg) {}
	 		  con= DriverManager.getConnection(strurl);
	 		  stmt= con.createStatement();
	 		  ResultSet rs = stmt.executeQuery("select * from 读者资料");
	 		  while(rs.next())
	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
	 		    xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
	 		    zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
	 		    lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
	 		    kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
                stmt.executeUpdate("update 读者资料 set 读者状态='"+chaoqi+"'where 读者编号='"+jtf5.getText().trim()+"'");
		      }
		   con.close();
	   }
//查询读者状态是否超期///////////////////////////////////////////////////////////////////////////////////////////
     public void Chaoqi1() throws SQLException
	 		{ String chaoqi="借书超期",guashi="已挂失";
	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz,yjsl;
	 		  String strurl=
	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	 		  catch (ClassNotFoundException eg) {}
	 		  con= DriverManager.getConnection(strurl);
	 		  stmt= con.createStatement();
	 		  ResultSet rs = stmt.executeQuery("select * from 读者资料 where 读者编号='"+jtf1.getText().trim()+"'");
	 		  while(rs.next())
	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
	 		    xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
	 		    zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
	 		    lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
	 		    kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
                yjsl=String.valueOf(rs.getInt("已借数量"));
                if(dzzt.equals("借书超期"))
                   {JOptionPane.showMessageDialog(null, "该读者所借图书有已超期，请您先归还超期图书再归还其它图书!", "友情提示",
								                            JOptionPane.WARNING_MESSAGE);
                    try{ Query2();}
					catch(SQLException ed){System.err.println(ed);}
					try{ Query();}
	                catch(SQLException ed){System.err.println(ed);}
			       }
			       else if(dzzt.equals(guashi))
			            {JOptionPane.showMessageDialog(null, "该读者已挂失，请办理新证后再归还图书!", "友情提示",
								                            JOptionPane.WARNING_MESSAGE);
	                     try{ Query2();}
	                     catch(SQLException ed){System.err.println(ed);}
	                     try{ Query();}
	                     catch(SQLException ed){System.err.println(ed);}
				        }
				        else
				        {try{ Query2();}
	                     catch(SQLException ed){System.err.println(ed);}
	                     try{ Query();}
	                     catch(SQLException ed){System.err.println(ed);}
						}

		     }
		     con.close();
	   }
//查询读者资料代码///////////////////////////////////////////////////////////////////////////////////////////
     public void Query() throws SQLException
	 		{
	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
	 		  String strurl=
	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	 		  catch (ClassNotFoundException eg) {}
	 		  con= DriverManager.getConnection(strurl);
	 		  stmt= con.createStatement();
	 		  ResultSet rs = stmt.executeQuery("select * from 读者资料");
	 		  while(rs.next())
	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("条形码");
	 		    xb=rs.getString("性别");sf=rs.getString("身份");yxzj=rs.getString("有效证件");zjhm=rs.getString("证件号码");
	 		    zcrq=rs.getString("注册日期");zxrq=rs.getString("截止日期");csrq=rs.getString("出生日期");
	 		    lxdh=rs.getString("联系电话");lxdz=rs.getString("联系地址");dzzt=rs.getString("读者状态");
	 		    kjsl=String.valueOf(rs.getInt("可借数量"));zcqx=String.valueOf(rs.getInt("最长期限"));jycs=String.valueOf(rs.getInt("借阅次数"));czy=rs.getString("操作员");bz=rs.getString("备注");
	 			if(jrb1.isSelected())//按读者编号
	 		    {
	 			  if(dzbh.equals(jtf1.getText()))
	 		      {	jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
	 		        jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
	 		        try{ Query2();}
	                catch(SQLException ed){System.err.println(ed);}
	                try{ Query4();}
	                catch(SQLException ed){System.err.println(ed);}
	 		        lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 		        lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 		        rzcqx=zcqx;
	 		      }
	 		    }
	 		    if(jrb2.isSelected())//按条形码
	 			{
	 			  if(txm.equals(jtf1.getText()))
	 			  { jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
	 		        jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
	 		        rzcqx=zcqx;
	 		        try{ Query2();}
	                catch(SQLException ed){System.err.println(ed);}
	                try{ Query4();}
	                catch(SQLException ed){System.err.println(ed);}
	 		        lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 		        lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 			  }
	 		    }
	 		    if(jrb3.isSelected())//按读者姓名
	 			{
	 			  if(dzxm.equals(jtf1.getText()))
	 			  { jtf2.setText(dzxm);jtf3.setText(xb);jtf4.setText(sf);jtf5.setText(dzbh);jtf6.setText(txm);jtf7.setText(kjsl);
	 		        jtf8.setText(yxzj);jtf9.setText(zjhm);jtf10.setText(lxdh);jtf11.setText(lxdz);jtf12.setText(zcrq);
	 		        rzcqx=zcqx;
	 		        try{ Query2();}
	                catch(SQLException ed){System.err.println(ed);}
	                try{ Query4();}
	                catch(SQLException ed){System.err.println(ed);}
	 		        lb3.setText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 		        lb3.setToolTipText("该读者总共可借"+kjsl+"本,最长期限为"+zcqx+"天,现已借"+String.valueOf(readerc+readerc1)+"本!");
	 			  }

		       }
		       try{ setnull();}
			   catch(SQLException ed){System.err.println(ed);}
			   try{ setnull1();}
	           catch(SQLException ed){System.err.println(ed);}
		       try{ view();}
			   catch(SQLException ed){System.err.println(ed);}
			   try{ view1();}
	           catch(SQLException ed){System.err.println(ed);}
		   }
		   con.close();
	   }
//查询借书统计代码////////////////////////////////////////////////////////////////////////////////////////
	   public void Query2() throws SQLException
	   	 		{ readerc=0;
	   	 		  String yes="无";
	   	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
	   	 		  String strurl=
	   	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	   	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	   	 		  catch (ClassNotFoundException eg) {}
	   	 		  con= DriverManager.getConnection(strurl);
	   	 		  stmt= con.createStatement();
	   	 		  ResultSet rs = stmt.executeQuery("select * from  借书统计 where 读者编号='"+jtf5.getText().trim()+"'AND 续借='"+yes+"'");
	   	 		  while(rs.next())
	   	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
	   	 		    xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=String.valueOf(rs.getInt("借阅数量"));
	   	 		    zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
	   	 		    lxdh=rs.getString("图书类型");lxdz=rs.getString("借书日期");dzzt=rs.getString("应还日期");
	   	 		    zcqx=rs.getString("操作员");jycs=rs.getString("续借");
	   	 			readerc++;
	   		      }
	   		      con.close();
	   }
//查询续借统计代码////////////////////////////////////////////////////////////////////////////////////////
	   public void Query4() throws SQLException
	   	 		{ readerc1=0;
	   	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
	   	 		  String strurl=
	   	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	   	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	   	 		  catch (ClassNotFoundException eg) {}
	   	 		  con= DriverManager.getConnection(strurl);
	   	 		  stmt= con.createStatement();
	   	 		  ResultSet rs = stmt.executeQuery("select * from  续借统计 where 读者编号='"+jtf5.getText().trim()+"'");
	   	 		  while(rs.next())
	   	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
		   	 		xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
		   	 		zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
		   	 		lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
		   	 		zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");
	   	 			readerc1++;
	   		      }
	   		      con.close();
	   }
////////////////////////////////////////////查询上次续借时间代码//////////////////////////////////////////////
public void Query3() throws SQLException
	   	 	{
	   	 	 try{ String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
	   	 		  String strurl=
	   	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	   	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	   	 		  catch (ClassNotFoundException eg) {}
	   	 		  con= DriverManager.getConnection(strurl);
	   	 		  stmt= con.createStatement();
	   	 		  ResultSet rs = stmt.executeQuery("select * from  续借统计 where 读者编号='"+jtf5.getText().trim()+"'");
	   	 		  while(rs.next())
	   	 		  { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
		   	 		     xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
		   	 		     zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
		   	 		     lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
		   	 		     zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");
		   	 		     jtf16.setText(dzzt);
		   	 		     lb17.setText("上次续借时间:");
			      }
			  }
			  catch(Exception es)
			  {es.printStackTrace();}
	   }

///////////////////////////////归还续借图书代码/////////////////////////////////////////////////////////////////////
    public void Return() throws SQLException
		   	 		{
		   	 		  String dzxm,dzbh,txm,xb,sf,yxzj,zjhm,zcrq,zxrq,csrq,lxdh,lxdz,dzzt,kjsl,zcqx,jycs,czy,bz;
		   	 		  String strurl=
		   	 		  				"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
		   	 		  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
		   	 		  catch (ClassNotFoundException eg) {}
		   	 		  con= DriverManager.getConnection(strurl);
		   	 		  stmt= con.createStatement();
					  if(jtf21.getText().trim().equals(""))
		   	 		  {JOptionPane.showMessageDialog(null, "操作员不能为空，请填写完整后再办理归还图书!", "友情提示",
								                            JOptionPane.WARNING_MESSAGE);
					   }
				      else
		   	 		   {ResultSet rs = stmt.executeQuery("select * from  续借统计");
		   	 		    while(rs.next())
		   	 		    { dzxm=rs.getString("读者姓名");dzbh=rs.getString("读者编号");txm=rs.getString("读者条形码");
		   	 		      xb=rs.getString("图书名称");sf=rs.getString("图书编号");yxzj=rs.getString("图书条形码");zjhm=rs.getString("续借数量");
		   	 		      zcrq=String.valueOf(rs.getInt("图书价格"));zxrq=rs.getString("出版社");csrq=rs.getString("存放位置");
		   	 		      lxdh=rs.getString("图书类型");lxdz=rs.getString("上次借阅时间");dzzt=rs.getString("本次续借时间");
		   	 		      zcqx=rs.getString("下次归还时间");czy=rs.getString("操作员");
		   	 		      if(code.equals(sf))
		   	 		      {
						   int n=JOptionPane.showConfirmDialog(this,"您确定要归还该图书吗?\n"+"图书编号为:"+code+",条形码为:"+tiaoma+",名称为:"+name,"确认对话框",JOptionPane.YES_NO_OPTION);
		   	 		       if(n==JOptionPane.YES_OPTION)
		   	 		       {
							stmt.executeUpdate("delete from 续借统计 where 图书编号='"+code+"'");
  	                        JOptionPane.showMessageDialog(null, "该图书已归还，欢迎再次借书!", "友情提示",
								                            JOptionPane.WARNING_MESSAGE);
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -