Java JDBC访问MySql

1.把 mysql-connector-java-5.0.3-bin.jar放到%JAVA_HOME%/jre/lib/ext下
2.访问类：

package mysqldb;

import java.sql.*;

public class MysqlCon {
 
 private static String DriverName = "org.gjt.mm.mysql.Driver";
 private String dbURL = "jdbc:mysql://localhost/test";
 private String dbuser = "root";
 private String dbpassword = "";
 private Connection conn;
 private Statement stmt;
 private ResultSet rs;
 public MysqlCon(){
  try {
   Class.forName(DriverName).newInstance();
   conn = DriverManager.getConnection(dbURL,dbuser,dbpassword);
   stmt = conn.createStatement();
   String sql = "select * from worker";
   rs = stmt.executeQuery(sql);
   while(rs.next()){
    System.out.println(rs.getString(1));
   }
  } catch (InstantiationException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  } catch (IllegalAccessException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  } catch (ClassNotFoundException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  } catch (SQLException e) {
   // TODO 自动生成 catch 块
   e.printStackTrace();
  }
  
 }
}

 

package interphase;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Vector;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.AbstractTableModel;

import mysqldb.MysqlCon;

public class ShowRS {
 private AbstractTableModel atm;
 private JTable jtable;
 private Vector vector;
 private JScrollPane jsp;
 private String title[]={"职工号","职工名","性别","出生日期","工资"};
 private MysqlCon mysqlcon;
 private JFrame frame;
 
 public ShowRS(){
  vector = new Vector();
  atm = new AbstractTableModel(){
   public int getColumnCount() {
    return title.length;
   }

   public int getRowCount() {
    return vector.size();
   }

   public Object getValueAt(int rowIndex, int columnIndex) {
    if(!vector.isEmpty())
     return ((Vector)vector.elementAt(rowIndex)).elementAt(columnIndex);
    else
     return null;
   }
   //取得单元格中的属性值
   public String getColumnName(int columnIndex){
    return title[columnIndex];
   }
   //数据模型不可编辑，该方法设置为空
   public void setValueAt(){}
   //取得列所属对象类
   public Class getCoumnClass(int c){
    return getValueAt(0,c).getClass();
   }
   //设置单元格不可编辑，为缺省实现
   public boolean isCellEditable(int row,int column){
    return false;
   }};
   jtable = new JTable(atm);
   jtable.setToolTipText("显示全部查询结果");
   jtable.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
   jtable.setCellSelectionEnabled(false);
   jtable.setShowVerticalLines(true);
   jtable.setShowHorizontalLines(true);
   jsp = new JScrollPane(jtable);
   mysqlcon = new MysqlCon();
   vector.removeAllElements();
   atm.fireTableDataChanged();
   try {
    ResultSet rs = mysqlcon.getResultSet();
    while(rs.next()){
     Vector rec_vector = new Vector();
     rec_vector.addElement(rs.getString(1));
     rec_vector.addElement(rs.getString(2));
     rec_vector.addElement(rs.getString(3));
     rec_vector.addElement(rs.getDate(4));
     rec_vector.addElement(new Float(rs.getFloat(5)));
     vector.addElement(rec_vector);
    }
   } catch (SQLException e) {
    // TODO 自动生成 catch 块
    e.printStackTrace();
   }
   atm.fireTableDataChanged();
   frame = new JFrame();
   frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
   frame.add(jsp);
   frame.setSize(400,300);
   frame.setVisible(true);
 } 
}