Guest User

Untitled

a guest
Oct 3rd, 2018
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.66 KB | None | 0 0
  1. package...
  2.  
  3. imports
  4.  
  5. public class Cadastro extends AppCompatActivity
  6. {
  7. EditText txtNome, txtEmail, txtSenha, txtRepeteSenha;
  8. Button btnCadastrar;
  9. ProgressBar progressBar;
  10. ConnectionClass connectionClass;
  11.  
  12. @Override
  13. protected void onCreate (Bundle savedInstanceState)
  14. {
  15. super.onCreate(savedInstanceState);
  16. setContentView(R.layout.activity_cadastro);
  17. connectionClass = new ConnectionClass();
  18. txtNome = findViewById(R.id.name);
  19. txtEmail = findViewById(R.id.email);
  20. txtSenha = findViewById(R.id.senha);
  21. txtRepeteSenha = findViewById(R.id.key_again);
  22. btnCadastrar = findViewById(R.id.cadastrar);
  23. progressBar = findViewById(R.id.progressBar);
  24.  
  25. btnCadastrar.setOnClickListener(new View.OnClickListener(){
  26. @Override
  27. public void onClick (View v){
  28. salvarBanco();
  29. }
  30. });
  31. }
  32.  
  33. public Connection connectionBD(){
  34. Connection connection = null;
  35. String url = "jdbc:jtds:sqlserver://meu_ip:1433;databaseName=meu_banco;user=meu_user_banco;password=minha_senha_banco;";
  36. try {
  37. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  38. StrictMode.setThreadPolicy(policy);
  39. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  40. connection = DriverManager.getConnection(url);
  41. Log.e("Script", "teste");
  42. Toast.makeText(getApplicationContext(),"Sucesso!",Toast.LENGTH_SHORT).show();
  43. }catch (Exception e){
  44. Toast.makeText(getApplicationContext(),e.getMessage(),Toast.LENGTH_SHORT).show();
  45. }
  46. return connection;
  47. }
  48.  
  49. public void salvarBanco(){
  50. String query = "INSERT INTO Usuario(email, nome, senha) VALUES(?,?,?)";
  51. try{
  52. PreparedStatement preparedStatement = connectionBD().prepareStatement(query);
  53. preparedStatement.setString(1,txtEmail.getText().toString());
  54. preparedStatement.setString(2,txtNome.getText().toString());
  55. preparedStatement.setString(3,txtSenha.getText().toString());
  56. preparedStatement.executeUpdate();
  57. }catch (Exception e){
  58. Toast.makeText(getApplicationContext(),e.getMessage(),Toast.LENGTH_SHORT).show();
  59. }
  60. }
  61. }
  62. 10-03 17:13:42.954 27329-27329/com.example.paulo.apptecnico E/AndroidRuntime: FATAL EXCEPTION: main
  63. Process: com.example.paulo.apptecnico, PID: 27329
  64. java.lang.VerifyError: net/sourceforge/jtds/jdbc/TdsCore
  65. at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:359)
  66. at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
  67. at java.sql.DriverManager.getConnection(DriverManager.java:179)
  68. at java.sql.DriverManager.getConnection(DriverManager.java:144)
  69. at com.example.paulo.apptecnico.Cadastro.connectionBD(Cadastro.java:55)
  70. at com.example.paulo.apptecnico.Cadastro.salvarBanco(Cadastro.java:67)
  71. at com.example.paulo.apptecnico.Cadastro$1.onClick(Cadastro.java:41)
  72. at android.view.View.performClick(View.java:4740)
  73. at android.view.View$PerformClick.run(View.java:19383)
  74. at android.os.Handler.handleCallback(Handler.java:733)
  75. at android.os.Handler.dispatchMessage(Handler.java:95)
  76. at android.os.Looper.loop(Looper.java:146)
  77. at android.app.ActivityThread.main(ActivityThread.java:5679)
  78. at java.lang.reflect.Method.invokeNative(Native Method)
  79. at java.lang.reflect.Method.invoke(Method.java:515)
  80. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1291)
  81. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1107)
  82. at dalvik.system.NativeStart.main(Native Method)
Add Comment
Please, Sign In to add comment