guestgui.java

实现了一些关与股票的功能 希望对大家有一些帮助

package gui;

import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;

import model.Conn;

import java.sql.Connection;


public class Guestgui extends JFrame implements ActionListener{

	/**
	 * 
	 */
	 static final long serialVersionUID = 1L;
	 private int i,j;
	 private int rowno,colno;
	 private JTable jt;
	 private JScrollPane js;
	 private ResultSet rs;
	 private Statement sta;
	 private  Object[][] info;
	 private String [] names;
	 private Connection conn;
	 private JButton jb1,jb2;
	 private JPanel jp1,jp2,jp3;
    
	public Guestgui() throws ClassNotFoundException, SQLException {
		
		conn=new Conn().getConnection();
		jp1=new JPanel();
		jp2=new JPanel();
		jp3=new JPanel(new BorderLayout());
		jb1=new JButton("注册");
		jb2=new JButton("退出");
		jb1.addActionListener(this);
		jb2.addActionListener(this);
		
	}
	public void function1() throws Exception
	{
		 sta=conn.createStatement();
		 String sqlstr1="select count(*) from stock";  //取得数据表的记录数和字段数
		  rs=sta.executeQuery(sqlstr1);
		  rs.next(); 
		  rowno=rs.getInt(1);
		  String sqlstr2="select * from stock";
		  rs=sta.executeQuery(sqlstr2);
		  ResultSetMetaData rsmd=rs.getMetaData();
		  colno=rsmd.getColumnCount();
		  
		  String[] names=new String[colno];    
		  for (i=1;i<=colno;i++)
			  names[i-1]=rsmd.getColumnName(i);
		  info=new Object[rowno][];
		  i=0;
		  while (rs.next())
		  {
		   info[i]=new Object[colno];
		   for (j=1;j<=colno;j++)
		   {
		    info[i][j-1]=rs.getObject(j);
		   }
		   i++;
		  }
		  jt=new JTable(info,names);
			js=new JScrollPane(jt);
			jt.setBackground(Color.green);
			jt.setPreferredScrollableViewportSize(new Dimension(550,250));
			
			
			jp1.add(jb1);
			jp1.add(jb2);
			jp2.add(js);
			jp3.add("South",jp1);
			jp3.add("North",jp2);
			this.getContentPane().add(jp3);
			this.setVisible(true);
			this.pack();
			
			this.setBackground(Color.green);
			this.setTitle("欢迎光临我的股票交易系统");
			this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
			this.setResizable(false);
	}

	public void actionPerformed(ActionEvent e) {
		
		if(e.getSource().equals(jb1)){
			this.setVisible(false);
			Reggui rg=new Reggui();
			rg.setVisible(true);
		}
		if (e.getSource().equals(jb2)){
			JOptionPane.showMessageDialog(null,"感谢使用我的系统,欢迎下次光临!");
		}
	}
	

}