Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- enter code here protected void onCreate(Bundle savedInstanceState) {
- super.onCreate(savedInstanceState);
- setContentView(R.layout.activity_flux_sequence);
- //String url = "jtds:sqlserver://vps342074.ovh.net\MSSQLSERVER;databaseName=IZY309";
- String url = "jdbc:sqlserver://vps342074.ovh.net\MSSQLSERVER;databaseName=IZY309";
- String user = "x";
- String pass = "y";
- //System.out.println("Hello World");
- try {
- //TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
- //textViewToChange.setText("Hello");
- Connection con = DriverManager.getConnection(url, user, pass);
- Statement statement = con.createStatement();
- ResultSet resultat = statement.executeQuery("SELECT CATEGORIE FROM dbo.PPROFIL WHERE CATEGORIE = 'ac' ");
- while (resultat.next()) {
- String result = resultat.getString(1);
- TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
- textViewToChange.setText(result);
- Log.d("My Custom Tag", result);
- }resultat.close();
- statement.close();
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- private static void close(Connection con) {
- // TODO Auto-generated method stub
- close(con);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement