天天看点

ip猛刷访问

发现url不带参数

    public void insertIprecord(String ip,String url,String param) throws SQLException

    {

    JdbcDaoOperate jdbcDaoOperate = new JdbcDaoOperate();

    Connection con = jdbcDaoOperate.getConnection();

PreparedStatement pIdsm = con.prepareStatement("insert into t_iprecord ( ID,IPADDRESS,ACCESSTIME,URL,URLPARAM) VALUES ('"+CreateGUID.createGuId()+"','"+ip+"',to_char(sysdate,'YYYY-MM-DD HH24:MI:SS'),'"+url+"','"+param+"')");

ResultSet rIdsm = pIdsm.executeQuery();

jdbcDaoOperate.close(con, pIdsm, rIdsm);

    }

继续阅读