frame1.java~7~

简单的MYSQL数据库连接实现

package jdbctext;

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.sql.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTable;
import java.awt.Rectangle;
import java.util.Vector;
import java.sql.Connection;
import java.sql.DriverManager;
import javax.swing.table.JTableHeader;
/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class Frame1 extends JFrame {
    JPanel contentPane;
    JTable jTable1;
    public Connection con;
    public Statement s;
    public ResultSet rs;
    public ResultSetMetaData n;
    Vector x=new Vector();
    public Vector y=new Vector();
    public Vector z=new Vector();
    public Frame1() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }
    public void classopen(){
        try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}catch(ClassNotFoundException e){
            System.out.println(e);
        }
    }
    public void open() throws SQLException {
       con= DriverManager.getConnection("jdbc:odbc:suntext");
       s=con.createStatement();
       rs=s.executeQuery("select * from stuinfo");
       n=rs.getMetaData();
    }
    public void close() throws SQLException {
        rs.close();
        s.close();
        con.close();
    }
    public void select() throws SQLException {
        while(rs.next()){
            for(int i=1;i<=4;i++){
                x.add(rs.getString(i));
            }
            y.add(x);
            x=new Vector();
        }
    }
    public void selecttitle() throws SQLException {
        for(int i=1;i<=4;i++){
            z.add(n.getColumnClassName(i));
            }
    }
    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        setSize(new Dimension(400, 300));
        setTitle("Frame Title");
        classopen();
        open();
        select();
        close();
        classopen();
        open();
        selecttitle();
        close();
        jTable1=new JTable(y,z);
        JTableHeader JTableHeader1=jTable1.getTableHeader();
        JTableHeader1.setBounds(new Rectangle(0, 0, 402, 30));
        jTable1.setTableHeader(JTableHeader1);
        jTable1.setBounds(new Rectangle( -2, 36, 404, 273));
        contentPane.add(jTable1);
        contentPane.add(JTableHeader1);
    }
}