Java

karengsh wrote:

don't think I can find out anything like this via googling except asking in forum.

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 = connection.prepareStatement(qry,
			// Statement.RETURN_GENERATED_KEYS);
			ps.setString(1, m.getName());
			ps.setString(2, m.getNRIC());
			ps.setString(3, m.getEmail());
			ps.setString(4, m.getAddress1());
			ps.setString(5, m.getAddress2());
			ps.setString(6, m.getZipcode());
			ps.setString(7, m.getContactNo());
			ps.setInt(8, m.getAge());
			ps.setString(9, m.getGender());
			blah blah blah
			ps.executeUpdate();
			connection.commit();
			// ResultSet tableKeys = ps.getGeneratedKeys();
			// while(tableKeys.next())
			// tableKeys.next();
			// int tutor_id = tableKeys.getInt(1);
			// m.setTutor_id(tutor_id); // I can't do it like that cos I need my controller to be able to read the tutor_id later
			// System.out.println(tutor_id);
		} catch (SQLException e) {
			e.printStackTrace();
			throw new MyDataException("DB Error");
		} finally {
			if (ps != null) {
				closeConnection();
			}
		}
	}

	public static int writeTutorId() throws Exception {
		openConnection();
		String qry = INSERT_QRY;
		tutor m = new tutor();
		int tutor_id = m.getTutor_id();
		
		PreparedStatement pstmt = connection.prepareStatement(qry, new String[] { "tutor_id" });	
		pstmt.setInt(1, m.getTutor_id());
		pstmt.setString(2, m.getName());
		pstmt.setString(3, m.getNRIC());
		pstmt.setString(4, m.getEmail());
		pstmt.setString(5, m.getAddress2());
		pstmt.setString(6, m.getZipcode());
		pstmt.setString(7, m.getContactNo());		
		pstmt.setInt(8, m.getAge());
		pstmt.setString(9, m.getGender());
		blah blah blah
		if (pstmt.executeUpdate() != -1) {
		//pstmt.executeUpdate();	
			ResultSet rs = pstmt.getGeneratedKeys();
			if (null != rs && rs.next()) {
				tutor_id = rs.getInt(1);
			}
			pstmt.close();
			connection.close();
			
		
	}
		return tutor_id;
}

<pre lang="java">

My 2nd method in which it returns the generated key ids will be used in another insertion for my 3rd table and so I would still need this method to be in.

My controller :
<pre lang="java">
protected void doPost(HttpServletRequest request, HttpServletResponse response)
			throws ServletException, IOException {
		response.setContentType("text/html;charset=UTF-8");
		PrintWriter out = response.getWriter();
		Statement stmt = null;
		tutor m4 = new tutor();		
		manager mgr = new manager();	
		try {
			String name = request.getParameter("name");
			if (name != null){			
			m4.setName(name);
			}
			String NRIC = request.getParameter("nric");
			if (NRIC != null){
			m4.setNRIC(NRIC);			
			}
			String email = request.getParameter("email");
			if (email != null){
			m4.setEmail(email);			
			String address1 = request.getParameter("address1");
			if (address1 != null){
			m4.setAddress1(address1);				
			}
			String address2 = request.getParameter("address2");
			if (address2 != null){
			m4.setAddress2(address2);
			}
			String zipcode = request.getParameter("zipcode");
			if (zipcode != null){
			m4.setZipcode(zipcode);
			}
			String contactNo = request.getParameter("contactNo");
			if (contactNo != null){
			m4.setContactNo(contactNo);			
			}
			int age = Integer.parseInt(request.getParameter("age"));
			if (age != 0){
			m4.setAge(age);
			}
			String gender = request.getParameter("Gender");
			if (gender != null){			
			m4.setGender(gender);
			}
			so on and so for...
			}			
			mgr.insertTutor(m4);			
			} }catch (Exception ex) {
				// TODO Auto-generated catch block
				ex.printStackTrace();			
				}	
		
			Subject s = new Subject();
			try{
			
			String[] sub = request.getParameterValues("subject");
						
			List<String> subjName = Arrays.asList(sub);
			//System.out.println(subjName);
			mgr.insertSubject(subjName);
			}catch (Exception ex) {
				// TODO Auto-generated catch block
				ex.printStackTrace();			
				}
			
			try{
				tutor_id = tutorDAOImpl.writeTutorId(); // problem is I need the writeTutorId() which is the generated Keys
				subj_id = subjectDAOImpl.Idlist();						
				tutor_SubjectDAOImpl.insertTutor_Subject(tutor_id, subj_id);
			}
			 catch (Exception ex) {
				// TODO Auto-generated catch block
				ex.printStackTrace();			
				}
	}
	}

Member 13290460 wrote:

Please help

Richard MacCutchan wrote:

So your 'client' should be a server .....

Richard MacCutchan wrote:

Well, as I suggested above, that is because the browser is not expecting it.

Member 13276968 wrote:

String ans = null;

tutor tmpTutor = new tutor("Fred Flintstone","NRIC value");
subject tmpSubject = new subject("Java");

boolean success = false;

try {
   insertTutor(tmpTutor);
   insertSubject(tmpSubject);
   success = true;
}
catch (MyDataException mde){
   // handle appropriately
}

if (success){
   try {

      /* execute INSERT on project.tutor_subject table,
         dealing with duplicate keys when necessary */
      associateTutorToSubject(tmpTutor.getId(), tmpSubject.getId());

   }
   catch (MyDataException mde2){
       // handle appropriately
   }
}