Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String dbName = "AndroidDB";
- String serverip="10.0.2.2";
- String serverport="1433";
- String url = "jdbc:sqlserver://"+serverip+"\14GRAFICALI\MSSQLSERVER2008"+serverport+";databaseName="+dbName+"";
- public class MainActivity extends Activity {
- String dbName = "AndroidDB";
- String serverip="10.0.2.2";
- String serverport="1433";
- String url = "jdbc:sqlserver://"+serverip+"\14GRAFICALI\MSSQLSERVER2008"+serverport+";databaseName="+dbName+"";
- @Override
- protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_main);
- TextView tvData=(TextView)findViewById(R.id.tvSelectedData);
- try {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver").newInstance();
- Connection conn =DriverManager.getConnection(url);
- Statement statement=conn.createStatement();
- ResultSet resultSet=statement.executeQuery("select * from UserMaster");
- while(resultSet.next()){
- tvData.setText(" Data1 : "+resultSet.getString(1)+" Data 2 : "+resultSet.getNString(2));
- }
- } catch (Exception e) {
- e.printStackTrace();
- tvData.setText(e.getMessage());
- }
- }
- @Override
- public boolean onCreateOptionsMenu(Menu menu) {
- // Inflate the menu; this adds items to the action bar if it is present.
- getMenuInflater().inflate(R.menu.main, menu);
- return true;
- }
- }
- <uses-permission android:name="android.permission.INTERNET"/>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement