readertype.java

本系统是采用JAVA作为前台开发工具

	      }
		}
/////////////点击表格把数据显示到文本框中代码//////////////////////////////////////////////////////
	    public void valueChanged(ListSelectionEvent el){
		   	  tempString="";
		       //JTable的getSelectedRows()与getSelectedColumns()方法会返回已选取表格cell的index Array数据.
		   	  int[] rows=jta.getSelectedRows();
		   	  int[] columns=jta.getSelectedColumns();

		       //JTable的getValueAt()方法会返回某行的cell数据,返回值是Object数据类型,因此我们要自行转成String数据类型.
		   	    for (int i=0;i<rows.length;i++){
		   	      for (int j=0;j<columns.length;j++)
		                tempString = tempString+(String)jta.getValueAt(rows[i], columns[j]);
		   	    }
               jtf0.setText(tempString);
		   	   jtf1.setText(tempString);
		   	   jtf2.setText(tempString);
		   	   jtf3.setText(tempString);
		   	   try{ Update1();}
			   catch(SQLException ed){}
	   }
/////////////添加读者类型代码//////////////////////////////////////////////////////
	    public void Add() throws SQLException
	    {
			  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 编号='" + jtf0.getText().trim()+ "'OR 名称='"+jtf1.getText().trim()+"'");
			  if(rs.next())
			  {JOptionPane.showMessageDialog(null, "此类型名称或编号已经被添加，请您重新输入！", "警告",JOptionPane.WARNING_MESSAGE);
			   jtf0.setText("");
			   jtf1.setText("");
			   jtf2.setText("");
			   jtf3.setText("");
		      }
		      else
		      { stmt.executeUpdate("INSERT INTO 读者类型(编号,名称,可借数量,最长期限) values ('"+jtf0.getText()+"','"+jtf1.getText()+"','"+jtf2.getText()+"','"+jtf3.getText()+"')");
				JOptionPane.showMessageDialog(null, "恭喜您添加新读者类型成功!");
				try{ setnull();}
				catch(SQLException ed){}
				try{ view();}
			    catch(SQLException ed){}
		         btn40.setVisible(false);
				 btn41.setVisible(false);
				 btn4.setVisible(true);
				 btn4.setEnabled(false);
				 btn5.setEnabled(false);
				 btn1.setEnabled(true);
				 btn2.setEnabled(true);
		  		 btn3.setEnabled(true);
			     jtf1.setEnabled(false);
			     jtf2.setEnabled(false);
			     jtf0.setEnabled(false);
			     jtf3.setEnabled(false);
		         jta.setEnabled(true);
			  }
		}
/////////////更新读者类型代码//////////////////////////////////////////////////////
		public void Update() throws SQLException
		    {
				  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()+ "'");
				  if(rs.next())
				  {
				   JOptionPane.showMessageDialog(null, "此类型名称已经被添加，请您重新输入！", "警告",JOptionPane.WARNING_MESSAGE);
				   jtf1.setText("");
				   jtf2.setText("");
				   jtf3.setText("");
			      }
			      else
			      { stmt.executeUpdate("update 读者类型 set 名称='"+jtf1.getText().trim()+"'where 编号='" + jtf0.getText().trim() + "'");
					JOptionPane.showMessageDialog(null, "恭喜您更新读者类型成功!");
					try{ setnull();}
			        catch(SQLException ed){}
					try{ view();}
			        catch(SQLException ed){}
			         btn40.setVisible(false);
					 btn41.setVisible(false);
					 btn4.setVisible(true);
					 btn4.setEnabled(false);
					 btn5.setEnabled(false);
					 btn1.setEnabled(true);
					 btn2.setEnabled(true);
		  		     btn3.setEnabled(true);
				     jtf1.setEnabled(false);
				     jtf2.setEnabled(false);
				     jtf0.setEnabled(false);
			         jtf3.setEnabled(false);
			         jta.setEnabled(true);
				  }
		}
