stockaddress.java

java实现的图书馆管理系统－设计论文

 	  		jtf2.setEnabled(true);
 	        jta.setEnabled(true);
       }
 	}

     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]);
 	   	    }

 	   	   jtf1.setText(tempString);
 	   	   jtf2.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 书架编号='" + jtf2.getText().trim()+ "'OR 名称='"+jtf1.getText().trim()+"'");
 		  if(rs.next())
 		  {JOptionPane.showMessageDialog(null, "此书架名称或编号已经被添加，请您重新输入！", "警告",JOptionPane.WARNING_MESSAGE);
 		   jtf1.setText("");
 		   jtf2.setText("");
 	      }
 	      else
 	      { stmt.executeUpdate("INSERT INTO 书架设置(书架编号,名称) values ('"+jtf2.getText()+"','"+jtf1.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);
 	         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("");
 		      }
 		      else
 		      { stmt.executeUpdate("update 书架设置 set 名称='"+jtf1.getText().trim()+"'where 书架编号='" + jtf2.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);
 		         jta.setEnabled(true);
 			  }
 	}

     public void Update1() throws SQLException
 		    { 	String bianhao,typename;
 				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("名称");
 				   if(typename.equals(jtf2.getText().trim())||bianhao.equals(jtf1.getText().trim()))
 				   {
 				    jtf2.setText(bianhao);
 				    jtf1.setText(typename);
 			        }
 				}
 	}

 	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);
 			           jta.setEnabled(true);
 			          try{ setnull();}
 		               catch(SQLException ed){}
 			          try{ view();}
 		               catch(SQLException ed){}
 					}
 			      }
 			      else
 			      { JOptionPane.showMessageDialog(null, "此书架名称不存在，请确认后再删除！", "警告",JOptionPane.WARNING_MESSAGE);
 	 						   jtf1.setText("");
 	 						   jtf2.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;
 	 i++;
 	 validate();
    }
    rowData[i][0]=null;rowData[i][1]=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);
 					 rowData[i][0]=bianhao;
 					 rowData[i][1]=typename;
 					 i++;
 		             }
 		             jta.repaint();
 	                 con1.close();
 				    }
 				catch(Exception es){//JOptionPane.showMessageDialog(null, "数据库中没有成绩信息", "警告",
 							                                   //JOptionPane.WARNING_MESSAGE);
 								es.printStackTrace();}
 	}

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