dangyuetixing.java

业务信息管理平台,适用于企业内部信息管理,合同管理

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.sql.*;
import java.util.Date;
import java.util.Calendar;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import javax.swing.*;
import javax.swing.table.*;

public class Dangyuetixing extends JFrame {

   private DefaultTableModel philosophers;
   private JTable table;

   // PhilosophersJTable constructor
   public Dangyuetixing()
   {
      super( "本月提醒信息" );

      // create a DefaultTableModel to store philosophers
      philosophers = new DefaultTableModel();      
      
      // add Columns to DefaultTableModel
      philosophers.addColumn( "提醒时间" );
      philosophers.addColumn( "提醒内容" );
      
	  ResultSet resSet;	
      ResultSetMetaData metaData;
      Connection dbConn;
      Statement stat;	
	  String sql3;
	
		try { 
			Class.forName(Yewu.forName);
   			dbConn=DriverManager.getConnection(Yewu.jdbc);
			
			Date   date   =   new   Date();   
  			SimpleDateFormat   f   =   new   SimpleDateFormat("yyyy-MM");   
  			String   st   =   f.format(date);
			StringBuffer sql=new StringBuffer();
		    sql.append("select tixingtime,tixingbeizhu from tixingTable where convert(nvarchar(7),tixingtime,121) like '").append(st).append("%' order by tixingtime asc");
   		
 			stat=dbConn.createStatement();
 		    resSet=stat.executeQuery(sql.toString());
 		   
 			while(resSet.next()){
 				Vector vec=new Vector();
 				vec.add(resSet.getString("tixingtime"));//0
 				vec.add(resSet.getString("tixingbeizhu"));//1
 				philosophers.addRow( vec.toArray() );

 			}	
 		
 			stat.close();
 			dbConn.close();    
       }catch(Exception ex){
       		System.out.println(ex);
       }

      table = new JTable( philosophers ); 
     
      
      Container container = getContentPane();       
      container.add( new JScrollPane( table ),BorderLayout.CENTER );      
      	int iii=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()); 
   		
		if(iii==800){
			setBounds(150,150,540,275);
			
		}else{
			
			setBounds(340,220,540,300);
		}
     
      	setVisible( true );
      
      	this.addWindowListener(new WindowAdapter(){
        	public void WindowClosing(WindowEvent e){
               	
            
                  System.exit(0);
                  
               }
            });  
      
   } // end PhilosophersJTable constructor

   // execute application
 
}