Subversion Repositories bacoAlunos

package pt.estgp.estgweb.services.sigesimports.oracle;

import oracle.jdbc.pool.OracleDataSource;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * Created by jorgemachado on 07/01/16.
 */
public class OracleConnectionTest
{
    public static void main(1.5.0/docs/api/java/lang/String.html">String[] args) throws 1.5.0/docs/api/java/sql/SQLException.html">SQLException
    {
        OracleDataSource ods = new OracleDataSource();
        ods.setUser("estgac");
        ods.setPassword("estgac11");
        ods.setURL("jdbc:oracle:thin:@localhost:1521:SIGES11");

        // Connect to the database
        1.5.0/docs/api/java/sql/Connection.html">Connection conn = ods.getConnection();


        1.5.0/docs/api/java/lang/System.html">System.out.println();

        // Prepare a statement to cleanup the employees table
        1.5.0/docs/api/java/sql/PreparedStatement.html">PreparedStatement ps = conn.prepareStatement("SELECT DISTINCT CSE.T_TBDISCIP.CD_DISCIP AS CD_DISCIP, CSE.T_TBDISCIP.DS_DISCIP AS DS_DISCIP, CSE.T_TBDISCIP.CD_INSTITUIC AS CD_INSTITUIC, CSE.T_INSCRI.CD_CURSO AS CD_CURSO, CSE.T_CURSOS.NM_CURSO AS NM_CURSO, CSE.T_CURSOS.CD_GRAU1 AS CD_GRAU1 FROM CSE.T_INSCRI INNER JOIN CSE.T_TBDISCIP ON CSE.T_INSCRI.CD_DISCIP=CSE.T_TBDISCIP.CD_DISCIP INNER JOIN CSE.T_CURSOS ON CSE.T_CURSOS.CD_CURSO = CSE.T_INSCRI.CD_CURSO WHERE (((CSE.T_TBDISCIP.CD_INSTITUIC)=1) AND ((CSE.T_INSCRI.CD_LECTIVO)='201516')) AND (CSE.T_INSCRI.CD_TIPDIS = 1)");
        1.5.0/docs/api/java/sql/ResultSet.html">ResultSet rs = ps.executeQuery();
        while(rs.next())
        {
            1.5.0/docs/api/java/lang/System.html">System.out.println(rs.getString("CD_DISCIP") + ";" + rs.getString("DS_DISCIP"));
        }
        rs.close();
        ps.close();
        conn.close();
    }
}