QuestionAsk Questions?
Ramya Lakshmanan
need a example coding to develop a web form of data with jdbc
View Answers
January 24, 2011 at 1:06 PM
Hi Friend,
Try the following code:
1)form.html:
<html> <form method="post" action="http://localhost:8080/examples/jsp/insertdata.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>
2)insertdata.jsp:
<%@page import="java.sql.*"%>
<%
String name=request.getParameter("name");
String address=request.getParameter("address");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/test", "root", "root");
Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name, address) values('"+name+"','"+address+"')");
con.close();
out.println("Data is successfully inserted into database.");
}
catch(Exception e){
System.out.println(e);
}
%>
Thanks
Related Pages:
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
Tutorial Topics
