How to insert data into database table from a servlet? Help please.

simple suppose u wanned to insert user name and password into table user_info then this is a simple example .....

Best Regds

bondzoro

bondzoro@yahoo.com

import javax.servlet.*;

import javax.servlet.http.*;

import java.sql.*;

public class tester extends HttpServlet {

Connection con = null;

public void init(ServletConfig sc){

super.int(sc);

Class.forName("oracle.jdbc.driver.OracleDriver");

}

public void service(HttpServletRequest req,HttpServletResponse res) throws ServletException,IOE

try {

con=DriverManager.getConnection("jdbc:oracle:thin:@database_URL:1521:ORA8","username","pa

String user = req.getParameter("username");

String pass = req.getParameter("pass");

PreparedStatement pst = con.prepareStatement("insert into user_info values(?,?)");

pst.setString(1,user);

pst.setString(2,pass);

pst.executeQuery();

pst.close();

con.close();

}catch(Exception _e){

_e.printStackTrace(System.err);

}

}

}

~

bondzoro at 2007-7-4 23:13:15 >