Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public static String Server="192.168.0.26:1433";
- public static String DataBase="TEST_CON";
- public static String Username="sa";
- public static String Password="12345678";
- public static Connection Abrir() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException
- {
- Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
- Connection conn = DriverManager.getConnection("jdbc:sqlserver://"+conexao.Server+ ";databaseName="+conexao.DataBase,conexao.Username,conexao.Password);
- return conn;
- }
- public int Testar() throws ClassNotFoundException, SQLException, InstantiationException, IllegalAccessException {
- int u = 0;
- Connection conn = conexao.Abrir();
- Statement MW = conn.createStatement();
- ResultSet rs = MW.executeQuery("SELECT*From Tb_utilizador order by Nome");
- while (rs.next()) {
- u = 1;
- }
- return u;
- }
- <?xml version="1.0" encoding="utf-8"?>
- <manifest xmlns:android="http://schemas.android.com/apk/res/android"
- package="com.example.con_sql_server"
- android:versionCode="1"
- android:versionName="1.0"
- >
- <uses-sdk
- android:minSdkVersion="19"
- android:targetSdkVersion="19" />
- <uses-permission android:name="android.permission.INTERNET"></uses-permission>
- <application
- android:allowBackup="true"
- android:icon="@drawable/ic_launcher"
- android:label="@string/app_name"
- android:theme="@style/AppTheme" android:hasCode="true" android:permission="android.permission.ACCESS_CHECKIN_PROPERTIES">
- <activity
- android:name=".MainActivity"
- android:label="@string/app_name" >
- <intent-filter>
- <action android:name="android.intent.action.MAIN" />
- <category android:name="android.intent.category.LAUNCHER" />
- </intent-filter>
- </activity>
- </application>
- </manifest>
- public void ConnectToDatabase(){
- try {
- // Setar as suas configurações
- Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
- String username = "XXXXXXXXX";
- String password = "XXXXXX";
- Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://192.168.0.26:1433/TEST_CON;user=TEST_CON" + username + ";password=12345678" + password);
- Log.w("Connection","open");
- Statement stmt = DbConn.createStatement();
- ResultSet reset = stmt.executeQuery("SELECT*From Tb_utilizador order by Nome");
- EditText num = (EditText) findViewById(R.id.displaymessage);
- num.setText(reset.getString(1));
- DbConn.close();
- } catch (Exception e)
- {
- Log.w("Erro na conexão","" + e.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement