Ad:

JSP Discussion Thread
Unsolved
Views: 119978

May 8th, 2005

How to insert data into database?

Expand Post »

JSP is a new world for me, since 3 days ago. I am having a problem (or I have no idea) how does the inserting datas into database works. I have looked at some examples, but still, im having a hard time. I know PHP and ASP, but JSP is so new for me. Here's part of my codes:

------------------------------------------------------------
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
String firstname = request.getParameter("FIRSTNAME");
String lastname = request.getParameter("LASTNAME");
String address1 = request.getParameter("ADDRESS");
String address2 = request.getParameter("ADDRESS2");
String address3 = request.getParameter("ADDRESS3");
String city = request.getParameter("CITY");
String province = request.getParameter("PROVINCE");
String memo = request.getParameter("MEMO");

Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/funeral", "root", "abc123");

ResultSet rs = null;

Statement statement = connection.createStatement();

String sql = ("INSERT INTO memory VALUES ('" + firstname + "','" + lastname + "','" + address1 + "','"+ address2 +"','"+ address3 +"','"+ city +"','"+ postalcode +"','"+ province +"','"+ memo +"') ");
statement.executeUpdate(sql);

rs.close();
connection.close();

%>---------------------------------------------------

Can someone help? Thanks....

Similar Threads

insert data from one form into two diffent database table in JSP
how to insert data from dataset into database in VB.NET
How to insert data in one column in database? in ColdFusion
Inserting Data into Access Database in Java
Insert Data in to Db from the Dynamic Rows in HTML and CSS

obelisk

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2005

Permalink

May 9th, 2005

Re: How to insert data into database?

Hi
I find ur code correct.
whats the problem u r dealing with

Here r some defined steps to be followed for DB operation
1. Initialize the class with the specific driver
2. Create a connection object
3. Create statement
4. Execute query
5. Close the connection

eg. consider the DB in MsSql 2000 named 'Student' for table stud_info

<%
// Step 1
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

//Step 2
Connection conn = DriverManager.getConnection("jdbc:odbc:Student");
// here the DSN name for our database is 'Student'

//step 3
Statement stmt = conn.createStatement();

// No result set is required if you r Deleting, Updating or inserting Data to database
// To insert the Data just write the insert query and execute
%

hope this helps you

adityabakle

Reputation Points: 11

Solved Threads: 0

Newbie Poster

Offline

8 posts
since Aug 2004

Permalink

May 9th, 2005

Re: How to insert data into database?

I did this:

------------------------------------
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>

<%!
String firstname= request.getParameter("FIRSTNAME");
String lastname = request.getParameter("LASTNAME");
String address1 = request.getParameter("ADDRESS");
String address2= request.getParameter("ADDRESS2");
String address3 = request.getParameter("ADDRESS3");
String city = request.getParameter("CITY");
String province = request.getParameter("PROVINCE");
String memo = request.getParameter("MEMO");
%>
<%

Class.forName("com.mysql.jdbc.Driver");

Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/funeral", "root", "abc123");

Statement statement = connection.createStatement();
String sql = ("INSERT INTO memory VALUES ('" + firstname + "','" + lastname + "','" + address1 + "','"+ address2 +"','"+ address3 +"','"+ city +"','"+ postalcode +"','"+ province +"','"+ memo +"') ");

rs.close();
connection.close();

%>----------------------------------------------------------------------
But still, not working.

obelisk

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since May 2005

Permalink

Jun 5th, 2005

Re: How to insert data into database?

First of all, you should have some of that in a try-catch clause. That could help you out in figuring out the error. Then, since your using sql, make sure the URL passed to the DriverManager is correct, and make sure the parameters for the html page are correct.

server_crash

Reputation Points: 113

Solved Threads: 19

Postaholic

Offline

2,108 posts
since Jun 2004

Permalink

Jun 7th, 2005

Re: How to insert data into database?

You should also move things like database operations out of the JSP and into Javabeans and/or servlets.

Ideally a JSP should only concern itself with displaying data that was retrieved and/or calculated in a servlet.

jwenting

Team Colleague

Reputation Points: 1658

Solved Threads: 331

duckman

Offline

7,719 posts
since Nov 2004

Permalink

Jun 30th, 2005

Re: How to insert data into database?

I hope this would work

