demo.java

ENTERPRISE RESOURCE INFORMATION SYSTEM(ERIS) is a compurised solution for recruiting angencies and s

import java.sql.*;

public class demo{

public static void main (String  s[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:eris","eris","eris");
Statement st= con.createStatement();
PreparedStatement pst=con.prepareStatement("update  applicantsdetails set firstname=? where applicantid=4002");
ResultSet rs=st.executeQuery("select * from applicantsdetails where applicantid=4002");
if(rs.next())
	{
	System.out.println(rs.getString(1));
	System.out.println(rs.getString("firstname"));

	}
pst.setString(1,"adi");
pst.executeUpdate();


}catch(Exception e)
	{
	 System.out.println( "cause"+e.getCause().toString());
	}
finally()
	{
	rs.close();
	st.close();
	pst.close();
	con.close();

	}
}
}