house.java

课程设计课程设计课程设计课程设计课程设计课程设计

	p1.setLayout(new FlowLayout(FlowLayout.LEFT));
	p1.add(pp);
	this.getContentPane().add(pp,"Center");
	this.getContentPane().add(p2,"South");
	setVisible(true);
  }
  public void itemStateChanged(ItemEvent e){
    pp.dd.show(pp,(String)comb.getSelectedItem());
  }
  public void actionPerformed(ActionEvent e){ 
    int total=fname.length;
	if(e.getSource()==next){pp.dd.next(pp);n=(n+1)%total;}
	else if(e.getSource()==prev){pp.dd.previous(pp);n=(n-1+total)%total;}
	else if(e.getSource()==first){pp.dd.first(pp);n=0;}
	else if(e.getSource()==last){pp.dd.last(pp);n=total;}
  }
  public static void main(String args[]) {
    JFrame.setDefaultLookAndFeelDecorated(true);
    Font font = new Font("JFrame", Font.PLAIN, 14);
    Enumeration keys = UIManager.getLookAndFeelDefaults().keys();
    while (keys.hasMoreElements()) {
      Object key = keys.nextElement();
      if (UIManager.get(key) instanceof Font)UIManager.put(key, font);
    }	
	PictureBrowse mainFrame = new PictureBrowse();
  }
}
class Browse extends JPanel {
  CardLayout dd=new CardLayout();
  boolean f=false;
  Picture pic;
  Browse(String fname[]){   
    setLayout(dd);
    for(int i=0;i<fname.length;i++){   
      pic=new Picture(fname[i]);
      add(fname[i],new JScrollPane(pic)); 
    }
  }
}
class Picture extends JPanel{
  Image im;
  MediaTracker tracker=new MediaTracker(this); 
  Picture(String fname){  
	Toolkit tool=Toolkit.getDefaultToolkit();//建立Toolkit对象
	im=tool.getImage(fname);                    //使用Toolkit对象打开图像
	tracker.addImage(im,0);                     //进行跟踪
	try{
	  tracker.waitForAll();
	}catch(InterruptedException e){}
              this.setPreferredSize(new Dimension(im.getWidth(this),im.getHeight(this)));
  }
  public void paintComponent(Graphics g){   
    g.drawImage(im,0,0,this);
  }
}


class sqbiao 
{
	         	
	public sqbiao() 
	{
	String bms1=	shenqingFrame.bms;
	String zcs1=	shenqingFrame.zcs;
	String nams1=    shenqingFrame.nams;
	String nums1=	shenqingFrame.nums;
	String mjs1=	shenqingFrame.mjs;
			
		try {
			Statement stmt;
        	PreparedStatement pstmt;
			ResultSet rs;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");
		
			
			pstmt=con.prepareStatement("INSERT INTO sqbiao ("
				+ "bumensq,zcsq,name,numsq,mjsq,zfjf) VALUES(?,?,?,?,?,?)");
			String sqbm=bms1;
			String sqnam=nams1;
			try{
			
			Double sqzc=Double.parseDouble(zcs1);
			Double sqnum=Double.parseDouble(nums1);
			Double sqmj=Double.parseDouble(mjs1);
			Double sqjf=sqzc*sqnum;
			
				pstmt.setString(1,sqbm);
				pstmt.setDouble(2,sqzc);
				pstmt.setString(3,sqnam);
				pstmt.setDouble(4,sqnum);
				pstmt.setDouble(5,sqmj);
				pstmt.setDouble(6,sqjf);
				
				
			pstmt.execute();
	}catch(NumberFormatException q)
		{
			q.printStackTrace();
		}
				   
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
	}
}



 class tjsqbiao
{
	         	
	public tjsqbiao() 
	{
		try {
			Statement stmt;
        	PreparedStatement pstmt;
			ResultSet rs;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");
					
		    stmt=con.createStatement();
			rs = stmt.executeQuery("SELECT * from sqbiao order  by  zfjf DESC");
			
			while(rs.next())
			{
				
			String bumenhf1 = rs.getString("bumensq");
			int zchf1= rs.getInt("zcsq");
			String namhf1=rs.getString("name");
			int numhf1= rs.getInt("numsq");
			int ymjhf1= rs.getInt("mjsq");
			int zfjf1=rs.getInt("zfjf");
						   
			   
			    pstmt=con.prepareStatement("INSERT INTO tjsqbiao("
			    
				+ "bumensq,zcsq,name,numsq,mjsq,zfjf) VALUES(?,?,?,?,?,?)");
				pstmt.setString(1,bumenhf1);
				pstmt.setInt(2,zchf1);
				pstmt.setString(3,namhf1);
				pstmt.setInt(4,numhf1);
				pstmt.setInt(5,ymjhf1);
				pstmt.setInt(6,zfjf1);
				pstmt.executeUpdate();
				
			
 		}
 		
           
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
	}
}


class fenfang{
	public fenfang(){
			try {
				
			int i=0;
			Statement stmt;
        	PreparedStatement pstmt;
        	PreparedStatement pstmt2;
			ResultSet rs;
			ResultSet rs1;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");

			System.out.println("URL: " + url);
			System.out.println("Connection: " + con);
			
			
		    stmt=con.createStatement();
			rs = stmt.executeQuery("SELECT * from tjsqbiao ");
			
			while(rs.next())
			{
			String yffbm=rs.getString("bumensq");
			String yffzc=rs.getString("zcsq");
			String yffnam=rs.getString("name");
			int yffnum=rs.getInt("numsq");
			int yffmj= rs.getInt("mjsq");
			int yffjf= rs.getInt("zfjf");
			
	   
			    
			    	
			    rs1=stmt.executeQuery("select * from kfwenjian where mianj='"+yffmj+"'   and zdjifen<'"+yffjf+"'");
			    
			     
			    while(rs1.next()){
			    	
			    	i++;
			    	}
			  
			//    int  yfffh=rs1.getInt("fangh");
			 //	int yffmji=rs1.getInt("mianj");
			  //	int zdjf=rs1.getInt("zdjifen");
		        if(i>0){
		        rs1.next();
		        int  yfffh=rs1.getInt("fangh");
			    pstmt=con.prepareStatement("INSERT INTO yffwenjian ( name,bumen,zc,num,zffs,fangh,mianj) VALUES(?,?,?,?,?,?,?)");
				pstmt.setString(1,yffnam);
				pstmt.setString(2,yffbm);
				pstmt.setString(3,yffzc);
				pstmt.setInt(4,yffnum);
				pstmt.setInt(5,yffjf);
				pstmt.setInt(6,yfffh);
				pstmt.setInt(7,yffmj);
				pstmt.executeUpdate();
				
				String sql="delete from tjsqbiao where bumensq=? and name=?";
				PreparedStatement pstmt1=con.prepareStatement(sql);
				pstmt1.setString(1,yffbm);
				pstmt1.setString(2,yffnam);
				pstmt1.executeUpdate(); 
				}
				else if(i==0){
					break;
				}
				
				
			
 		}


           
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
		
	}
}


class dfsqbiao 
{	         	
	public dfsqbiao() 
	{
	String bmd1=	huanfangFrame.bmd;
	String zcd1=	huanfangFrame.zcd;
	String numd1=    huanfangFrame.numd;
	String yfhd1=	huanfangFrame.yfhd;
	String ymjd1=	huanfangFrame.ymjd;
	String yqmjd1=	huanfangFrame.yqmjd;
			
		try {
			Statement stmt;
        	PreparedStatement pstmt;
			ResultSet rs;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");
		
			
			pstmt=con.prepareStatement("INSERT INTO dfbiao ("
				+ "bumendf,zcdf,numdf,zfjf,yfmj,yfangh,yqmj) VALUES(?,?,?,?,?,?,?)");
			String dfbm=bmd1;
			try{
			
			Double dfzc=Double.parseDouble(zcd1);
			Double dfnum=Double.parseDouble(numd1);
			Double dfymj=Double.parseDouble(ymjd1);
			Double dfyfh=Double.parseDouble(yfhd1);
			Double dfyqmj=Double.parseDouble(yqmjd1);
			Double dfzfjf=dfzc*dfnum;
				pstmt.setString(1,dfbm);
				pstmt.setDouble(2,dfzc);
				pstmt.setDouble(3,dfnum);
				pstmt.setDouble(4,dfzfjf);
				pstmt.setDouble(5,dfymj);
				pstmt.setDouble(6,dfyfh);
				pstmt.setDouble(7,dfyqmj);
				
			pstmt.execute();
	}catch(NumberFormatException q)
		{
			q.printStackTrace();
		}
				   
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
	}
}


class dfbiao{
	public dfbiao(){
			try {
			Statement stmt;
        	PreparedStatement pstmt;
			ResultSet rs;
			ResultSet rs1;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");

			System.out.println("URL: " + url);
			System.out.println("Connection: " + con);
			
		    stmt=con.createStatement();
			rs = stmt.executeQuery("SELECT * from dfbiao");
			
			while(rs.next())
			{
			String yffbm=rs.getString("bumensq");
			String yffzc=rs.getString("zcsq");
			String yffnam=rs.getString("name");
			int yffnum=rs.getInt("numsq");
			int yffmj= rs.getInt("mjsq");
			int yffjf= rs.getInt("zfjf");
			
			    rs1=stmt.executeQuery("select fangh,mianj,zdjifen from kfwenjian where  zdjifen<'"+yffjf+"' and mianj='"+yffmj+"'");
			   while(rs1.next()){
			   
			    int yfffh=rs1.getInt("fangh");
			 	int yffmji=rs1.getInt("mianj");
			  	int zdjf=rs1.getInt("zdjifen");
			  
  
			    pstmt=con.prepareStatement("INSERT INTO yffwenjian ("
			    
				+ "name,bumen,zc,num,zffs,fangh,mianj) VALUES(?,?,?,?,?,?,?)");
				pstmt.setString(1,yffnam);
				pstmt.setString(2,yffbm);
				pstmt.setString(3,yffzc);
				pstmt.setInt(4,yffnum);
				pstmt.setInt(5,yffjf);
				pstmt.setInt(6,yfffh);
				pstmt.setInt(7,yffmji);
				pstmt.executeUpdate();
			}
 		}


           
			con.close();	//关闭与数据库的连接
		}catch( Exception e ) {
			e.printStackTrace();
		}
		
	}
}


class deletesq{
	public deletesq(){
		
			try {
	        
            PreparedStatement pstmt;
			ResultSet rs;
			
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

			String url   = "jdbc:odbc:AADSN";

			Connection con = DriverManager.getConnection (url,"System","sys");

            pstmt=con.prepareStatement("delete from sqbiao;");
		
			pstmt.executeUpdate();
			con.close();
			}
			
		catch( Exception e ) {
			e.printStackTrace();
		}
	}
	}