Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public class InsertOneQuery extends Thread {
- private Connection mConnection = null;
- private Statement mStatement = null;
- @Override
- public void run() {
- super.run();
- Looper.prepare();
- getDB();
- Looper.loop();
- }
- public void getDB() {
- mConnection = MariaDBProxy.connectJDBC(); //DB CONNECT
- try {
- mStatement = mConnection.createStatement();
- mStatement.executeQuery("use be");
- String insertQuery = "INSERT INTO table"
- + "(name, number, age");
- + "values"
- + "(?, ?, ?)";
- PreparedStatement statement = mConnection.prepareStatement(insertQuery);
- statement.setString(1, "cho");
- statement.setString(2, "111");
- statement.setString(3, "18");
- int ret = statement.executeUpdate();
- } catch (Exception e) {
- e.printStackTrace();
- } finally {
- try {
- mConnection.close();
- } catch (Exception e) {
- }
- }
- }
- }
Add Comment
Please, Sign In to add comment