<%@ page language="java" import="java.sql.*"%> <body> <jsp:useBean id="SBean" scope="request" class="vikhyath.StudBean"> <jsp:setProperty name="SBean" property="*" /> </jsp:useBean> The details you have entered are : <BR><BR>
Name : <jsp:getProperty name="SBean" property="name" /><br> ID : <jsp:getProperty name="SBean" property="id" /><br> Branch : <jsp:getProperty name="SBean" property="branch" /><br> Marks : <jsp:getProperty name="SBean" property="marks" /><br> Attendance : <jsp:getProperty name="SBean" property="atten" /><br><br><BR> <% String s="<%= SBean.getName() %>"; // ERROR !!! i want to assign a bean //property to a string so that i can use it in a session to insert the data //into mysql ! String name=request.getParameter("name"); String sid=request.getParameter("id"); String branch=request.getParameter("branch"); String marks=request.getParameter("marks"); String atten=request.getParameter("atten"); String pass="student"; try { Statement stmt; Class.forName("com.mysql.jdbc.Driver"); String url ="jdbc:mysql://localhost:3306/vikh?user=root&password=admin";
Connection con =DriverManager.getConnection(url);
stmt = con.createStatement();
stmt.executeUpdate("insert into studb values ('"+name+"','"+pass+"','"+sid+"','"+branch+"','"+marks+"','"+atten+"');"); out.println("Updation successfull !");
maaaaaaaan thanks a lot... thank you very very much.. i cant thank you enough... i was going mad over this for a week now.. Sri Anand YOU ROCK !! ... i am a newbie so still learning ! Prateek thanks to you too