Hi In My Application I am designing an application with student names and roll no's displaying in table layout and I have one button called save.clicking save button All the records I want to store it in a table.
Example:
Student Names -> A,B,C etc and Roll No ->1,2,3
The above records are displaying in table format Now, If I click save button I want show all the 3 records.Now it's saving only last record.
Can any one please help me how to resolve this issue
Attend.java
public class Attend extends Activity implements OnClickListener {
String data = "";
TableLayout tl;
TableRow tr;
TextView studentName;
EditText Firstname,stRoll1;
CheckBox present;
String[] class_name, section_name;
boolean stval;
ArrayList<String> n= new ArrayList<String>();
@SuppressLint("NewApi")
String student_name,roll_no;
Button save;
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
tl = (TableLayout) findViewById(R.id.maintable);
save = (Button)findViewById(R.id.save);
Firstname = (EditText) findViewById(R.id.studentname );
Firstname.setVisibility(View.GONE);
stRoll1 = (EditText) findViewById(R.id.rollnumber );
stRoll1.setVisibility(View.GONE);
save.setOnClickListener(new View.OnClickListener() {
@TargetApi(Build.VERSION_CODES.GINGERBREAD)
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
//save.setText("Record Saved Sucessfully");
student_name = Firstname.getText().toString();
System.out.println(student_name);
roll_no = stRoll1.getText().toString();
System.out.println(roll_no);
Toast.makeText(
Attend.this,
"Result : " + "\nStudentName : " +student_name
+ "\nRollno : " + roll_no,
Toast.LENGTH_SHORT).show();
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
nameValuePairs.add(new BasicNameValuePair("student_name",student_name));
nameValuePairs.add(new BasicNameValuePair("roll_no",roll_no));
// nameValuePairs.add(new BasicNameValuePair("f3",v3));
StrictMode.setThreadPolicy(policy);
final String queryString = "student_name=" + student_name+ "&roll_no=" + roll_no;
data = DatabaseUtility.executeQueryPhp("save",queryString);
System.out.println(data);
}
});
String class_id = getIntent().getStringExtra("class_id");
String section_id = getIntent().getStringExtra("section_id");
Toast.makeText(
this,
"Result : " + "\nclassName : " + class_id + "\nSectionName : "
+ section_id,
Toast.LENGTH_SHORT).show();
final String queryString = "class_id=" + class_id + "§ion_id="
+ section_id;
/*String result = DatabaseUtility.executeQueryPhp("getStudent",
queryString);*/
new Thread(new Runnable() {
public void run() {
data = DatabaseUtility.executeQueryPhp("getStudent",queryString);
System.out.println(data);
runOnUiThread(new Runnable() {
@Override
public void run() {
ArrayList<StudentDetails> users = parseJSON(data);
addData(users);
}
});
}
}).start();
}
public ArrayList<StudentDetails> parseJSON1(String result1) {
ArrayList<StudentDetails> users = new ArrayList<StudentDetails>();
try {
JSONArray jArray = new JSONArray(result1);
for (int i = 0; i < jArray.length(); i++) {
JSONObject json_data = jArray.getJSONObject(i);
StudentDetails user = new StudentDetails();
user.setStudentname(json_data.getString("student_nme"));
user.setRollno(json_data.getString("roll_no"));
users.add(user);
}
} catch (JSONException e) {
Log.e("log_tag", "Error parsing data " + e.toString());
}
return users;
}
public ArrayList<StudentDetails> parseJSON(String result) {
ArrayList<StudentDetails> users = new ArrayList<StudentDetails>();
try {
JSONArray jArray = new JSONArray(result);
for (int i = 0; i < jArray.length(); i++) {
JSONObject json_data = jArray.getJSONObject(i);
StudentDetails user = new StudentDetails();
// user.setId(json_data.getInt("class_name"));
// user.setClass_id(json_data.getInt("section_name"));
// user.setSection_id(json_data.getInt("section_id"));
user.setStudentname(json_data.getString("first_name"));
user.setRollno(json_data.getString("roll_no"));
users.add(user);
}
} catch (JSONException e) {
Log.e("log_tag", "Error parsing data " + e.toString());
}
return users;
}
void addHeader() {
tr = new TableRow(this);
studentName = new TextView(this);
studentName.setText("StudentName");
studentName.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,
LayoutParams.WRAP_CONTENT));
studentName.setPadding(5, 5, 5, 5);
studentName.setBackgroundColor(Color.RED);
LinearLayout Ll = new LinearLayout(this);
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(
LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT);
params.setMargins(5, 5, 5, 5);
Ll.addView(studentName, params);
tr.addView((View) Ll);
TextView RollNo = new TextView(this);
RollNo.setText("RollNo");
RollNo.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,
LayoutParams.WRAP_CONTENT));
RollNo.setPadding(5, 5, 5, 5);
RollNo.setBackgroundColor(Color.RED);
Ll = new LinearLayout(this);
params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(0, 5, 5, 5);
Ll.addView(RollNo, params);
tr.addView((View) Ll);
TextView Present = new TextView(this);
Present.setText("Present");
Present.setLayoutParams(new LayoutParams(LayoutParams.WRAP_CONTENT,
LayoutParams.WRAP_CONTENT));
Present.setPadding(5, 5, 5, 5);
Present.setBackgroundColor(Color.RED);
Ll = new LinearLayout(this);
params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(0, 5, 5, 5);
Ll.addView(Present, params);
tr.addView((View) Ll);
tl.addView(tr, new TableLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT));
}
@SuppressWarnings({ "rawtypes" })
public void addData(ArrayList<StudentDetails> users) {
addHeader();
for (Iterator i = users.iterator(); i.hasNext();) {
StudentDetails p = (StudentDetails) i.next();
/** Create a TableRow dynamically **/
tr = new TableRow(this);
/** Creating a TextView to add to the row **/
Firstname = new EditText(this);
Firstname.setKeyListener(null);
Firstname.setText(p.getStudentname());
Firstname.setId(p.getId());
Firstname.setLayoutParams(new LayoutParams(
LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
Firstname.setPadding(5, 5, 5, 5);
LinearLayout Ll = new LinearLayout(this);
LinearLayout.LayoutParams params = new LinearLayout.LayoutParams(
LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT);
params.setMargins(5, 2, 2, 2);
Ll.addView(Firstname, params);
tr.addView((View) Ll);
stRoll1= new EditText(this);
stval=n.add(stRoll1.getText().toString());
stRoll1.setKeyListener(null);
stRoll1.setText(p.getRollno());
stRoll1.setLayoutParams(new LayoutParams(
LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
stRoll1.setPadding(5, 5, 5, 5);
Ll = new LinearLayout(this);
params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(0, 3, 3, 3);
Ll.addView(stRoll1, params);
tr.addView((View) Ll);
CheckBox present = new CheckBox(this);
present.setLayoutParams(new LayoutParams(
LayoutParams.WRAP_CONTENT, LayoutParams.WRAP_CONTENT));
present.setPadding(5, 5, 5, 5);
Ll = new LinearLayout(this);
params = new LinearLayout.LayoutParams(LayoutParams.FILL_PARENT,
LayoutParams.WRAP_CONTENT);
params.setMargins(0, 3, 3, 3);
Ll.addView(present, params);
tr.addView((View) Ll);
tl.addView(tr, new TableLayout.LayoutParams(
LayoutParams.FILL_PARENT, LayoutParams.WRAP_CONTENT));
}
}
@Override
public void onClick(View v) {
// TODO Auto-generated method stub
}
}
0 comments:
Post a Comment