java连接mysql数据库

1.导包

   下载mysql-connector-java-5.0.4-bin.jar  地址http://zhidao.baidu.com/share/535db25ced332799194c2991e80e5180.html

2.加载connector驱动

   Class.forName("com.mysql.jdbc.driver").newinstance();

   Connection ct = DriverManager.getConnection("jdbc:mysql://192.168.0.85:3306/database?user=user&password=password");

3.书写sql语句

   String sql = "select abc from table where id=1";

4查询数据库

   PreparedStatement ps = (PreparedStatement) ct.preparedStatement(sql);

5.得到查询结果集合

  ResultSet rs = ps.executeQuery();

 完整实例

  

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;


public class text {


public static void main(String [] orgs){
PreparedStatement sm = null;
Connection ct = null;
ResultSet rs = null;
   try{
    Class.forName("com.mysql.jdbc.Driver").newInstance();
    ct = DriverManager.getConnection("jdbc:mysql://192.168.0.85:3306/hwwl?user=root&password=sida123");
    String sql = "select rkd_code from hwwl.ord_rkd where rkd_id=100000000000062";
    sm = (PreparedStatement)ct.prepareStatement(sql);
    rs = sm.executeQuery();
    while(rs.next()){
    String code = rs.getString("rkd_code");
    System.out.println(code);
    }
   }catch(Exception e){
    e.printStackTrace();
    }finally{
    try{
    rs.close();
    sm.close();
    ct.close();
    }catch(Exception e){
    e.printStackTrace();
    }
    }
}
}