I'm trying to connect directly to SQL Server for testing, but at the time of the "Register" test by clicking the button, the app simply hangs, is there something wrong with the code?
package br.com.agemstar.testesql;
import android.os.StrictMode;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.TextView;
import android.widget.Toast;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
public class MainActivity extends AppCompatActivity {
EditText edtnome, edtend;
Button carregar;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
edtnome = (EditText)findViewById(R.id.edtNome);
edtend = (EditText)findViewById(R.id.edtEnd);
carregar = (Button) findViewById(R.id.btnN1);
carregar.setOnClickListener(new View.OnClickListener(){
@Override
public void onClick(View v){
cadastrarUsuario();
}
});
}
public Connection conexaoBD(){
Connection connection = null;
try{
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
connection = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.169;databaseName=ANDROID_SQL;user=sa;password=@dm1n102030;");
}catch (Exception e){
Toast.makeText(getApplicationContext(),e.getMessage(),Toast.LENGTH_SHORT).show();
}
return connection;
}
public void cadastrarUsuario(){
try{
PreparedStatement pst = conexaoBD().prepareStatement("insert into usuarios values (?,?)");
pst.setString(1,edtnome.getText().toString());
pst.setString(2,edtend.getText().toString());
pst.executeUpdate();
Toast.makeText(getApplicationContext(),"REGISTRO CONCLUIDO",Toast.LENGTH_SHORT).show();
} catch (SQLException e) {
Toast.makeText(getApplicationContext(),e.getMessage(),Toast.LENGTH_SHORT).show();
}
}
}