<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.util.*" %>
<%!
String firstname= request.getParameter("FIRSTNAME");
String lastname = request.getParameter("LASTNAME");
String address1 = request.getParameter("ADDRESS");
String address2= request.getParameter("ADDRESS2");
String address3 = request.getParameter("ADDRESS3");
String city = request.getParameter("CITY");
String province = request.getParameter("PROVINCE");
String memo = request.getParameter("MEMO");
%>
<%

Class.forName("com.mysql.jdbc.Driver");

Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/funeral", "root", "abc123");
PreparedStatement ps=conn.prepareStatement("INSERT INTO memory VALUES (?,?,?,?,?,?,?,?)");
ps.setString(1,firstname );
ps.setString(2,lastname );
ps.setString(3,address1 );
ps.setString(4,address2 );
ps.setString(5,address3 );
ps.setString(6,postalcode );
ps.setString(7,province );
ps.setString(8,memo );
ps.execute();

conn.close();
}catch(Exception e)
{
out.println(e);
}
%>-------------------------------------------

harika_reddi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Jun 2005

Permalink

Jun 30th, 2008

Re: How to insert data into database?

Very similar problem with mine.
Everything workk, but no with memo or blob field transfer. If memo length is less then 255 everything is working.
I need similar transfer from Visual Foxpro via ODBC connector and my code is:
-MySQLstr="DRIVER={MySQL ODBC 3.51 Driver};SERVER=localhost;"+"PORT=3306 ;DATABASE=xxx;USER=yyy;"+"PASSWORD="+"zzzz"+";OPTION=3;"
-MySQLhandle=sqlstringconnect(MySQLstr)
-SQLEXEC(MySQLhandle, 'INSERT INTO xx (name,date,memo) VALUES ("Johns","03:04:2005",MEMO)')

IF there is MEMO it works only if it it shortes than 255, or if MEMO i s there not !

Last edited by jlenyi; Jun 30th, 2008 at 12:32 pm.

jlenyi

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

3 posts
since Jun 2008

Permalink

Nov 1st, 2009

-1

Please check this code, some mistake is there in your code..try this

Click to Expand / Collapse Quote originally posted by obelisk ...

JSP is a new world for me, since 3 days ago. I am having a problem (or I have no idea) how does the inserting datas into database works. I have looked at some examples, but still, im having a hard time. I know PHP and ASP, but JSP is so new for me. Here's part of my codes:

------------------------------------------------------------
<%@ page contentType="text/html; charset=iso-8859-1" language="java" import="java.sql.*" errorPage="" %>
<%
String firstname = request.getParameter("FIRSTNAME");
String lastname = request.getParameter("LASTNAME");
String address1 = request.getParameter("ADDRESS");
String address2 = request.getParameter("ADDRESS2");
String address3 = request.getParameter("ADDRESS3");
String city = request.getParameter("CITY");
String province = request.getParameter("PROVINCE");
String memo = request.getParameter("MEMO");

Class.forName("com.mysql.jdbc.Driver");
Connection connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/funeral", "root", "abc123");

ResultSet rs = null;

Statement statement = connection.createStatement();

String sql = ("INSERT INTO memory VALUES ('" + firstname + "','" + lastname + "','" + address1 + "','"+ address2 +"','"+ address3 +"','"+ city +"','"+ postalcode +"','"+ province +"','"+ memo +"') ");
statement.executeUpdate(sql);

rs.close();
connection.close();

%>---------------------------------------------------

Can someone help? Thanks....

------------------------------------------------------------------------------------------------MY CODE-------------------------------------------------------------------------------------------------------------------------------------------------------

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<html>
<head><title>JSP Page</title></head>
<body>

<%
String school = request.getParameter("name");
String name = request.getParameter("username");
String email = request.getParameter("txtEmail");
String pass1 = request.getParameter("pass1");
String pass2 = request.getParameter("pass2");

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:shobana", "SYSTEM", "nagalakshmi");

Statement st = con.createStatement();

String sql = ("INSERT INTO register VALUES ('" + school+ "','" + name + "','" + email + "','"+ pass1 +"','"+ pass2+"') ");
st.executeUpdate(sql);
con.close();

%>
connection succssful
</body>
</html>

shobana_soma

Reputation Points: 10

Solved Threads: 0

Newbie Poster