User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the JSP section within the Web Development category of DaniWeb, a massive community of 397,751 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,585 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our JSP advertiser: Lunarpages JSP Web Hosting

How to insert data into database?

Join Date: Aug 2004
Posts: 8
Reputation: adityabakle is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
adityabakle adityabakle is offline Offline
Newbie Poster

Re: How to insert data into database?

  #2  
May 9th, 2005
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
Reply With Quote  
All times are GMT -4. The time now is 3:24 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC