<%@ page import="java.io.*,java.util.*" %> <%@ page import="java.sql.*,javax.sql.*,javax.naming.*" %> <%@ page session="true" %> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("Jdbc:Odbc:orads", "scott", "tiger"); Statement stmt=con.createStatement(); String userid=request.getParameter("userid"); ResultSet rs=stmt.executeQuery("select * from wbmslogin where Userid='"+userid+"'"); String Uid=""; String pwd=""; String mailid=""; String collid=""; String dep=""; String usertype=""; if(rs.next()){ Uid=rs.getString(1); pwd=rs.getString(2); mailid=rs.getString(3); collid=rs.getString(4); dep=rs.getString(5); usertype=rs.getString(6); session.setAttribute("userid",Uid); %>
User Profile Edit
Faculty DETAILS:
User Name
Password
Mail Id
College Id
Department
User Type
<%} else{ out.println("

Please Enter Valid User ID

"); } %>