Advertisement
WhiteGazelle

dbconnection

Jun 2nd, 2017
116
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.01 KB | None | 0 0
  1. package projetobd;
  2. import java.sql.*;
  3.  
  4. //conexão à base de dados
  5. public class DBConnection
  6. {
  7.     private Connection con;
  8.     private Statement st;
  9.     private ResultSet rs;
  10.    
  11.     public Connection DatabaseConnection() throws SQLException, ClassNotFoundException
  12.     {
  13.             Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
  14.             String url="jdbc:sqlserver://localhost:1433;databaseName=ProjectoBD;user=sa;password=segredo;";
  15.             con=DriverManager.getConnection(url);
  16.             return con;
  17.     }
  18.    
  19.     public void getData()
  20.     {
  21.         try
  22.         {
  23.             String query = "SELECT * FROM Paciente";
  24.             rs = st.executeQuery(query);
  25.             System.out.println("Records:");
  26.             while(rs.next())
  27.             {
  28.                 String nome = rs.getString("nome");
  29.                 System.out.println("Nome: "+nome);  
  30.             }
  31.         }
  32.         catch(Exception e)
  33.         {
  34.             System.out.println(e);
  35.         }
  36.     }
  37. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement