QuestionAsk Questions?
teja
storing details in database on clicking submit button
1 Answer(s) 3 years and 2 months ago
Posted in : JSP-Servlet
1 Answer(s) 3 years and 2 months ago
Posted in : JSP-Servlet
I am using JSP in NetBeans and have developed an application form which has fileds naming 'Name' and 'ID'.I want to store the details of these two fields in the MYSQL database on clicking submit button. I am unable to do this.Can u tell me how to code this page and where and should be my code written?
This is my simple code...Tell me where an what code should I write to store the values in data base table?
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
Name:<input type="text" name="name" value="" size="10" /><br><br>
ID:<input type="text" name="id" value="" size="10" /><br><br>
<input type="submit" value="Submit" name="submit" />
</body>
</html>
This is my simple code...Tell me where an what code should I write to store the values in data base table?
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
Name:<input type="text" name="name" value="" size="10" /><br><br>
ID:<input type="text" name="id" value="" size="10" /><br><br>
<input type="submit" value="Submit" name="submit" />
</body>
</html>
View Answers
April 6, 2010 at 4:14 PM
Hi Friend,
Try the following code:
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<form method="post">
<table>
<tr><td>ID:</td><td><input type="text" name="id" value="" size="10" /></td></tr>
<tr><td>Name:</td><td><input type="text" name="name" value="" size="10" /></td></tr>
<tr><td><input type="submit" value="Submit" name="submit" /></td></tr>
</table>
</form>
</html>
<%
String id=request.getParameter("id");
String name=request.getParameter("name");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root";, "root");
Statement st=connection.createStatement();
int i=st.executeUpdate("insert into data(id,name) values('"+id+"','"+name+"')");
out.println("inserted successfully");
}
catch(Exception e){}
%>
Thanks
Try the following code:
<%@page import="java.sql.*"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<form method="post">
<table>
<tr><td>ID:</td><td><input type="text" name="id" value="" size="10" /></td></tr>
<tr><td>Name:</td><td><input type="text" name="name" value="" size="10" /></td></tr>
<tr><td><input type="submit" value="Submit" name="submit" /></td></tr>
</table>
</form>
</html>
<%
String id=request.getParameter("id");
String name=request.getParameter("name");
try{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/register","root";, "root");
Statement st=connection.createStatement();
int i=st.executeUpdate("insert into data(id,name) values('"+id+"','"+name+"')");
out.println("inserted successfully");
}
catch(Exception 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
