Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
335
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.73 KB | None | 0 0
  1. public static String Server="192.168.0.26:1433";
  2. public static String DataBase="TEST_CON";
  3. public static String Username="sa";
  4. public static String Password="12345678";
  5.  
  6. public static Connection Abrir() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException
  7. {
  8. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  9. Connection conn = DriverManager.getConnection("jdbc:sqlserver://"+conexao.Server+ ";databaseName="+conexao.DataBase,conexao.Username,conexao.Password);
  10. return conn;
  11. }
  12.  
  13. public int Testar() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
  14. int u = 0;
  15. Connection conn = conexao.Abrir();
  16. Statement MW = conn.createStatement();
  17. ResultSet rs = MW.executeQuery("SELECT*From Tb_utilizador order by Nome");
  18.  
  19. while (rs.next()) {
  20. u = 1;
  21. }
  22. return u;
  23. }
  24.  
  25. <?xml version="1.0" encoding="utf-8"?>
  26. <manifest xmlns:android="http://schemas.android.com/apk/res/android"
  27. package="com.example.con_sql_server"
  28. android:versionCode="1"
  29. android:versionName="1.0"
  30. >
  31. <uses-sdk
  32. android:minSdkVersion="19"
  33. android:targetSdkVersion="19" />
  34. <uses-permission android:name="android.permission.INTERNET"></uses-permission>
  35. <application
  36. android:allowBackup="true"
  37. android:icon="@drawable/ic_launcher"
  38. android:label="@string/app_name"
  39. android:theme="@style/AppTheme" android:hasCode="true" android:permission="android.permission.ACCESS_CHECKIN_PROPERTIES">
  40. <activity
  41. android:name=".MainActivity"
  42. android:label="@string/app_name" >
  43. <intent-filter>
  44. <action android:name="android.intent.action.MAIN" />
  45.  
  46. <category android:name="android.intent.category.LAUNCHER" />
  47. </intent-filter>
  48. </activity>
  49. </application>
  50.  
  51. </manifest>
  52.  
  53. public void ConnectToDatabase(){
  54. try {
  55.  
  56. // Setar as suas configurações
  57. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  58. String username = "XXXXXXXXX";
  59. String password = "XXXXXX";
  60. Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.26:1433/TEST_CON;user=TEST_CON" + username + ";password=12345678" + password);
  61.  
  62. Log.w("Connection","open");
  63. Statement stmt = DbConn.createStatement();
  64. ResultSet reset = stmt.executeQuery("SELECT*From Tb_utilizador order by Nome");
  65.  
  66.  
  67. EditText num = (EditText) findViewById(R.id.displaymessage);
  68. num.setText(reset.getString(1));
  69.  
  70. DbConn.close();
  71.  
  72. } catch (Exception e)
  73. {
  74. Log.w("Erro na conexão","" + e.getMessage());
  75. }
  76. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement