1,105,363 Community Members

How to insert data into database?

Member Avatar
obelisk
Newbie Poster
2 posts since May 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
1
 

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....

Member Avatar
adityabakle
Newbie Poster
8 posts since Aug 2004
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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

Member Avatar
obelisk
Newbie Poster
2 posts since May 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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.

Member Avatar
server_crash
Postaholic
2,106 posts since Jun 2004
Reputation Points: 64 [?]
Q&As Helped to Solve: 29 [?]
Skill Endorsements: 28 [?]
 
0
 

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.

Member Avatar
jwenting
duckman
8,359 posts since Nov 2004
Reputation Points: 1,399 [?]
Q&As Helped to Solve: 447 [?]
Skill Endorsements: 35 [?]
Infraction Points: 5
Team Colleague
 
0
 

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.

Member Avatar
harika_reddi
Newbie Poster
1 post since Jun 2005
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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);
}
%>
Member Avatar
jlenyi
Newbie Poster
3 posts since Jun 2008
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
0
 

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 !

Member Avatar
shobana_soma
Newbie Poster
2 posts since Nov 2009
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]
 
-1
 

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>

Member Avatar
javaAddict
Nearly a Senior Poster
3,274 posts since Dec 2007
Reputation Points: 900 [?]
Q&As Helped to Solve: 448 [?]
Skill Endorsements: 8 [?]
Team Colleague
Featured
 
1
 

------------------------------------------------------------------------------------------------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>

And what is the point of this post? This is a 4 year old thread which has been revived 1 year ago, with no useful information. Can someone please close this?

You
This article has been dead for over three months: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article