JDBC连接MySQL例子

public class MysqlJDBC {  
    //Mysql JDBC 连接驱动  
    private final static String Driver = "com.mysql.jdbc.Driver";  
    //Mysql JDBC url  
    private final static String url = "jdbc:mysql://192.168.1.105/huang";  
    //数据库实例登陆名  
    private final static String username = "root";  
    //数据库登陆密码  
    private final static String password = "root";  
    //连接对象  
    private Connection cnn;  
    //准备执行  
    private PreparedStatement st;  
    //结果集  
    private ResultSet rs;  

    /** 
     * 构造方法 
     * 创建mysql连接 
     */  
    public MysqlJDBC(){  
        try {  
            //读取mysql连接的jar包  
            Class.forName(Driver);  
            //登陆数据库获取连接  
            cnn = DriverManager.getConnection(url, username, password);  
        } catch (Exception e) {  
            System.out.println("连接MYSQL数据库失败");  
            e.printStackTrace();  
        }  
    }  

    public void getAllPersons(){  
        try {  
            StringBuffer sb = new StringBuffer();  
            sb.append("select * from person");  
            //准备执行  
            st = cnn.prepareStatement(sb.toString());  
            //执行查询获得结果  
            rs = st.executeQuery();  
            //打印结果  
            while(rs.next()){  
                //查询的列序号是从1开始  
                System.out.println(rs.getString(1)+"\t"  
                        +rs.getString(2)+"\t"  
                        +rs.getString(3));  
            }  
            System.out.println("查询结束");  
        } catch (Exception e) {  
            System.out.println("查询出错");  
            e.printStackTrace();  
        }  
    } 

    public void close() {  
        try {  
            if (null != rs) {  
                rs.close();  
            }  

            if(null != st){  
                st.close();  
            }  

            if(null != cnn){  
                cnn.close();  
            }  
            System.out.println("关闭成功");  
        } catch (Exception e) {  
            System.out.println("关闭连接失败");  
            e.printStackTrace();  
        }  
    }  
}