main.java

图书馆的图书管理系统！ 图书查询

package labraryManager;

import java.io.File;
import java.sql.SQLException;

public class Main {
	
	public static boolean entered=false;
	public static int level=0;
	public static String manager="";
	public static String pass="";
	public static void main(String[] args) {
		DataBase_Sever d=new DataBase_Sever();
		DataBase_Sever d1=new DataBase_Sever();
	    d.select("oldPath", "");
	    File file;
	    String s="";
	    //try{
		
		    try {
				while(d.rs.next()){
					s=d.rs.getString("OldPath");
				    file=new File(s.replace('\\', '/'));
				    
				    
				    if(file.exists()==false){
				    	d1.delete("oldPath", " where OldPath='"+s+"'");
				    	
				    }
				    
				}
			
            d.rs.close();
		    } catch (SQLException ex) {
				// TODO Auto-generated catch block
				ex.printStackTrace();
			}
	        //}catch(SQLException ex1){}
	    d.closeDB();
		
	    
		 d.select("newPath", "");
		    
		    
		   // try{
			
			    try {
					while(d.rs.next()){
						s=d.rs.getString("NewPath");
					    file=new File(s.replace('\\', '/'));
					    
					    
					    if(file.exists()==false){

					    	d1.delete("newPath", " where NewPath='"+s+"'");
					    }
					    
					}
				
	            d.rs.close();
			    } catch (SQLException ex) {
					// TODO Auto-generated catch block
					ex.printStackTrace();
				}
		       // }catch(SQLException ex1){}
		    d.closeDB();
	    
	    
		  
		
		
		MainWindow x=new MainWindow();
		x.setVisible(true);
	}
}