Advertisement
Guest User

Untitled

a guest
Nov 6th, 2017
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.20 KB | None | 0 0
  1. private static final String MySQLroot = "jdbc:mysql://mysql.dank.business/dintprog_debug?useSSL=false";
  2.  
  3.     private static final String
  4.             QUERY_GET_ZIPS     = "SELECT * FROM zips WHERE NOT EXISTS (SELECT * FROM processed where zips.id=processed.id) ORDER BY 'id' ASC",
  5.             QUERY_INSERT       = "INSERT INTO processed VALUES (?,?)",
  6.             QUERY_INSERT_STATS = "INSERT INTO cg1 VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?',
  7.  
  8.    private static Connection conn;
  9.    private static Statement stmt;
  10.  
  11.    public static void progress() throws IOException{
  12.        Files.write(Paths.get("progress.out"), (""+(++progress)).getBytes());
  13.    }
  14.  
  15.    public static void main(String[] args){
  16.        try {
  17.            Class.forName("com.mysql.jdbc.Driver").newInstance();
  18.  
  19.            conn = DriverManager.getConnection(MySQLroot, "ssodelta", "?");
  20.            stmt = conn.createStatement();
  21.  
  22.            PreparedStatement stm = conn.prepareStatement(QUERY_INSERT);
  23.            stm.setInt(1, id);
  24.            stm.setLong(2, millis);
  25.            stm.execute();
  26.            
  27.        } catch(Exception e){
  28.            e.printStackTrace();
  29.        }
  30.    }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement