Java:JDBC连接数据库

package tk.bigfeng.www;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.*;

import com.mysql.jdbc.PreparedStatement;

public class SqlDemo {
    static String sql = null;
    static DBhelp db = null;
    static ResultSet ret = null;

    public static void main(String[] args) throws SQLException {
        // TODO Auto-generated method stub
        sql = "select * from stuinfo";
        db = new DBhelp(sql);
        try{

            ret = db.pst.executeQuery();
            while(ret.next()){
                String id = ret.getString(1);
                String fname = ret.getString(2);
                String lname = ret.getString(3);
                String age = ret.getString(4);

                System.out.println(id + "\t" + fname + "\t" + lname + "\t" + age );     
            }
            ret.close();
            db.close();
        }catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }


    }

}

class DBhelp{
    private static final String url = "jdbc:mysql://127.0.0.1/YAPHONE?useUnicode=true&characterEncoding=utf-8&useSSL=false";
    private static final String user = "root";
    private static final String password = "19891226";

    public Connection conn = null;
    public java.sql.PreparedStatement pst = null;

    public DBhelp(String sql){
        try{
            conn = DriverManager.getConnection(url, user, password);
            pst = conn.prepareStatement(sql);
        }catch(SQLException e){
            e.printStackTrace();
        }
    }
    public void close(){
        try{
            conn.close();
            pst.close();
        }catch (Exception e) {
            // TODO: handle exception
            e.printStackTrace();
        }
    }

}

输出：

1   Jim Green   18
2   Tom Cat 13
3   Lily    Zhou    19
4   Ning    Li  33