/////////////点击表格把数据显示到文本框中代码//////////////////////////////////////////////////////
	    public void Update1() throws SQLException
		{ 	        String bianhao,typename,borrow,date;
		            String tf1,tf2,tf3,tf4;
		            tf1=jtf0.getText().trim();tf2=jtf1.getText().trim();
		            tf3=jtf2.getText().trim();tf4=jtf3.getText().trim();
					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())
					  {bianhao=rs.getString("编号");typename=rs.getString("名称");
					   borrow=rs.getString("可借数量");date=rs.getString("最长期限");
					   if(typename.equals(tf2)||bianhao.equals(tf1)||borrow.equals(tf3)||date.equals(tf4))
					   {
					    jtf0.setText(bianhao);
					    jtf1.setText(typename);
                        jtf2.setText(borrow);
                        jtf3.setText(date);
				        }
					   }
		}
/////////////删除读者类型代码//////////////////////////////////////////////////////
		public void Delete() throws SQLException
			    {
					  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()+ "'");
					  if(rs.next())
					  {
					     if(JOptionPane.showConfirmDialog(this, "确实要删除该读者类型的所有信息吗?\n删除的信息将不能恢复,是否继续?",
					   	                                           "删除确定", JOptionPane.OK_CANCEL_OPTION,
		                                           JOptionPane.QUESTION_MESSAGE) == 0);
		                 { stmt.executeUpdate("delete from 读者类型 where 名称='"+jtf1.getText().trim()+"'");
		 					          JOptionPane.showMessageDialog(null, "读者类型信息删除成功!");

		 				   btn40.setVisible(false);
						   btn41.setVisible(false);
						   btn4.setVisible(true);
						   btn4.setEnabled(false);
						   btn5.setEnabled(false);
						   btn1.setEnabled(true);
						   btn2.setEnabled(true);
					       btn3.setEnabled(true);
						   jtf1.setEnabled(false);
						   jtf2.setEnabled(false);
						   jtf0.setEnabled(false);
			               jtf3.setEnabled(false);
				           jta.setEnabled(true);
				           try{ setnull();}
						   catch(SQLException ed){}
						   try{ view();}
			               catch(SQLException ed){}
						}
				      }
				      else
				      { JOptionPane.showMessageDialog(null, "此图书类型不存在，请确认后再删除！", "警告",JOptionPane.WARNING_MESSAGE);
		 						   jtf1.setText("");
		 						   jtf2.setText("");
		 						   jtf0.setText("");
			                       jtf3.setText("");
					  }
		}
/////////////设置表格为空代码//////////////////////////////////////////////////////
public void setnull() throws SQLException
{int i=0;
 try{
     String strurl =
        "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     con= DriverManager.getConnection(strurl);
     stmt = con.createStatement();
     ResultSet rs=stmt.executeQuery("SELECT * From 读者类型");
     while(rs.next())
    {
     rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
 	 rowData[i][3]=null;
 	 i++;
 	 validate();
    }
    rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
   	rowData[i][3]=null;
    jta.repaint();
   }

catch(Exception g)
{g.printStackTrace();}

}
/////////////把数据库中的数据显示到表格中代码//////////////////////////////////////////////////////
	    public void view() throws SQLException
	    { //--连接表格和数据库--
					int i=0;
					try{
						String strurl1 =
									    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
						try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
						catch (ClassNotFoundException eg) {}
						con1= DriverManager.getConnection(strurl1);
						stmt1= con1.createStatement();
						ResultSet rs1 = stmt1.executeQuery("select * from 读者类型 ORDER BY 编号");
						while(rs1.next())
						{String bianhao=rs1.getString(1);
						 String typename=rs1.getString(2);
						 String count=rs1.getString(3);
						 String date=rs1.getString(4);
						 rowData[i][0]=bianhao;
						 rowData[i][1]=typename;
						 rowData[i][2]=count;
						 rowData[i][3]=date;
						 i++;
			             }
			             jta.repaint();
		                 con1.close();
					    }
					catch(Exception es)
					{es.printStackTrace();}
	}

	public static void main(String[]args)
		{   try {
		            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
		            }
		        catch(Exception e) {
		            e.printStackTrace();
		           }
			new ReaderType();
	}
}