<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
Untitled Document
<%
Connection con;
ResultSet rs;
Statement st;
String public1=request.getParameter("public");
String pub;
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,publications from adminfac where username='"+username+"' ");
if(rs.next())
{
pub= rs.getString("publications");
if(!rs.wasNull())
{
st.executeUpdate("update adminfac set publications='"+public1+"' where username='"+username+"' ");
}
else
{
st.executeUpdate("update adminfac set publications='"+public1+"' 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");
}
%>
JcfZdFmG7wHtwIoiITderMxDjOIA9A13Opnuw2Io7MI=.html