Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private static final String MySQLroot = "jdbc:mysql://mysql.dank.business/dintprog_debug?useSSL=false";
- private static final String
- QUERY_GET_ZIPS = "SELECT * FROM zips WHERE NOT EXISTS (SELECT * FROM processed where zips.id=processed.id) ORDER BY 'id' ASC",
- QUERY_INSERT = "INSERT INTO processed VALUES (?,?)",
- QUERY_INSERT_STATS = "INSERT INTO cg1 VALUES ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?',
- private static Connection conn;
- private static Statement stmt;
- public static void progress() throws IOException{
- Files.write(Paths.get("progress.out"), (""+(++progress)).getBytes());
- }
- public static void main(String[] args){
- try {
- Class.forName("com.mysql.jdbc.Driver").newInstance();
- conn = DriverManager.getConnection(MySQLroot, "ssodelta", "?");
- stmt = conn.createStatement();
- PreparedStatement stm = conn.prepareStatement(QUERY_INSERT);
- stm.setInt(1, id);
- stm.setLong(2, millis);
- stm.execute();
- } catch(Exception e){
- e.printStackTrace();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement