java Á¬½ÓmysqlµÄÎÊÌâ,Çó½â.

ÏÂÔص½mysql-connector-java-5.1.12-bin.jarºó·ÅÔÚDÅÌ,ÔÚ»·¾³±äÁ¿ÀïÌí¼ÓÁËclasspath="D:\Program Files\Java\jdk1.6.0_19\lib",»¹ÊdzöÏÖClassNotFoundExceptionÒì³£,´úÂëºÍÒì³£ÈçÏÂ:

import java.sql.*; 
 import java.util.Vector;

 public class test  
 {  
  public static void main (String[] args)  
  {  
Vector<String> results = new Vector<String>();  
  Connection con = null;  
  try  
  {  
  Class.forName("com.mysql.jdbc.Driver").newInstance(); 
  con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","5647382910");
  try{
  Statement st = con.createStatement();
  ResultSet rs = (ResultSet) st.executeQuery("SELECT * from staff");
while (rs.next()) {
String numb = rs.getString("name");
results.addElement(numb); }
st.close();
con.close();
  }
  catch (SQLException s){
  System.out.println("SQL statement is not executed!");
  }
  }
  catch (Exception e){
  e.printStackTrace();
}
  }  
}  

ÔËÐ