package exercicios;
import java.sql.*;

//conexão à base de dados
public class DBConnection
{
    private Connection con;
    private Statement st;
    private ResultSet rs;

    public DBConnection() throws SQLException
    {
        try
        {
            Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
            con = DriverManager.getConnection("jdbc:sqlserver://localhost:1433;databaseName=Exercicios;user=sa;password=segredo;");
            st = con.createStatement();
        }
        catch(Exception ex)
        {
            System.out.println("Error: "+ex);
        }

        st = con.createStatement();
        rs = st.executeQuery("SELECT teste1 AND teste2 FROM teste");

        while(rs.next())
        {
            String testes = rs.getString("teste1");
            System.out.println(testes + "\n");
        }
    }

}