Guest User

Untitled

a guest
Jan 16th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.04 KB | None | 0 0
  1. public class InsertOneQuery extends Thread {
  2.  
  3. private Connection mConnection = null;
  4. private Statement mStatement = null;
  5.  
  6. @Override
  7. public void run() {
  8. super.run();
  9.  
  10. Looper.prepare();
  11. getDB();
  12. Looper.loop();
  13. }
  14.  
  15. public void getDB() {
  16. mConnection = MariaDBProxy.connectJDBC(); //DB CONNECT
  17.  
  18. try {
  19. mStatement = mConnection.createStatement();
  20. mStatement.executeQuery("use be");
  21.  
  22. String insertQuery = "INSERT INTO table"
  23. + "(name, number, age");
  24. + "values"
  25. + "(?, ?, ?)";
  26.  
  27. PreparedStatement statement = mConnection.prepareStatement(insertQuery);
  28. statement.setString(1, "cho");
  29. statement.setString(2, "111");
  30. statement.setString(3, "18");
  31.  
  32. int ret = statement.executeUpdate();
  33. } catch (Exception e) {
  34. e.printStackTrace();
  35. } finally {
  36. try {
  37. mConnection.close();
  38. } catch (Exception e) {
  39. }
  40. }
  41. }
  42. }
Add Comment
Please, Sign In to add comment