hai iam nireekshan
i have davalep the one Neu User Enter form in html .In this form Fillap After SUBMIB
After Useing MS-Access in THis create New User ENtrey Fields table
and i am using TomCat Server and write jsp code and my database name NIREE
Table Name New User Entrey
plse see it

<%@ page import="java.sql.*" %>
<%@ page import ="java.servlet.*" %>
<%	
			String vname=request.getParameter("name");
			int vage=Integer.parseInt("age");
			int vweight=Integer.parseInt("weight");
			int vheight=Integer.parseInt("height");
			String vsex=request.getParameter("sex");
			String vdiet=request.getParameter("diet");
			String vsmoker=request.getParameter("smoker");
			String valcohol=request.getParameter("alcohol");
			 String vlifestyle=request.getParameter("lifestyle");
			 String vemail=request.getParameter("email");
			 String vany medical Problem=request.getParameter("any medical Problem");
			 String vcountry=request.getParameter("country");
			String vcity=request.getParameter("city");
			String vyour Present Diet=request.getParameter("your Present Diet");
		
					//code to connect to the database
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		Connection con=DriverManager.getConnection("jdbc:odbc:karani","","");
		DRIVER={Microsoft Access Driver(*.mdb)};DBQ=Database.mdb");
		Statement st=con.createStatement();
			PreparedStatement pst;				
			pst=con.prepareStatement("insert into New User Registration values(?,?,?,?,?,?,?,?,?,?,?,?,?,?)");
			pst.setString(1,vname);
			pst.setInt(2,vage);
			pst.setInt(3,vweight);
			pst.setInt(4,vheight);
			pst.setString(5,vsex);
			pst.setString(6,vdiet);
			pst.setString(7,vsmoker);
			pst.setString(8,valcohol);
			pst.setString(9,vlifestyle);
			pst.setString(10,vemail);
			pst.setString(11,vany medical Problem);
			pst.setString(12,vcountry);
			pst.setString(13,vcity);
			pst.setString(14,vyuor Present Diet);
            int i=pst.executeUpdate();
		
		con.close();
}
%>

Why are you continually creating new threads on the same topic?

Why don't you simply reply to one of the threads you've already created? This is getting ridiculous.

@nireekshan can you please stop multiposting and just continue with original post? For now on please use only this post for any other enqueties in rageds of you java conectivity with Microsoft Access database

Kid probably thinks that if it only asks often enough that it'll get an answer it likes instead of constant repeats of the standard: don't use JSP for that.

This article has been dead for over six months. Start a new discussion instead.