Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa JSP-Servlet database is connected but not insert the data
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


tummalamithilesh
database is connected but not insert the data
1 Answer(s)      3 years and 10 months ago
Posted in : JSP-Servlet


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

%>


Advertisement
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 data
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... = DriverManager.getConnection(url); out.println("Connected!"); Statement st
insert and delete data in database
insert and delete data in database  insert and delete data in database from servlets through JDBC   Hi Friend, Please visit the following links: Insert Data Delete Data Thanks
Advertisements
insert data into database
insert 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 database
insert 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: http://www.roseindia.net/jdbc/insert-clob-example.shtml Thanks
insert data in the database using checkbox
insert 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 database
Insert 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
AJAX- Database not connected - Ajax
AJAX- 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
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 & retrive
how 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
what is the jsp coding to insert a data in database tables
what is the jsp coding to insert a data in database tables  Dear Sir, I Want to know the coding for insert the data from jsp to oracle database.. my... that insert the form values to MySQL database. 1)register.jsp: <html> <form
how to insert data in database using html+jsp
how 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 database
Insert 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
Insert text file data into Database
Insert 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
i need program to insert data in database using javascript
i need program to insert data in database using javascript  please help me
using ajax i want to insert data into oracle database
using ajax i want to insert data into oracle database  i would like to insert/update/select/delete from jsp to oracle database using ajax? please send a code for this iam using oracl database thank you
how to insert data from database using oops concepts - Development process
how to insert data from database using oops concepts  Hi, How to insert data from database using oops based concepts.please write the code... the following code: import java.sql.*; class Insert{ public static String url
How to insert data from textfields into database using hibernate?
How to insert data from textfields into database using hibernate?   try{ Session session = HibernateUtil.getSessionFactory().openSession...); System.out.println("Successfully data insert in database"); tx.commit
cannot insert data into ms access database - Java Server Faces Questions
cannot insert data into ms access database   go back... connection: 1. Open Data Sources (Start->Control Panel->Administrative Tool->Data Sources(ODBC) 2. Open User DSN tab 3. Add a user DSN 4. Select
java script unable to connect to oracle database and insert data
is to insert data from jsp to oracle database 8, so i create a table in oracle...java script unable to connect to oracle database and insert data  ...=con.createStatement(); int i=st.executeUpdate("insert into departments
How to Insert image and data both together in database in JSP/Servlet ?
How to Insert image and data both together in database in JSP/Servlet ? ... = connection.prepareStatement("insert into data(Name,City,Img) values('"+nn+"','"+cc...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION
Problem insert data into database using servlet n javabean - Java Beginners
Problem insert data into database using servlet n javabean  I created a servlet for registration proses I got a problem compiling my servlet... = conn.createStatement(); rs = stmt.executeUpdate("INSERT INTO login(name,userid
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
insert data using drop down box in java into database postgresql
insert data using drop down box in java into database postgresql  can you help me out !!.......i wanna to know the appropriate java syntax to insert data into database using an drop down box .....as i m using eclipse as jdbc
 

 

 

DMCA.com