Advertisement
Guest User

Untitled

a guest
May 8th, 2016
129
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 2.51 KB | None | 0 0
  1. package com.example.bartosz.eagleeye;
  2.  
  3. import android.os.AsyncTask;
  4. import android.util.Log;
  5. import android.widget.EditText;
  6.  
  7. import java.sql.Connection;
  8. import java.sql.DriverManager;
  9. import java.sql.ResultSet;
  10. import java.sql.SQLException;
  11. import java.sql.Statement;
  12.  
  13.  
  14. /**
  15.  * Created by Bartosz on 2016-05-08.
  16.  */
  17. public class ConnectionDB extends AsyncTask<String, String, String> {
  18.  
  19.     @Override
  20.     protected String doInBackground(String... f_url) {
  21.         // JDBC driver name and database URL
  22.         String JDBC_DRIVER = "net.sourceforge.jtds.jdbc.Driver";
  23.         String DB_URL = "jdbc:jtds:sqlserver://192.168.1.129:1433;DatabaseName=Mobile";
  24.  
  25.         //  Database credentials
  26.         String USER = "admin1";
  27.         String PASS = "123";
  28.  
  29.  
  30.         Connection conn = null;
  31.         try{
  32.             //STEP 2: Register JDBC driver
  33.             Class.forName("net.sourceforge.jtds.jdbc.Driver");
  34.  
  35.             //STEP 3: Open a connection
  36.             System.out.println("Connecting to database...---------------------------------------------------------------");
  37.             conn = DriverManager.getConnection(DB_URL,USER,PASS);
  38.  
  39.             //STEP 4: Execute a query
  40.             System.out.println("Creating statement...--------------------------------------------------------------");
  41.             Statement stmt = conn.createStatement();
  42.             String sql;
  43.             sql = "SELECT * FROM Pracownik";
  44.             ResultSet rs = stmt.executeQuery(sql);
  45.  
  46.             //STEP 5: Extract data from result set
  47.             while(rs.next()){
  48.  
  49.                 String last = rs.getString("nazwisko");
  50.  
  51.                 //Display values
  52.  
  53.                 System.out.println(", nazwisko: " + last);
  54.             }
  55.             //STEP 6: Clean-up environment
  56.             rs.close();
  57.             stmt.close();
  58.             conn.close();
  59.         }catch(SQLException se){
  60.             //Handle errors for JDBC
  61.             se.printStackTrace();
  62.             return "//Handle errors for JDBC";
  63.         }catch(Exception e){
  64.             //Handle errors for Class.forName
  65.             e.printStackTrace();
  66.             return "//Handle errors for Class.forName";
  67.         }finally{
  68.             //finally block used to close resources
  69.             try{
  70.                 if(conn!=null)
  71.                     conn.close();
  72.             }catch(SQLException se){
  73.                 se.printStackTrace();
  74.             }//end finally try
  75.         }//end try
  76.         System.out.println("Goodbye!");
  77.         return"err";
  78.     }
  79. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement