pslab2

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */
package l2ps;

import java.sql.*;

/**
 *
 * @author Student
 */
public class L2ps {

    /**
     * @param args the command line arguments
     */
    static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
    static final String DB_URL = "jdbc:mysql://localhost:3306/l2ps";

    //  Database credentials
    static final String USER = "root";
    static final String PASS = "root";

    public static void main(String[] args) {
        Connection conn = null;
        Statement stmt = null;
        try{
           //STEP 2: Register JDBC driver
           Class.forName("com.mysql.jdbc.Driver");

           //STEP 3: Open a connection
           System.out.println("Connecting to database...");
           conn = (Connection) DriverManager.getConnection(DB_URL,USER,PASS);

           //STEP 4: Execute a query
           System.out.println("Creating statement...");
           stmt = (Statement) conn.createStatement();
           String sql;
           sql = "SELECT idstudent, nume, data, adresa FROM student";
           ResultSet rs = stmt.executeQuery(sql);

           //STEP 5: Extract data from result set
           while(rs.next()){
              //Retrieve by column name
              int id  = rs.getInt("idstudent");
              String nume = rs.getString("nume");
              int data = rs.getInt("data");
              String adresa = rs.getString("adresa");

              //Display values
              System.out.print("ID: " + id);
              System.out.print(", nume: " + nume);
              System.out.print(", data: " + data);
              System.out.println(", adresa: " + adresa);

            Student student = new Student(7, "Claudia", 1993, "Camin");
            insert(conn, student);
           }
           //STEP 6: Clean-up environment
           rs.close();
           stmt.close();
           conn.close();
        }catch(SQLException se){
           //Handle errors for JDBC
           se.printStackTrace();
        }catch(Exception e){
           //Handle errors for Class.forName
           e.printStackTrace();
        }finally{
           //finally block used to close resources
           try{
              if(stmt!=null)
                 stmt.close();
           }catch(SQLException se2){
           }// nothing we can do
           try{
              if(conn!=null)
                 conn.close();
           }catch(SQLException se){
              se.printStackTrace();
           }//end finally try
        }//end try
        System.out.println("Goodbye!");

    }

    public static void insert(Connection conn, Student student) throws SQLException{
        String statement = "Insert into student (idstudent, nume, data, adresa) values (?,?,?,?)";
        PreparedStatement prepSt = conn.prepareStatement(statement);
        prepSt.setInt(1, student.getId());
        prepSt.setString(2, student.getNume());
        prepSt.setInt(3, student.getData());
        prepSt.setString(4, student.getAdresa());
        prepSt.executeUpdate();
    }

    public static void delete(Connection conn, Student student) throws SQLException{
        String statement = "Delete from student where Id=?";
        PreparedStatement prepSt = conn.prepareStatement(statement);
        prepSt.setInt(1, student.getId());
    }

    public static void update(Connection conn, Student student) throws SQLException{
        String statement = "Update student set nume=?, data=?, adresa=? where id=?";
        PreparedStatement prepSt = conn.prepareStatement(statement);
        prepSt.setString(1, student.getNume());
        prepSt.setInt(2, student.getData());
        prepSt.setString(3, student.getAdresa());
        prepSt.executeUpdate();
    }
}