database is connected but not insert the data
hi,
i am getting connected to database.Retrive the data also but cannot insert the data into database. i am using msaccess2007.my inserstudententry.jsp code is follows,pls help me
<%@page language="java"
import="java.sql.*"
import = "java.util.*"
import = "java.io.*"
import = "java.sql.*"
import = "java.lang.*"
import = "javax.servlet.*"
import = "java.text.*"
%>
<%!
String removeNull(String str)
{
if(str==null)
return "";
else
return str;
}
%>
<%int i=0;
String msgsuccess=null;
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:Driver={Microsoft Access Driver " +
"(*.mdb, *.accdb)};DBQ=C:\stud.accdb";
Connection con = DriverManager.getConnection(url);
out.println("Connected!");
Statement st=con.createStatement();
String name=removeNull(request.getParameter("stuname"));
String phno=removeNull(request.getParameter("stuphone"));
String addr=removeNull(request.getParameter("stuadd"));
String sec=removeNull(request.getParameter("stusec"));
String strSTUNO="select (max(sno)+1) as ssno from studentmaster where status='"+sec+"'" ;
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery(strSTUNO);
String stuno="";
String stuno1="";
out.println(strSTUNO);
while(rs.next())
{
stuno=removeNull(rs.getString("ssno"));
}
SimpleDateFormat sdfd=new SimpleDateFormat("dd/MM/yyyy");
java.util.Date dt1= new java.util.Date();
String dt=sdfd.format(dt1);
String batch=dt.substring(6,10)+sec+"T";
out.println(batch);
stuno1=batch+stuno;
//PreparedStatement pst=con.prepareStatement("insert into studentmaster(slno) values('"+batch+"')");
i=st.executeUpdate("insert into studentmaster(slno) values('"+batch+"')");
out.println(i);
if(i!=0)
{
msgsuccess=" Record Inserted Successfully...";
request.setAttribute("msgsuccess",msgsuccess);
//con.commit();
con.close();
//System.out.println("Private DTR "+dtrcode+" Inserted Successfully");
response.sendRedirect("studententry.jsp?msgsuccess="+msgsuccess);
}
%>
<%}
catch(Exception e)
{
throw e;
}
%>
View Answers
February 24, 2011 at 1:09 PM
What do you wanted to do through this page? Your problem is not clear to us.Please specify some details.
Related Tutorials/Questions & Answers:
database is connected but not insert the datadatabase is
connected but not
insert the data hi,
i am getting
connected to database.Retrive the
data also but cannot
insert the
data into
database... = DriverManager.getConnection(url);
out.println("
Connected!");
Statement st
insert and delete data in databaseinsert and delete
data in database
insert and delete
data in
database from servlets through JDBC
Hi Friend,
Please visit the following links:ADS_TO_REPLACE_1
Insert Data
Delete
Data
ThanksADS_TO_REPLACE_2
Advertisements
insert data into databaseinsert data into database hi,thanks for reply
just i am doing... and studentmaster is the
database table name.
i am using same details.
Now give the
data into the jsp page that
data stored into the database.Here the error
unable to insert data into database unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
unable to insert data into database unable to
insert data into
database hello.i have a problem in inserting
data into database.i have used two prepared statement.one for retrieving the eid based on ename and the other is inserting
data into
database based
insert data into databaseinsert data into database type Exception report
message...)Go to the start->Control Panel->Administrative Tools->
data sources.
2... selecting the driver, click finish button.
4)Then give
Data Source Name
To insert maximum number of data in database.To
insert maximum number of
data in
database. how to change string
data type into clob
data type in jsp
Hi Friend,
Please visit the following link:ADS_TO_REPLACE_1
http://www.roseindia.net/jdbc/
insert-clob
insert data in the database using checkboxinsert data in the
database using checkbox i am fetching
data from the
database using servlet on the jsp page and there is checkbox corresponding... should i
insert only checked
data into
database on submission.
We
Insert file data into databaseInsert file
data into
database
In this section, you will learn how to
insert the file
data into
database.
Description of code:
Here we have used FileReader.... Now to
insert this
data into the
database, we have
established a
database Question about "Insert text file data into Database"Question about "
Insert text file
data into
Database" Hey
I was reading the tutorial "
Insert text file
data into
Database", (awesome btw), and noticed that both a FileInputStream, a DataInputStream and a BufferedReader
how to insert data into database using jsp & retrivehow to
insert data into
database using jsp & retrive Hello,
I have created 1 html page which contain username, password & submit button. in my oracle10G
database already contain table name admin which has name, password
how to insert data in database using html+jsphow to
insert data in
database using html+jsp anyone know what... and
database name. Here machine name id localhost and
database name... = null;
// declare a resultset that uses as a table for output
data from
Insert XML file data to databaseInsert XML file
data to
database
In this tutorial, you will learn how to
insert the xml file
data to
database
using dom parser.
You all are aware of XML... to read the xml file
data and save the values
of an XML file to a
Database AJAX- Database not connected - AjaxAJAX-
Database not connected Respected Sir/Madam,
I am Ragavendran.R.. I am working with AJAX and
Database.. Ajax code works fine but the
database values are not retrieved if queried.. Instead, I could receive
Insert text file data into DatabaseInsert text file
data into
Database
In this section, you will learn how to
insert the text file
data into the
database. For this purpose, we have created... the
data to the ArrayList.
This list is then iterated through the Iterator
applet connected to table in MS Access database applet
connected to table in MS Access
database i have
connected my...();
//
insert data
insertData();
//use precompiled statement to update
data...());
}
}
//
insert data to table COFFEES
static void insertData() {
try
insert datainsert data i've got a problem to
insert my
data to database.i can...("
insert into images values(?,?,?,?,?)"); st.setString(2... and as well as the passed
data from mulitpart/form-
data is greater than or equal to 0
Insert data in Excel File from Database using JSP will retrieve the
data from
database, create an excel file and
data
insert...
Insert data in Excel File from Database using
JSP ... developed a application to
insert data in excel file from
database in JSP. We
Insert database values in the fileInsert database values in the file
In this section, you will learn how to retrieve the
data from the
database
and
insert into the file.
Description of code... the
database and stored it into arraylist. Then we have called the method
writeToFile
Insert Mysql Blob data Insert Mysql Blob data
In this section, we will discuss about how to
insert a blob
data into a
database table. A Blob stores a binary large object in the
database table's row.
Blob object contains a logical pointer
Insert image in databaseInsert image in database Want a jsp-struts program in which the imageFile is in the form of getter and setter and inserted in the
database as a Blob using . and then download the image and show on next jsp pg. No use
Servlet to add the data into database
Servlet to add the
data into
database
... the
data in the
database table from a html form.
This servlet program....
The
data can be inserted
in the
database that reacquired connection
Insert Records in Table;
The
Insert data in Table is used to insert records or rows into the
table in
database. The Syntax used to
insert records into a table... with Example
The Tutorial illustrates an example from
Insert data in Table