JDBC连接数据库步骤

来源：互联网发布：我要请运营淘宝的编辑：程序博客网时间：2024/05/22 02:17
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();    }}
0 0