Advertisement
Guest User

Untitled

a guest
Jan 18th, 2017
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.33 KB | None | 0 0
  1. Connection conn = null;
  2. String dbName = "rbelz";
  3. String serverip="192.168.1.212";
  4. String serverport="2005";
  5. String url = "jdbc:sqlserver://"+serverip+":"+serverport+";databaseName="+dbName+"";
  6. Statement stmt = null;
  7. ResultSet result = null;
  8. String driver = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
  9. String databaseUserName = "neka";
  10. String databasePassword = "neka123";
  11. try {
  12. Class.forName(driver).newInstance();
  13. conn = DriverManager.getConnection(url, databaseUserName, databasePassword);
  14. stmt = conn.createStatement();
  15. result = null;
  16. String pa,us;
  17. result = stmt.executeQuery("select * from IzzumeStaff ");
  18.  
  19. while (result.next()) {
  20. us=result.getString("Login");
  21. pa = result.getString("Pass");
  22. System.out.println(us+" "+pa);
  23. }
  24.  
  25. conn.close();
  26. } catch (Exception e) {
  27. e.printStackTrace();
  28. }
  29. }
  30.  
  31. 7:36:49.859 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: android.os.NetworkOnMainThreadException
  32. 01-18 17:36:49.864 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.os.StrictMode$AndroidBlockGuardPolicy.onNetwork(StrictMode.java:1147)
  33. 01-18 17:36:49.864 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at libcore.io.BlockGuardOs.connect(BlockGuardOs.java:110)
  34. 01-18 17:36:49.864 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at libcore.io.IoBridge.connectErrno(IoBridge.java:154)
  35. 01-18 17:36:49.864 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at libcore.io.IoBridge.connect(IoBridge.java:122)
  36. 01-18 17:36:49.864 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:183)
  37. 01-18 17:36:49.875 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:456)
  38. 01-18 17:36:49.879 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.net.Socket.connect(Socket.java:882)
  39. 01-18 17:36:49.880 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.microsoft.sqlserver.jdbc.TDSChannel.open(IOBuffer.java:415)
  40. 01-18 17:36:49.880 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(SQLServerConnection.java:1018)
  41. 01-18 17:36:49.880 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
  42. 01-18 17:36:49.885 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
  43. 01-18 17:36:49.885 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
  44. 01-18 17:36:49.885 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:179)
  45. 01-18 17:36:49.885 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:213)
  46. 01-18 17:36:49.886 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at rbelz.neka.nek.tj.rbelzadmingeneral.LoginActivity.onCreate(LoginActivity.java:68)
  47. 01-18 17:36:49.886 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.Activity.performCreate(Activity.java:5990)
  48. 01-18 17:36:49.886 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1106)
  49. 01-18 17:36:49.886 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2278)
  50. 01-18 17:36:49.886 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2387)
  51. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.ActivityThread.access$800(ActivityThread.java:151)
  52. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1303)
  53. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.os.Handler.dispatchMessage(Handler.java:102)
  54. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.os.Looper.loop(Looper.java:135)
  55. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at android.app.ActivityThread.main(ActivityThread.java:5254)
  56. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.lang.reflect.Method.invoke(Native Method)
  57. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at java.lang.reflect.Method.invoke(Method.java:372)
  58. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:903)
  59. 01-18 17:36:49.887 28324-28324/rbelz.neka.nek.tj.rbelzadmingeneral W/System.err: at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:698)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement