jdbc连接mysql数据库

先下载一个mysql的驱动器：（我下的是mysql-connector-java-3.1.11-bin.jar）
将它放到java\lib目录下
在环境变量的CLASSPATH里添加该类（%JAV_HOMG%\lib\mysql-connector-java-3.1.11-bin.jar)
出测试该段代码即可：
import java.net.URL;
import java.sql.*;
public class sqlTest {
 public static void main(String[] args) {
    try{
  String Driver="org.gjt.mm.mysql.Driver";
  String URL="jdbc:mysql://localhost:3306/jietest";
  String user="root";
  String password="2008051082";
  
  Connection con=null;
  Statement sm=null;
  ResultSet rs=null;
  
   Class.forName(Driver);
   con=DriverManager.getConnection(URL,user,password);
   
   String sql="insert into info values('yating','2008052231','13632355056','3','3','2','3');";
   sm=con.createStatement();
   sm.execute(sql);
   String sql2="select * from info";
   rs=sm.executeQuery(sql2);
   while(rs.next()) {
    System.out.println(rs.getString("name")+" "+
    rs.getString("id"));
   }
   System.out.println("Create successfully!");
   sm.close();
   con.close();
  }catch(SQLException ex) {
   System.out.println("\n***SQLException caught ***\n");
   while(ex!=null) {
    System.out.println("SQLState:"+ex.getSQLState());
    System.out.println("Message:"+ex.getMessage());
    System.out.println("Vendor:"+ex.getErrorCode());
    ex=ex.getNextException();
    System.out.println("");
   }
  }catch(java.lang.Exception ex) {
   ex.printStackTrace();
  }
 }
}