Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create or replace package Proj2_student_reg_package is
- type data_cursor is ref cursor;
- procedure add_students(sidIn IN students.sid%type, fnameIn IN students.firstname%type,
- lnameIn IN students.lastname%type, statusIn IN students.status%type,
- gpaIn IN students.gpa%type, emailIn IN students.gpa%type,
- ret_message OUT varchar2);
- end Proj2_student_reg_package;
- /
- create or replace package body Proj2_student_reg_package as
- procedure add_students(sidIn IN students.sid%type, fnameIn IN students.firstname%type,
- lnameIn IN students.lastname%type, statusIn IN students.status%type,
- gpaIn IN students.gpa%type, emailIn IN students.gpa%type,
- ret_message OUT varchar2)
- is
- begin
- insert into students values(sidIn ,fnameIn,lnameIn,statusIn,gpaIn,emailIn);
- COMMIT;
- ret_message := 'Success';
- EXCEPTION
- WHEN OTHERS THEN
- ret_message := 'Error';
- end add_students;
- end Proj2_student_reg_package;
-
- import java.sql.CallableStatement;
- import java.sql.Connection;
- import java.sql.SQLException;
- import java.sql.Types;
- import java.util.Scanner;
- import oracle.jdbc.OracleTypes;
- import oracle.jdbc.pool.OracleDataSource;
- public class AddStudent {
- public void addStudent(){
- Scanner line = new Scanner(System.in);
- try
- {
- //Connection to Oracle server
- OracleDataSource ds = new oracle.jdbc.pool.OracleDataSource();
- ds.setURL("jdbc:oracle:thin:@localhost:1521:xe");
- Connection conn = ds.getConnection("*****", "****");
- System.out.print("Enter the sid: ");
- String sid = line.next();
- System.out.print("Enter first name: ");
- String fname = line.next();
- System.out.print("Enter last name: ");
- String lname = line.next();
- System.out.print("Enter status: ");
- String status = line.next();
- System.out.print("Enter gpa: ");
- String gpa = line.next();
- System.out.print("Enter email: ");
- String email = line.next();
- CallableStatement cs = conn.prepareCall("{call Proj2_student_reg_package.add_students(?,?,?,?,?,?,?)}");
- cs.setString(1, sid);
- cs.setString(2, fname);
- cs.setString(3, lname);
- cs.setString(4, status);
- cs.setString(5, gpa);
- cs.setString(6, email);
- cs.registerOutParameter(7, Types.VARCHAR);
- cs.executeQuery();
- System.out.println(cs.getString(7));
- cs.close();
- //line.close();
- }
- catch (SQLException e) { System.out.println("SQLException " + e.getMessage());}
- catch (Exception e) {System.out.println(e);}
- }
- }
- create table students (sid char(4) primary key check (sid like 'B%'),
- firstname varchar2(15) not null, lastname varchar2(15) not null, status varchar2(10)
- check (status in ('freshman', 'sophomore', 'junior', 'senior', 'graduate')),
- gpa number(3,2) check (gpa between 0 and 4.0), email varchar2(20) unique);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement