家庭/个人应用

开发平台：

Java

time.java：源码内容

							package src;
import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;
public class time extends JFrame
{
	private static final long serialVersionUID = 1L;
	Connection con;
    Statement sql;
    ResultSet rs;
	JTable t;
	JButton jb;
	Object o[][];
	Object day[]={"","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"};
	JLabel jl;
	int rows=5;
	JPanel p1,p2;
	Font font=new Font("Monospaced" ,Font.BOLD,20);
	time(String s)
	{
		setTitle(s);
		jb=new JButton("退出");
		jb.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				dispose();
				System.exit(0);
			}
			
		});
		jl=new JLabel("日程时间表");
		jl.setForeground(Color.red);
		jl.setFont(font);
		jl.setHorizontalAlignment(JLabel.CENTER); 
		p1=new JPanel();
		p1.add(jl);
		p2=new JPanel();
		p2.add(jb);
		o=new Object[5][8];
		t=new JTable(o,day);
		t.setRowHeight(35);
		getContentPane().removeAll();
		add(p1,BorderLayout.NORTH);
		add(p2,BorderLayout.SOUTH);
		add(new JScrollPane(t),BorderLayout.CENTER);
		o[0][0]="1~2";
		o[1][0]="3~4";
		o[2][0]="5~6";
		o[3][0]="7~8";
		o[4][0]="9~10";
		try
    	{
			Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
		}
		catch(ClassNotFoundException e1){System.out.println(""+e1);}
		try
		{
			String uri="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatebaseName=design";
			String user="chenzhi";
			String password="chenzhi";
		    con=DriverManager.getConnection(uri,user,password);
			sql= con.createStatement();
			rs=sql.executeQuery("SELECT *FROM richeng");
			int i=0;
			while(rs.next()&&i<5)
			{
				o[i][1]=rs.getString(1);
				o[i][2]=rs.getString(2);
				o[i][3]=rs.getString(3);
				o[i][4]=rs.getString(4);
				o[i][5]=rs.getString(5);
				o[i][6]=rs.getString(6);
				o[i][7]=rs.getString(7);
				i++;
			}
			con.close();
		}
		catch(SQLException e1)
		{
			System.out.println(""+e1);
		}
		
		validate();
		setResizable(false);
		setBounds(500, 300, 800, 302);
		setVisible(true);
		setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
	}
}

						