<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %> <% Connection con; ResultSet rs; Statement st; String othersr=request.getParameter("others"); out.println(othersr); String others; String username=""; String name=username; username =(String) session.getAttribute("name1"); try { Class.forName("com.mysql.jdbc.Driver").newInstance(); con = DriverManager.getConnection("jdbc:mysql://localhost/iitDB","root","91don699629"); st=con.createStatement(); rs=st.executeQuery("select username,others from adminfac where username='"+username+"' "); if(rs.next()) { others = rs.getString("others"); if(!othersr.equals(others)) st.executeUpdate("update adminfac set others='"+othersr+"' where username='"+username+"' "); } response.sendRedirect("lview.jsp"); } catch(SQLException sqle) { System.err.println(sqle.getMessage()); } catch (ClassNotFoundException cnfe){ System.err.println(cnfe.getMessage()); } catch (Exception e){ out.println(e.getMessage()); out.println("sql Exexption"); } %>