Parvin Etibarli Java

1. Add dependency: implementation group : 'org.postgresql' , name : 'postgresql' , version : '42.6.0'   2. Load Postgres driver: Class . forName ( "org.postgresql.Driver" ) ; 3. Create Connection:  Connection con = DriverManager . getConnection ( "jdbc:postgresql://localhost:5432/se_21" , "postgres" , "112358" ) ; 4. Create Statement: Statement stmt = con .createStatement() ; 5. Create ResultSet: ResultSet rs = stmt .executeQuery( " select * from student " ) ; 6. Iterate ResultSet: while (rs.next()) { System. out .println(rs.getString( "name" )) ; } 7. Insert into DB with JDBC String query = " insert into person(name, surname, age, pin, password) values (?, ?, ?, ?, ?) " ; PreparedStatement stmt = con.prepareStatement(query) ; stmt.setString( 1 , person.getName()) ; stmt.setString( 2 , person.getSurname()) ; stmt.setInt( 3 , person.getAge()) ; stmt.setString( 4 , person.getPin()) ;

1. Creating Database create database test ; 2. Deleting Database drop database test ; 3. Create Table  -> Creating person table without constraints create table person ( id int , first_name varchar ( 50 ) , last_name varchar ( 50 ) , gender varchar ( 7 ) , date_of_birth date ) -> Creating person table with constraints create table person ( id bigserial not null primary key , first_name VARCHAR ( 50 ) not null , last_name VARCHAR ( 50 ) not null , email VARCHAR ( 150 ) , gender VARCHAR ( 50 ) not null , date_of_birth DATE not null , country_of_birth VARCHAR ( 50 ) not null ) ; 4. Inserting data into table insert into person ( first_name , last_name , gender , date_of_birth ) values ( 'Test' , 'Testov' , 'male' , '2000-01-01', 'Azerbaijan' ) ; 5. Selecting record(s) -> Select all information select * from person ; -> Select specific column(s) from table select first_name from person ; 6. Order by