Advertisement
Guest User

Untitled

a guest
Mar 26th, 2016
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. public class register extends AppCompatActivity {
  2.  
  3. EditText username, password;
  4. Button registartion;
  5.  
  6. @Override
  7. protected void onCreate(Bundle savedInstanceState) {
  8. super.onCreate(savedInstanceState);
  9. setContentView(R.layout.activity_register);
  10. }
  11.  
  12. private Connection getConnection()
  13. {
  14.  
  15. String host = "jdbc:mysql://jdbc.fmc.me.uk:3306/db_ben";
  16. String u = "user_ben";
  17. String p = "******";
  18. try
  19. {
  20. Connection con = DriverManager.getConnection(host, u, p);
  21. return con;
  22. } catch (SQLException e)
  23. {
  24. // TODO Auto-generated catch block
  25. e.printStackTrace();
  26. }
  27. return null;
  28. }
  29.  
  30. private boolean registerUser(){
  31.  
  32. //Get username
  33. EditText regUsernameBox = (EditText) findViewById(R.id.RegUsername);
  34. String regUsernameStr = regUsernameBox.getText().toString();
  35.  
  36. //Get password
  37. EditText regPasswordBox = (EditText) findViewById(R.id.RegPassword);
  38. String regPasswordStr = regPasswordBox.getText().toString();
  39.  
  40. System.out.println(regUsernameStr);
  41. System.out.println(regPasswordStr);
  42.  
  43. int i = 0;
  44. Connection con = getConnection();
  45. try {
  46. PreparedStatement pst = con.prepareStatement("insert into users values(?,?)");
  47. pst.setString(1, regUsernameStr);
  48. pst.setString(2,regPasswordStr);
  49. i = pst.executeUpdate();
  50. } catch (SQLException e) {
  51. e.printStackTrace();
  52. }
  53. if(i>0)
  54. return true;
  55. return false;
  56. }
  57.  
  58. public void buttonClick() {
  59. final Button registerUsers = (Button) findViewById(R.id.bRegister);
  60.  
  61. registerUsers.setOnClickListener(new View.OnClickListener() {
  62. @Override
  63. public void onClick(View v) {
  64.  
  65. registerUser();
  66. }
  67. });
  68. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement