newsbox.java

本系统是鞋厂管理系统

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

//厂长获取员工意见的面版
public class NewsBox extends JFrame implements ActionListener
{
	DBConnection conn=new DBConnection();
	Connection con=conn.getConn();
	int i,j,temp;
	
    public NewsBox()
    {
    	setTitle("意见箱");
    	setLocation(300,300);
    	setSize(400,300);
    	String sql="select * from suggest";
    	Container c=getContentPane();
    	JPanel jp=new JPanel();
    	JPanel pb=new JPanel();
    	JButton b=new JButton("退出");
        try
        {
        	Statement stmt=con.createStatement();
        	ResultSet rs=stmt.executeQuery(sql);
        	rs.last();
        	temp=rs.getInt(1);
        	jp.setLayout(new GridLayout(temp+1,1,5,5));
        	for(i=1;i<=temp;i++)
        	{
        		JLabel jlb1=new JLabel(rs.getString(3));
        		jlb1.setForeground(Color.green);
                
        		JLabel jlb2=new JLabel(rs.getString(2));
        		JPanel p=new JPanel();
        		p.add(jlb1);
        		p.add(jlb2);
        		
        		if(i%2==1)//奇数时为CYAN色
        		{
        			p.setBackground(Color.CYAN);
        		}
        		else p.setBackground(Color.orange);//偶数为orange色
        		jp.add(p);
        		rs.previous();
        	}
        	pb.add(b);
        	pb.setBackground(Color.gray);
        	jp.add(pb);
        }
        catch(SQLException ex){}
        JScrollPane s=new JScrollPane(jp);
        c.add(s);
        
        b.addActionListener(this);
    }
    
    public void actionPerformed(ActionEvent e)
	{
    	if("退出".equals(e.getActionCommand()))
    	{
    		setVisible(false);
    	}
	}
}