Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:university","system","12345"); PreparedStatement ps=con.prepareStatement("Insert into COURSE(COURSE_CODE, NAME, DURATION, SUBJECT, TOTAL_FEE) VALUES(?,?,?,?,?)"); ps.setString(1,request.getParameter("code")); ps.setString(2,request.getParameter("name")); ps.setString(3,request.getParameter("duration")); ps.setString(4,request.getParameter("subject")); ps.setString(5,request.getParameter("fee")); ps.executeUpdate(); ps.close(); con.close(); } catch(Exception e){ out.println(e); } %>
Monday, August 30, 2010
To add something in Database
<%@ page language="java" import="java.sql.*; "%>
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:university","system","12345"); PreparedStatement ps=con.prepareStatement("Insert into COURSE(COURSE_CODE, NAME, DURATION, SUBJECT, TOTAL_FEE) VALUES(?,?,?,?,?)"); ps.setString(1,request.getParameter("code")); ps.setString(2,request.getParameter("name")); ps.setString(3,request.getParameter("duration")); ps.setString(4,request.getParameter("subject")); ps.setString(5,request.getParameter("fee")); ps.executeUpdate(); ps.close(); con.close(); } catch(Exception e){ out.println(e); } %>
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con=DriverManager.getConnection("jdbc:odbc:university","system","12345"); PreparedStatement ps=con.prepareStatement("Insert into COURSE(COURSE_CODE, NAME, DURATION, SUBJECT, TOTAL_FEE) VALUES(?,?,?,?,?)"); ps.setString(1,request.getParameter("code")); ps.setString(2,request.getParameter("name")); ps.setString(3,request.getParameter("duration")); ps.setString(4,request.getParameter("subject")); ps.setString(5,request.getParameter("fee")); ps.executeUpdate(); ps.close(); con.close(); } catch(Exception e){ out.println(e); } %>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment