hi jagdeesh,
you are printing the value of

int dno=(Integer)session.getAttribute("deptno");

out.println(deno);

is it printing properly may be null value coming from session check out that

thanks

Rajkumar

And second thing Mr. Jagdeesh

<input type="text" name="mailid" size="20" tabindex="6" maxlength="40" title="Contact mail id" value="<%rs.getString(8);%>">

instead of this try to use expressions for text box value;

and get value write clearly for ex.

<input type="text" name="mailid" size="20" tabindex="6" maxlength="40" title="Contact mail id" value="<%=rs.getString("TableColum")%>">

thanks

rajkumar

Hi friend,


I think, problem in your database connection code. So implement this code.


<%@ page language="java" import="java.sql.*" %>

<%
Connection con = null;
String url = "jdbc:mysql://192.168.10.211:3306/";;
String db = "amar";
String driver = "com.mysql.jdbc.Driver";
String userName ="amar" ;
String password="amar123";
try{
Class.forName(driver);
con = DriverManager.getConnection(url+db,userName,password);
try{
Statement st = con.createStatement();
String empname=request.getParameter("coursename");
String position=request.getParameter("couresefee");
String facultyname = request.getParameter("facultyname");

int val = st.executeUpdate("insert student values(id,'"+empname+"','"+position+"','"+facultyname+"')");

con.close();

out.println("successfully insert data into database!");
out.println("<br/>");
out.println("<a href=DynamicdisplaydataAction.jsp>Retrive Data from database</a>");

}
catch (SQLException ex){
System.out.println("SQL statement is not executed!");
}
}
catch (Exception e){
e.printStackTrace();
}

%>

-----------------------------------------

Thanks

Amardeep