• 使用示例
• DBCP连接池
• 结语

使用示例

public class demo {
    static Connection con = null;
    static Statement st = null;
    static ResultSet rs = null;

    public static void main(String[] args) {
        try {
            String url = "jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false";
            String username = "root";
            String password = "123";
                        
            con = DriverManager.getConnection(url, username, password);
            st = con.createStatement();
                        
            /* 
            * 插入操作
            * String sql = "insert into event values (\"xiaohuang\",\"1920-12-09\",\"birthday\",\"First birthday\");";
            * int i = st.executeUpdate(sql);
            * 
            * 
            * 查找操作
            * String sql = "SELECT * FROM test.event;";
            * rs = st.executeQuery(sql);
            * while(rs.next()) {
            *       System.out.println(rs.getObject("petname") +"   "+ rs.getObject("eventdate")+ "   " +rs.getObject("eventtype")+"   "+rs.getObject("remark"));
            * }
            * 
            * 
            * 传递sql参数
            * String sql = "SELECT * FROM test.event where petname=?;";
            * PreparedStatement psql = con.prepareStatement(sql);
            * psql.setString(1, "xiaohuang");
            * rs = psql.executeQuery();
            * while(rs.next()) {
            *       System.out.println(rs.getObject("petname") +"   "+ rs.getObject("eventdate")+ "   " +rs.getObject("eventtype")+"   "+rs.getObject("remark"));
            * } 
            * */
                        
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                rs.close();
                st.close();
                con.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}public cl