hi!
I want to add arraylist of elements into database.
when i am running this it is giving error
public class Appraisal {
ArrayList<String> al=new ArrayList<String>();
private String m_str_employeeId;
private String m_date_promotionDate;
private String m_str_designation;
private String m_str_promoterId;
private String m_str_comments;
// Getting and Setting the Appraisal Bean
public String getM_date_promotionDate() {
return m_date_promotionDate;
}
public void setM_date_promotionDate(String date) {
m_date_promotionDate = date;
al.add(date);
}
public String getM_str_comments() {
return m_str_comments;
}
public void setM_str_comments(String m_str_comments) {
this.m_str_comments = m_str_comments;
al.add(m_str_comments);
}
public String getM_str_designation() {
return m_str_designation;
}
public void setM_str_designation(String m_str_designation) {
this.m_str_designation = m_str_designation;
al.add(m_str_designation);
}
public String getM_str_employeeId() {
return m_str_employeeId;
}
public void setM_str_employeeId(String id) {
m_str_employeeId = id;
al.add(id);
}
public String getM_str_promoterId() {
return m_str_promoterId;
}
public void setM_str_promoterId(String pid) {
m_str_promoterId = pid;
al.add(pid);
}
// returing list of designation available in employee_master_details
public ArrayList<String> getDesigation(){
ArrayList<String> al=new ArrayList<String>();
try {
//establishing the connection
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:HRIS"," hris","hydus");
Statement st=con.createStatement();
ResultSet rs=st.executeQuery("select distinct designation from employee_master_details");
// adding list of all designations available from employee_master_details to arrayList
while(rs.next())
{
al.add(rs.getString("designation"));
}
rs.close();
st.close();
con.close();
} catch (Exception e) {
e.printStackTrace();
}
return al;
}
// returing list of promoter ids available in designation_hierarchy_master and employee_master_detaisl
public ArrayList<String> getPromotersId(){
//storing list of promoters ids
ArrayList<String> al1=new ArrayList<String>();
try{
// establishing connection
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:HRIS"," hris","hydus");
Statement st=con.createStatement();
// Getting the employee_id from employee_master_details using designation_hierarchy_master
ResultSet rs=st.executeQuery("select employee_id from employee_master_details where designation in (select designation from designation_hierarchy_master where hierarchy_level=1)");
while(rs.next())
{
al1.add(rs.getString("employee_id"));
}
rs.close(); //closing result set object
st.close(); //statement object
con.close(); //connection object
}
catch(Exception e){
e.printStackTrace();
}
return al1;
}
public void saveAppraisal(){
//ArrayList<String> al2=new ArrayList<String>();
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:HRIS"," hris","hydus");
PreparedStatement pst=con.prepareStatement("insert into employee_promotion_details values(?,?,?,?,?)");
pst.setString(1,al.get(0));
pst.setString(2,al.get(1) );
pst.setString(3,al.get(3));
pst.setString(4,al.get(4));
pst.setString(5,al.get(5));
int y=pst.executeUpdate();
if(y>0)
System.out.println("Promotion Updated");
pst.close();
con.commit();
con.close();
}
catch(Exception e){
e.printStackTrace();
}
}
}