JAVA使用JDBC连接MySQL数据库

DBHelper.java

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


public class DBHelper {
    public static final String url="jdbc:mysql://数据库地址";
    public static final String name="com.mysql.jdbc.Driver";
    public static final String user="数据库用户名";
    public static final String password="数据库密码";

    public Connection conn=null;
    public PreparedStatement pst = null; 
    public DBHelper(String sql)
    {
        try {
            Class.forName(name);
            conn=DriverManager.getConnection(url,user,password);
            pst=conn.prepareStatement(sql);

        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }
    }
    public void close()
    {
        try {
            this.conn.close();
            this.pst.close();

        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }
    }
}

实例：

import java.sql.ResultSet;

public class Ten_tuijian {

    static String sql=null;
    static DBHelper db1=null;
    static ResultSet res=null;
    /**
     * @param args
     * 获取10件商品
     */
    public static void main(String[] args) {
        // TODO Auto-generated method stub
        sql="select goods_id,title,price_string,pic_url,parent_market_name,store_num from goods_hz limit 0,10";
        db1=new DBHelper(sql);
        try {
            res=db1.pst.executeQuery();
            while(res.next())
            {

                String goodsId=res.getString(1);
                String title=res.getString(2);
                String price=res.getString(3);
                String picUrl=res.getString(4);
                String parentName=res.getString(5);
                if(parentName.equals("置地国际电商基地"))
                {
                    //System.out.println(1111111);
                    parentName=parentName.replace("置地国际", "");
                }
                String storeNum=res.getString(6);
                System.out.println("<li><a href='http://hz.571xz.com/item.htm?id="+goodsId+"'><img src='"+picUrl+"_220x220.jpg' style='width:180px;'><h2>¥ "+
                price+"<span>"+parentName+storeNum+"</span></h2><p>"+title+"</p></a></li>");
            }
            res.close();  
            db1.close();
        } catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }
    }

}

别忘了导入Connector/J包，下载地址http://www.mysql.com/downloads/connector/j/