Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package projetobd;
- import java.sql.*;
- //conexão à base de dados
- public class DBConnection
- {
- private Connection con;
- private Statement st;
- private ResultSet rs;
- public Connection DatabaseConnection() throws SQLException, ClassNotFoundException
- {
- Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
- String url="jdbc:sqlserver://localhost:1433;databaseName=ProjectoBD;user=sa;password=segredo;";
- con=DriverManager.getConnection(url);
- return con;
- }
- public void getData()
- {
- try
- {
- String query = "SELECT * FROM Paciente";
- rs = st.executeQuery(query);
- System.out.println("Records:");
- while(rs.next())
- {
- String nome = rs.getString("nome");
- System.out.println("Nome: "+nome);
- }
- }
- catch(Exception e)
- {
- System.out.println(e);
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement