Home
JAVA JDBC
Adding Records into Database
Here is a sample code to add new records in database
import java.sql.*; import javax.servlet.http.*; import javax.servlet.*; import java.io.*; public class addition extends HttpServlet { Connection con; String name,email; int age; String dsn; String strsql; Statement stmt; public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { PrintWriter pw = response.getWriter(); dsn = "Jdbc:Odbc:dsninfo"; name = request.getParameter("txtname"); age = Integer.parseInt(request.getParameter("txtage")); email=request.getParameter("txtemail"); try{ Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); }catch (ClassNotFoundException cfe) {} try{ con=DriverManager.getConnection(dsn); stmt = con.createStatement(); strsql="insert into userinfo values('"+name+"',"+age+",'"+email+"')"; stmt.executeUpdate(strsql); stmt.close(); pw.println("thanks .........."); pw.close(); con.close(); }catch (SQLException se) { System.out.println(se); } } }
Previous
Next
