package sql;
import java.sql.*;
/**
 * Created by Alex on 02.10.2015.
 */
public class Driver {
    public static void record_to_bd(int num, String arr) {
        try {
            String url = "jdbc:mysql://localhost:3306/storage";
            String user = "storage";
            String pass = "host";
            Connection myConn = DriverManager.getConnection(url, user, pass);
            Statement myStmt = myConn.createStatement();
            ResultSet myRs = myStmt.executeQuery("SELECT * FROM requests1");
            while (myRs.next()) {
                System.out.println(myRs.getString("id") + ", " + myRs.getString("number") +  myRs.getString("array"));
            }
            String insertData = "INSERT INTO requests1 (number, array)" + "VALUES (?, ?)";
            PreparedStatement stmt = myConn.prepareStatement(insertData);
            stmt.setInt(1, num);
            stmt.setString(2, arr);
            stmt.executeUpdate();
        } catch (Exception exc) {
            exc.printStackTrace();
        }
    }
}