Advertisement
Guest User

java SQL error

a guest
Apr 20th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.86 KB | None | 0 0
  1.     public void ConnectToDatabase(){
  2.         try {
  3.      
  4.              // SET CONNECTIONSTRING
  5.              Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  6.              String username = "sa";
  7.              String password = "123";
  8.              Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://SERVER-PC:1433/PRU;user=" + username + ";password=" + password);
  9.      
  10.              Log.w("Connection","open");
  11.              Statement stmt = DbConn.createStatement();
  12.              ResultSet reset = stmt.executeQuery(" select * from users ");
  13.      
  14.  
  15.              EditText num = (EditText) findViewById(R.id.displaymessage);
  16.              num.setText(reset.getString(1));
  17.      
  18.              DbConn.close();
  19.      
  20.             } catch (Exception e)
  21.             {
  22.             Log.w("Error connection","" + e.getMessage());
  23.             }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement