Test1

package test1;
import java.sql.*;


/**
 *
 * @author Filip
 */
public class JavaOracleTest1 {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        try{
            Class.forName("oracle.jdbc.driver.OracleDriver");
            Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe",
                    "vezbaonica", "vezbaonica");
            Statement st = con.createStatement();
            String sql = "SELECT * FROM gitare ";
            ResultSet rs = st.executeQuery(sql);

            while(rs.next())
                System.out.println ((rs.getInt("sifragitare"))+" "+rs.getString("nazivgitare"));

            con.close();
            }

            catch(Exception e)
                    {
                    System.out.println(e);
                    }

            }
}