Advertisement
Guest User

Untitled

a guest
May 24th, 2016
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. String dbName = "AndroidDB";
  2. String serverip="10.0.2.2";
  3. String serverport="1433";
  4. String url = "jdbc:sqlserver://"+serverip+"\14GRAFICALI\MSSQLSERVER2008"+serverport+";databaseName="+dbName+"";
  5.  
  6. public class MainActivity extends Activity {
  7.  
  8.  
  9. String dbName = "AndroidDB";
  10. String serverip="10.0.2.2";
  11. String serverport="1433";
  12. String url = "jdbc:sqlserver://"+serverip+"\14GRAFICALI\MSSQLSERVER2008"+serverport+";databaseName="+dbName+"";
  13.  
  14. @Override
  15. protected void onCreate(Bundle savedInstanceState) {
  16. super.onCreate(savedInstanceState);
  17. setContentView(R.layout.activity_main);
  18.  
  19.  
  20. TextView tvData=(TextView)findViewById(R.id.tvSelectedData);
  21.  
  22. try {
  23. Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
  24. Connection conn =DriverManager.getConnection(url);
  25.  
  26. Statement statement=conn.createStatement();
  27. ResultSet resultSet=statement.executeQuery("select * from UserMaster");
  28. while(resultSet.next()){
  29. tvData.setText(" Data1 : "+resultSet.getString(1)+" Data 2 : "+resultSet.getNString(2));
  30. }
  31.  
  32. } catch (Exception e) {
  33. e.printStackTrace();
  34. tvData.setText(e.getMessage());
  35. }
  36.  
  37.  
  38.  
  39. }
  40.  
  41. @Override
  42. public boolean onCreateOptionsMenu(Menu menu) {
  43. // Inflate the menu; this adds items to the action bar if it is present.
  44. getMenuInflater().inflate(R.menu.main, menu);
  45. return true;
  46. }
  47.  
  48. }
  49.  
  50. <uses-permission android:name="android.permission.INTERNET"/>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement