import java.sql.*;
import java.io.*;
import oracle.jdbc.*;
public class Database{

public static void Insert (int dar_id, String dar_var, String dar_uzv, String dar_pk, String dar_dzimums)
       throws SQLException {
                  String sql = "insert into Darbinieks values (?,?,?,?,?)";
                  try {Connection conn =
        DriverManager.getConnection("jdbc:default:connection:");
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, dar_id);
        pstmt.setString(2, dar_var);
        pstmt.setString(3, dar_uzv);
        pstmt.setString(4, dar_pk);
        pstmt.setString(5, dar_dzimums);
        pstmt.executeUpdate();
        pstmt.close(); }
  catch (SQLException e) {System.err.println(e.getMessage());}
 }


public static void Select (String dar_uzv)
    throws SQLException {
      String sql = "select A.Darbinieks_ID, A.Darbinieks_VAR, A.Darbinieks_UZV, A.Darbinieks_PK, A.Darbinieks_DZIMUMS +  " from Darbinieks A" +
        " where A.Darbinieks_UZV = ?";
      try { Connection conn = DriverManager.getConnection("jdbc:default:connection:");
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, dar_uzv);
        ResultSet rset = pstmt.executeQuery();
        System.out.println("Informacija par ekspertiem: "+ "\n");
        String izvade = "";
        while(rset.next()) {
        izvade += (rset.getInt(1) + "\t"+ "\t"+ "\t"+ "\t"+ "\t" + rset.getString(2) + "\t"+ "\t"+ "\t"+ "\t"+ rset.getString(3) + "\t"+ "\t" + "\t"+ rset.getString(4) + "\t"+ "\t" +rset.getString(5) + "\t")+ "\n" + "\n";
        }
        System.out.println("Darbinieka id "+"\t" + "Darbinieka vards " + "\t" + "Darbinieka uzvards "+"\t" + "Darbinieka pk "  + "\t"+"Darbinieka dzimums " + "\t");
        System.out.println(izvade);
        rset.close();
        pstmt.close(); }
    catch (SQLException e) {System.err.println(e.getMessage());}  } }