search

shalomweiss / mm-system-2017

MIT License
2 stars 2 forks source link

TODO - Reports #35

Open masterFoad opened 7 years ago

masterFoad commented 7 years ago

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-usagenotes-statements-callable.html

You must also check null input and use setNull see https://stackoverflow.com/questions/18449708/how-to-insert-null-in-mysql-especially-int-datatype

These are the callable procedures that you must implement: CallableStatement cStmt = conn.prepareCall("{call getAllCorrespondingPairs(?, ?, ?, ?, ?)}"); numOfMeetings int(11), mentorFirstName varchar(50), varchar(50), startingAt date, endingAt date, meetingTypeToGet tinyint

CallableStatement cStmt = conn.prepareCall("{call getAllCorrespondingMentees(?, ?, ?, ?, ?, ?)}"); address varchar(254), gender tinyint(4), academicInstitute int(11), inPair tinyint(4), academicDicipline1 varchar(45), academicDicipline2 varchar(45)

CallableStatement cStmt = conn.prepareCall("{call getAllCorrespondingMentors(?, ?, ?, ?)}"); address varchar(254), gender tinyint(4), company int(11), inPair tinyint(4)

NajibAbuSamra commented 7 years ago

Currently the procedures saved in the db function as intended (I tested them)

next we need to call them from the DA methods