form.html
<html> <form method="post" action="http://localhost:8080/examples/jsp/insert.jsp"> <table> <tr><td>Name:</td><td><input type="text" name="name"></td></tr> <tr><td>Address:</td><td><input type="text" name="address"></td></tr> <tr><td></td><td><input type="submit" value="Submit"></td></tr> </table> </form> </html>
insert.jsp
<%@page import="java.sql.*"%><% String name=request.getParameter("name"); String address=request.getParameter("address"); Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:student"); Statement st=con.createStatement(); int i=st.executeUpdate("insert into user(name,address) values('"+name+"','"+address+"')"); out.println("Data is inserted successfully"); %>
for more
visit:
http://docs.oracle.com/cd/A87860_01/doc/java.817/a83726/sampapp2.htm
No comments:
Post a Comment