JDBC连接数据库步骤

package com.pb.news.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.Timestamp;

public class NewsDao {
    // 查询新闻信息
    public void getNewsList(){
        //1.加载驱动
        Connection connection=null;
        Statement st =null;
        ResultSet rs=null;
        try {
            Class.forName("com.mysql.jdbc.Driver");
            //2.获取数据库连接
            connection=DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/news", "root", "Zhouzhi1");
            //3.获取Statement执行sql语句
            String sql="select * from news_detail;";
             st =connection.createStatement();
             rs=st.executeQuery(sql);
            //4.处理sql执行结果
            while(rs.next()){
                int id=rs.getInt("id");
                int categoryId=rs.getInt("categoryId");
                String title=rs.getString("title");
                String summary=rs.getString("summary");
                String content=rs.getString("content");
                String author=rs.getString("author");
                Timestamp createDate = rs.getTimestamp("createDate");
                System.out.println("id:"+id+"\t"+"title"+title+"\t"+"summary:"+summary+"\t author:"+author+"\t content:"+content+"\t createDate:"+createDate);

            }
        } catch (ClassNotFoundException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        } catch (SQLException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }finally{
            try {
                //5.释放资源
                rs.close();
                st.close();
                connection.close();
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }

        }

    }
    public static void main(String[] args) {
        NewsDao newsDao=new NewsDao();
        newsDao.getNewsList();

    }
}