I want to update only those values which are selected in display page in struts2

Lot Us

Greenhorn

Posts: 2

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This is my POJO:

package com.lotus.data;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;

import com.lotus.connectDB.DBconnect;
import com.lotus.model.*;

public class Data {
	
	public static List<Model> list(){
	
		List<Model> l1 = new ArrayList<Model>();
		
		try
		{
		String sql = "select * from parent_table";
		Connection con = DBconnect.doConnect();
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery(sql);
		Model model;
		//ticket_No, Parent_Name, Contact_No
		while (rs.next())
		{
		model = new Model();
		System.out.println("sds");
		model.setTicketNo(new Integer(rs.getString("ticket_No")));
		model.setParentName(rs.getString("Parent_Name"));
		model.setContNo(rs.getString("Contact_No"));
		System.out.println("sds");
		l1.add(model);
		}
		}
		catch (SQLException e)
		{
		e.printStackTrace();
		}
		return l1;
		}
	
	public static Model edit(Model model) {
		model = new Model();
		String sql = "update appoint_table set Confirm_Interview='', DOI='', Start_Time='', End_Time='', Cont_Person='', Interview_Status='', Feedback='', Adm_status='' where";
		Connection con = DBconnect.doConnect();
		try
		{
		Statement st = con.createStatement();
		ResultSet rs = st.executeQuery(sql);
		while (rs.next()) 
		{
		model.setTicketNo(rs.getInt("ticket_No"));
		model.setParentName(rs.getString("Parent_Name"));
		model.setContNo(rs.getString("Contact_No"));
		model.setConInter(rs.getString("Confirm_Interview"));
		model.setDoi(rs.getString("DOI"));
		model.setTimeFrom(rs.getString("Start_Time"));
		model.setTimeTo(rs.getString("End_Time"));
		model.setWhomToMeet(rs.getString("Cont_Person"));
		model.setStuStatus(rs.getString("Interview_Status"));
		model.setAdmsnStatus(rs.getString("Feedback"));
		model.setConInter(rs.getString("Adm_status"));
		}
		}
		catch (SQLException e)
		{
		e.printStackTrace();
		}
		return model;
		}
		 
}

This is my JSP page:

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
    pageEncoding="ISO-8859-1"%>
 <%@ page import="java.sql.*,com.lotus.connectDB.*" %>
 <%@taglib uri="/struts-tags" prefix="s" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Appointment Status Form</title>
<link rel="stylesheet" type="text/css" media="all" href="../Appointment/CSS/jsDatePick_ltr.min.css" />
<script type="text/javascript" src="../Appointment/CSS/jsDatePick.min.1.3.js"></script>

Lot Us

Greenhorn

Posts: 2

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Am I clear...
waiting for reply..

Joe Ess

Bartender

Posts: 9626

I like...

posted 11 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Welcome to the JavaRanch. While you are waiting for an answer, please take the time to read our FAQ, HowToAskQuestionsOnJavaRanch. The better question you ask, the more help we can be. I added CodeTags to your post so it is easier to read.
Your question can use some clarification. You say "I want to update only those values which are selected in display page in struts2". I don't know what that means. Do you want to update only fields that have changed? Do you want to track which fields the user clicked on? How do you "select" a field?

[How To Ask Questions On JavaRanch]

If you like strawberry rhubarb pie, try blueberry rhubarb (bluebarb) pie. And try this tiny ad:

a bit of art, as a gift, the permaculture playing cards

https://gardener-gift.com