insert code jsp to access

Ads

Share on Google+

Nilay vora

insert code jsp to access
2 Answer(s) 6 years and 8 months ago
Posted in : JSP-Servlet

insert code jsp to access

Ads

View Answers

March 25, 2011 at 12:00 PM

<%@page import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbc:odbc:student","","");

Statement st=con.createStatement();
int i=st.executeUpdate("insert into data(name,address) values('Roseindia','Delhi')");
out.println("Data is inserted successfully");
%>

February 2, 2012 at 10:48 PM

<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<%@page import ="javax.servlet.*" %>
<%@page import= "javax.servlet.jsp.*" %>
<%@ page language="java" %>

<%
JspWriter wr = pageContext.getOut();
Connection con=null;
PreparedStatement pst=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:ruhi","system","system");
pst=con.prepareStatement("insert into repository values(?,?,?,?,?)");
File file=new File("C:\\Documents and Settings\\All Users\\Documents\\My Pictures\\Sample Pictures\\Water lilies.jpg");
FileInputStream fis=new FileInputStream(file);
pst.setString(1,"Ship");
pst.setString(2,"Detroit");
pst.setString(3,"yes");
pst.setString(4,"CompleteProduct");
pst.setBinaryStream(5 ,fis, (int)fis.available());
int i = pst.executeUpdate();
if(i!=0){
wr.write("image inserted successfully");
}
else{
wr.write("problem in image insertion");
}
}
catch (Exception e){
System.out.println(e);
}

%>

Last edited b

Ads

Advertisements

how to insert values from jsp into ms access
how to insert values from jsp into ms access how to insert values using jsp into ms access database

help in insert code - JSP-Servlet
help in insert code I have some doubt in following code. I want to insert value using prepared statement.we r accessing connection from other...;insert regiform values('"+firstname+"','"+address+"','"

How to insert or delete records in MS access database using jsp - JSP-Servlet
How to insert or delete records in MS access database using jsp Hi friends please provide me a solution that i insert or delete record from a database using java server pages. I used the microsoft access 2003 database. PlZ

how to access element added via javascript dynamically using jsp code
not able to access these dynamically added textboxes values from my jsp code...how to access element added via javascript dynamically using jsp code ... javascript dynamically using the jsp code. i am adding empty records on .jsp page

Insert a row in 'Mysql' table using JSP Code
Insert a row in 'Mysql' table using JSP Code In this section, we will discuss about how to insert data in Mysql database using JSP code. Query...; Mysql database Table. Code to insert row in Mysql table : databaseinsertion.jsp

jsp to access query
jsp to access query How to insert the values from jsp to access ? Here is a jsp code that insert the values to MS access database...) Restart your server and run your jsp code. <%@page import="java.sql.*"%> <

insert query in jsp
insert query in jsp give me insert code in jsp at run time

code for insert button
code for insert button i want code for insert button(in image...;The given code uses Swing components to create a image button and allow the user..."); PreparedStatement pstmt = conn.prepareStatement("insert into data(name

insert image - JSP-Servlet
insert image hi friends i am mahesh i am trying to insert image into oracle database using JSP but i am not geting so please friends send me the code for inserting image into database using JSP Hi Friend, Try

How to access the database from JSP?
How to access the database from JSP? Hi, What is the process... you can access the database by embedding the JDBC code. But this is not the best... database from JSP which explains you how to access the database by embedding

Insert and Retrieve Image - JSP-Servlet
Insert and Retrieve Image Hello, I need source code using java servlet or jsp and html form and brief explanations on how to insert and retrieve..., This is insert image code

insert values - JSP-Servlet
insert values How to insert values in the oracle database using JSP... page<html><head><title>Insert value in database</title><...;100%"> <h1><center>Insert value in Database<

cannot insert data into ms access database - Java Server Faces Questions
cannot insert data into ms access database go back... Microsoft Access Driver(*.mdb) 5. Select database name and Create the DSN name (e.g emp) 6. Click "Ok" and then try the JSP. form.jsp: Name: Address

insert code using spring - Spring
insert code using spring Hi, Can any one send code for inserting the data in database using spring and hibernate .. Many thanks, Raghavendra Hi Friend, Please visit the following link: http

MS Access - JSP-Servlet
stepts 1.to configure the ms access database to your system control panel... database for msaccess and then click ok 2.to give the following code "db1...+"'"; ResultSet rs = stmt.executeQuery(query); Hi friend, Code to help

Code to insert date in to database - Development process
Code to insert date in to database Hi , in my following code i want... getting error . plz send me code Error 500--Internal Server Error java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters

jsp code
jsp code what are the jsp code for view page in online journal

To insert attachment file in database in JSP.
To insert attachment file in database in JSP. I am doing project in JSP. How to insert attachment file in mysql database? Please suggest some solution. Your inputs is valuable to me. Hi Friend, Visit Here Thanks

JSP and Database access
JSP and Database access Hi, Please help me with the following program. I am not able to update all the pa column values in my database. csea.jsp: <html> <body> <%@page import="java.sql.*"%> <form method

JSP CODE
JSP CODE what is the code for downloading images from database using JSP? Please visit the following link: http://www.roseindia.net/jsp/downloadimage.shtml

jsp code
jsp code hi i am Ruchi can anybody plz tell me the jsp code... visit the following links: http://www.roseindia.net/jsp/user-search.shtml http://www.roseindia.net/servlets/search.shtml www.roseindia.net/jsp/searchbook.shtml

jsp code
jsp code i want health management system project code using jsp.its urgent

source code in jsp
source code in jsp how to insert multiple images in jsp page of product catalog

How To Insert A New Record to MS Access table database in GUI
How To Insert A New Record to MS Access table database in GUI Hello... that involves inserting a record into a 6-column table in my MS Access database table. I'm... in advance for your help. Below is part of my java code. private class

JSP code
JSP code I get an error when i execute the following code : <... = "insert into name(firstname,lastname) values(?,?)" ; Statement st = con.createStatement(); st.executeQuery(query); %> <jsp:forward page="address.jsp">

To insert attachment file in database in JSP.
To insert attachment file in database in JSP. I am doing project in JSP. How to insert attachment file in mysql database? Please suggest some... code: 1)page.jsp: <HTML> <HEAD><TITLE>Display file upload form

Insert Blob(Image) in Mysql table using JSP
Insert Blob(Image) in Mysql table using JSP In this Section, we will insert blob data(image) in Mysql database table using JSP code. A Blob stores a binary... Blob(Image) in Mysql table using JSP Download Source Code

how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code).... Hi..... i ve... db. cn u plz tel me the code in detail.n i thk it shud b written in jdbc.....i ve written sum code,bt gting so many doubts in that....so plzzzz help

JSP CODE
JSP CODE Please help me as soon as possible.Its Urgent. I am working on my college ALUMNI PORTAL. I want to have a ADD FRIEND option in a user's profile. Please send me code

Ads

Advertisement null

Ads