Click here to Skip to main content
15,564,475 members
Home / Discussions / Java
   

Java

 
GeneralRe: java.net.SocketException: Software caused connection abort: socket write error Pin
Richard MacCutchan2-Jul-17 2:37
mveRichard MacCutchan2-Jul-17 2:37 
GeneralRe: java.net.SocketException: Software caused connection abort: socket write error Pin
Django_Untaken2-Jul-17 8:33
Django_Untaken2-Jul-17 8:33 
GeneralRe: java.net.SocketException: Software caused connection abort: socket write error Pin
Richard MacCutchan3-Jul-17 4:23
mveRichard MacCutchan3-Jul-17 4:23 
QuestionInput:12-4-78==OUTPUT:12041978 //Input:9-4-78==OUTPUT:09041978 Pin
Member 1327696824-Jun-17 8:52
Member 1327696824-Jun-17 8:52 
AnswerRe: Input:12-4-78==OUTPUT:12041978 //Input:9-4-78==OUTPUT:09041978 Pin
Michael_Davies24-Jun-17 9:42
Michael_Davies24-Jun-17 9:42 
SuggestionRe: Input:12-4-78==OUTPUT:12041978 //Input:9-4-78==OUTPUT:09041978 Pin
Richard Deeming26-Jun-17 1:46
mveRichard Deeming26-Jun-17 1:46 
AnswerRe: Input:12-4-78==OUTPUT:12041978 //Input:9-4-78==OUTPUT:09041978 Pin
jschell28-Jun-17 7:16
jschell28-Jun-17 7:16 
QuestionHow should I go about getting the generated key from one DAOImpl to another DAOImpl ? Pin
karengsh18-Jun-17 6:30
karengsh18-Jun-17 6:30 
Dear experts,

I understand now that I have to get Generated Key in order to obtain my auto-incremental Id from a table.

However, after getting the generated key and set it to the model. I am stuck as to how to give it to my third table.

Java
public void insertTutor(tutor m) throws MyDataException { // 
		openConnection();
		try {
			connection.setAutoCommit(false);
		} catch (SQLException e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
		String qry = INSERT_QRY;	
		try (    		    		
				
	PreparedStatement ps = connection.prepareStatement(qry)) {	;				
		   
	        ps.setString(1, m.getName());
	        ps.setString(2,  m.getNRIC());
                 ps.executeUpdate();	
	        ResultSet tableKeys = ps.getGeneratedKeys();
	        tableKeys.next();
	        int tutor_id = tableKeys.getInt(1);
	        m.setTutor_id(tutor_id); // here, I set my tutor id to the generatedkey
	        System.out.println(tutor_id);
	        connection.commit();
			} catch (SQLException e) {
		e.printStackTrace();
		....
	}}}}


And I do the same for my 2nd table.

My third table I need to make use of the Ids from the first and 2nd table.

So, do I create an insert like this ?

String qry = "INSERT INTO project.tutor_subject" + "(tutor_id, sub_id) values"
				+ "(?,?)"; 


And how do I go about doing the third DAOImpl and the controller to get the Ids to go into the third table ?

I have read that JPA and using MyBatis is better for many to many table insertion.

Should I do it via JPA and MyBatis ?
AnswerRe: How should I go about getting the generated key from one DAOImpl to another DAOImpl ? Pin
Mike.F.Hewitt18-Jun-17 12:14
Mike.F.Hewitt18-Jun-17 12:14 
GeneralRe: How should I go about getting the generated key from one DAOImpl to another DAOImpl ? Pin
karengsh23-Jun-17 22:34
karengsh23-Jun-17 22:34 
QuestionJava Pin
Member 1326557218-Jun-17 2:38
Member 1326557218-Jun-17 2:38 
JokeRe: Java Pin
Richard MacCutchan18-Jun-17 23:53
mveRichard MacCutchan18-Jun-17 23:53 
JokeRe: Java Pin
John C Rayan19-Jun-17 5:16
professionalJohn C Rayan19-Jun-17 5:16 
GeneralRe: Java Pin
Richard MacCutchan19-Jun-17 5:23
mveRichard MacCutchan19-Jun-17 5:23 
QuestionWhere to place connection using servlet Pin
digibat13-Jun-17 18:18
digibat13-Jun-17 18:18 
AnswerRe: Where to place connection using servlet Pin
Richard MacCutchan13-Jun-17 22:42
mveRichard MacCutchan13-Jun-17 22:42 
QuestionAndroid jetplayer Pin
Member 132447819-Jun-17 20:24
Member 132447819-Jun-17 20:24 
AnswerRe: Android jetplayer Pin
Richard MacCutchan9-Jun-17 23:11
mveRichard MacCutchan9-Jun-17 23:11 
Questionsimple and basic Array Question Pin
Member 125938658-Jun-17 18:37
Member 125938658-Jun-17 18:37 
AnswerRe: simple and basic Array Question Pin
Richard MacCutchan8-Jun-17 23:09
mveRichard MacCutchan8-Jun-17 23:09 
GeneralRe: simple and basic Array Question Pin
Member 125938659-Jun-17 2:57
Member 125938659-Jun-17 2:57 
GeneralRe: simple and basic Array Question Pin
Richard MacCutchan9-Jun-17 3:09
mveRichard MacCutchan9-Jun-17 3:09 
GeneralRe: simple and basic Array Question Pin
Member 125938659-Jun-17 6:30
Member 125938659-Jun-17 6:30 
GeneralRe: simple and basic Array Question Pin
Richard MacCutchan9-Jun-17 8:21
mveRichard MacCutchan9-Jun-17 8:21 
GeneralRe: simple and basic Array Question Pin
Member 125938659-Jun-17 8:41
Member 125938659-Jun-17 8:41 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.