Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.Statement;
- import java.sql.ResultSet;
- import java.sql.Date;
- import java.sql.SQLException;
- public class FirstQuery {
- Connection conn = null;
- private static regDB(){
- try {
- String driver = "oracle.jdbc.OracleDriver";
- Class.forName(driver);
- }catch (ClassNotFoundException e){
- System.out.println(e.get.Message());
- }
- return regdb;
- }
- private static
- System.out.println("Connecting to database ...");
- String jdbcUrl = "jdbc:oracle:thin:@localhost:1521:orbis";
- String user = "s173831";
- String pass = "yir734";
- conn = DriverManager.getConnection(jdbcUrl, user, pass);
- Statement st = conn.createStatement();
- String sql = "SELECT * from Н_ЦИКЛЫ_ДИСЦИПЛИН";
- String sql1 = "SELECT АББРЕВИАТУРА, НАИМЕНОВАНИЕ from Н_ЦИКЛЫ_ДИСЦИПЛИН";
- String qualification = "SELECT НАИМЕНОВАНИЕ from Н_КВАЛИФИКАЦИИ";
- String people = "SELECT DISTINCT ИМЯ from Н_ЛЮДИ";
- String state = "SELECT DISTINCT СОСТОЯНИЕ from Н_УЧЕНИКИ";
- ResultSet rs = st.executeQuery(sql);
- while(rs.next()) {
- String id =rs.getString("ИД");
- String ab = rs.getString("АББРЕВИАТУРА");
- String name = rs.getString("НАИМЕНОВАНИЕ");
- String who =rs.getString("КТО_СОЗДАЛ");
- String when =rs.getString("КОГДА_СОЗДАЛ");
- String whchange =rs.getString("КТО_ИЗМЕНИЛ");
- String whechange =rs.getString("КОГДА_ИЗМЕНИЛ");
- String type =rs.getString("ТИП");
- String sort =rs.getString("СОРТ");
- System.out.println("ИД " + id);
- System.out.println("АББРЕВИАТУРА: " + ab);
- System.out.println("НАИМЕНОВАНИЕ: " + name);
- System.out.println("КТО_СОЗДАЛ: " + who);
- System.out.println("КОГДА_СОЗДАЛ: " + when);
- System.out.println("КТО_ИЗМЕНИЛ: " + whchange);
- System.out.println("КОГДА_ИЗМЕНИЛ: " + whechange);
- System.out.println("ТИП: " + type);
- System.out.println("СОРТ: " + sort);
- }
- rs = st.executeQuery(sql1);
- while(rs.next()) {
- //
- String ab = rs.getString("АББРЕВИАТУРА");
- String name = rs.getString("НАИМЕНОВАНИЕ");
- System.out.println("АББРЕВИАТУРА: " + ab);
- System.out.println("НАИМЕНОВАНИЕ: " + name);
- }
- rs = st.executeQuery(qualification);
- while(rs.next()) {
- //
- String name = rs.getString("НАИМЕНОВАНИЕ");
- System.out.println("НАИМЕНОВАНИЕ: " + name);
- }
- rs = st.executeQuery(people);
- while(rs.next()) {
- //
- String name = rs.getString("ИМЯ");
- System.out.println("ИМЯ: " + name);
- }
- rs = st.executeQuery(state);
- while(rs.next()) {
- //
- String name = rs.getString("СОСТОЯНИЕ");
- System.out.println("СОСТОЯНИЕ: " + name);
- }
- rs.close();
- st.close();
- conn.close();
- }catch(SQLException se) {
- se.printStackTrace();
- }catch(Exception e) {
- e.printStackTrace();
- }finally {
- //finally block used to close resourses
- try{
- if (conn!=null)
- conn.close();
- }catch(SQLException se) {
- se.printStackTrace();
- }//end finally try
- }//end try
- System.out.println("GoodBye!");
- public static void main(String[] args) {
- reg DB();
- }//end main
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement