systemuse.java

图书管理系统。 借书

package shujuku;

import GUI.*;
import java.sql.*;
public class SystemUse {
	public void change(int in)
	{   String dg=Integer.toString(in);
	 String dd=Integer.toString(in+99);
     	
		String dbUrl = "jdbc:odbc:db1";
		 String sa=null;
		 String user = "";
		 String password = "";
		  Statement s;
		  ResultSet results;
		  try {
		       
		           Connection c =LinkToDB.buildlinktodb();
		          s = c.createStatement();
		          String h="UPDATE 图书 set 编号=编号-1 ,借阅图书号='"+dd+"'WHERE 图书编号="+dg;//+dg;图书编号-1  ,借阅图书号='"+dd+"'
		          s.executeUpdate(h);//+dg);
		  
		          c.close();
			     s.close();
		  }
		  catch(Exception ee) {
	        	//System.out.println("ERROR");
	        	//System.out.println(ee.getMessage());
            	 }

}
	public void change1(int in)
	{
		 String dg=Integer.toString(in);
		 String dbUrl = "jdbc:odbc:db1";
		 String sa=null;
		 String user = "";
		 String password = "";
		  Statement s;
		  ResultSet results;
		  try {
		        
		           Connection c =LinkToDB.buildlinktodb();
		          s = c.createStatement();
		          String h="UPDATE db1 set 编号=编号-1 WHERE 编号='"+dg+"'";//+dg;图书编号-1  ,借阅图书号='"+dd+"'
		          s.executeUpdate(h);//+dg);
		  
		          c.close();
			     s.close();
		  }
		  catch(Exception ee) {
	        	//System.out.println("ERROR");
	        	System.out.println(ee.getMessage());
            	 }

	}
	public String fan(){
		String sd[]=new String[8];
		String g="";
		 String dbUrl = "jdbc:odbc:db1";
		 String sa=null;
		 String user = "";
		 String password = "";
		  Statement s;
		  ResultSet results;
		  try {
		       
		           Connection c=LinkToDB.buildlinktodb();
		          s = c.createStatement();
		       results=s.executeQuery("SELECT * FROM 图书 ");
		   
		      while(results.next())
		       { sd[0]=results.getString("BOOKID图书编号");
	    		 sd[1]=results.getString("BOOKNAME图书书名");
	    		 sd[2]=results.getString("AUTHOR图书作者");;
	    		 sd[3]=results.getString("PUBLISHER图书出版社");
	    		 sd[4]= results.getString("BOOKPRICE图书单价");
	    		 sd[5]=results.getString("ABSTRACT图书摘要");
	    	     sd[6]=results.getString("CLASS图书分类");
		         g=sd[0]+"  "+ sd[1]+"  "+sd[2]+"  "+sd[3]+"  "+sd[4]+"  "+sd[5]+"  " + sd[6]+"**********"+g ;  
			  }
		      c.close();
			     s.close();
		  }
		  catch(Exception ee) {
	        	//System.out.println("ERROR");
	        	System.out.println(ee.getMessage());
           	 }
		  return g;
	}
	public String fan1(){
		String dbUrl = "jdbc:odbc:db1";
		String sd[]=new String[2];
		String g="";
		  String user = "";
		  String password = "";
		  Statement s;
		  ResultSet results;
		    try {
		        
		           Connection c =LinkToDB.buildlinktodb();
		          s = c.createStatement();
		       results=s.executeQuery("SELECT*FROM db1 ");//WHERE 管理员帐号='"+s1[0]+"' AND 管理员密码='"+s1[1]+"'");
		       while(results.next())
		       {
		    	   sd[0]=results.getString("WorkerId");
		    	   sd[1]=results.getString("Password");
		    	   g=sd[0]+"     "+sd[1]+"*****"+g;
		       }
		       c.close();
			     s.close();
		    }
		    catch(Exception ee) {
	        	//System.out.println("ERROR");
	        	System.out.println(ee.getMessage());
           	 }
		  return g;
	}
  public static void main(String[]args)
  {
	  SystemUse j=new SystemUse();
	  System.out.println( j.fan1());
  }
}