Register / Login

Win a copy of Microservices Testing (Live Project) this week in the Spring forum!

Divyya Joshi

Ranch Hand

+ Follow

102 Posts 41 Threads 0 Cows

since Jul 15, 2010

Merit Badge info

OCPJP-6 certified.

India

Cows and Likes

Cows

Total received

0

In last 30 days

0

Total given

0

Likes

Total received

1

Received in last 30 days

0

Total given

5

Given in last 30 days

0

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Divyya Joshi

Unable to create connection to MS-access database from JSP form

What i am getting is an error in line number 14 and 16. I think it means connection is not getting created.

Here's the code:

import java.io.*;
import java.net.*;
import javax.servlet.*;
import javax.servlet.http.*;
public class insertt extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
String fname=request.getParameter("fname");
String lname=request.getParameter("lname");
try{
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection("jdbc:odbc:root");
out.println(fname);
Statement st=con.createStatement();
int i=st.executeUpdate("insert into student(firstname,lastnamee) values('"+fname+"','"+lname+"')");
out.println("Data is successfully inserted!");
}
catch(Exception e){
System.out.print(e);
e.printStackTrace();
}
out.close();
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return "Short description";
}
// </editor-fold>
}

10 years ago

JDBC and Relational Databases

Unable to create connection to MS-access database from JSP form

The problem is that connection is not getting created. I want to insert data but i am not able to create connection.

10 years ago

JDBC and Relational Databases

Unable to create connection to MS-access database from JSP form

Bear, i will keep this in mind.
Please help me toh correct this.

10 years ago

JDBC and Relational Databases

Unable to create connection to MS-access database from JSP form

Hello everyone,
I am facing problem adding data from JSP form page into MS-Access(database). Please help me correct this.

Here's the code
1. form.jsp

2. insert.jsp

Please help me correct it
Thanks in advance.

10 years ago

JDBC and Relational Databases

ServletConfig in Constructor

Can anyone please tell why can't we use ServletConfig in constructor?
I read Kathy Sierra for SCWCD-1.5 but still i am not able to understand the exact reason
Please guide me.
Thanks in advance.

10 years ago

HTTP status 500-

hello friends, i was just trying to select data from database using servlet . but i am getting following error when trying to execute this.
webpage

And code for the program is

import java.beans.Statement;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
@WebServlet(name = "dii", urlPatterns = {"/dii"})
public class dii extends HttpServlet {
protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException, ClassNotFoundException, SQLException {
response.setContentType("text/html;charset=UTF-8");
PrintWriter out = response.getWriter();
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc.odbc.data1");
Statement stmt=(Statement) con.createStatement();
stmt=(Statement) con.prepareStatement("select * from div");
} finally {
out.close();
}
}
// <editor-fold defaultstate="collapsed" desc="HttpServlet methods. Click on the + sign on the left to edit the code.">
/**
* Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
* @throws ServletException if a servlet-specific error occurs
* @throws IOException if an I/O error occurs
*/
@Override
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}
/**
* Returns a short description of the servlet.
* @return a String containing servlet description
*/
@Override
public String getServletInfo() {
return "Short description";
}// </editor-fold>
}

Kindly anyone tell where am i going wrong. Also i have succesfully tested the datasource created .

10 years ago

Other IDEs, Version Control

Connection failing when creating datasource

Thanks friends i got it corrected on myu own. I was giving wrong server name.
Thanks

10 years ago

Other IDEs, Version Control

Connection failing when creating datasource

Hey friends ,
I am trying database connectivity in to SQL Server 2005 using servlet but i am not able to create datasource. Connection fails each time i try to do so.
I am using Netbeans 7.0.1 and database as SQL server 2005.
Can any one help me correct this one.
Thanks in advance

10 years ago

Other IDEs, Version Control

SCJP - Study group

Hello friends even i am interested in joiming this group.
Kindly give details regarding it.

10 years ago

Programmer Certification (OCPJP)

Passed today: my advice on materials

Good one

10 years ago

Programmer Certification (OCPJP)

JSP login: username and password getting default values

Piyush and Aravind Thanks a lot for your reply.
Aravind , You mean that i should apply smthing for "remember password ". Can you please explain it to me that how can i do it.
Thanks in advance

10 years ago

JSP login: username and password getting default values

Hey friends ,
The following code accepts username and password when executed first but in other attempts to execute it does'nt accept and shows previous entered values in text boxes
Here's the code

I want it to accept username & password each time user logins
Thanks for paying attention.

10 years ago

Certification Results

JSP login: username and password getting default values

Hello friends ,
I prepared a login page using JSP which should accept username and password each time user logins but the following code accepts username and password only one (in beginning) and the other time i execute the code it displays the value i entered earlier.
Here's the code

10 years ago

Cleared OCPJP with 91%

Gaurav as far as duration is concerned i feel it may varies.
I feel it will take complete week hard work with no distraction provided you have an overview of Object Oriented Concepts.
It took me almost a month to prepare.

10 years ago

Certification Results

Cleared OCPJP with 91%

Gaurav i just refered K&B and practised Examlabs mock test(you can install it from google, its just free of cost and gives real exam like environment). Initially my score was as low as 25% in Examlabs even though i had gone through K&B twice.
But with god's blessings i did'nt gave up and you won't believe that a day before exam my score was 53 .
I gave test given on K&B CD and i scored just 61 even though i practised open exam book question which are just similar to closed exam questions. On exam day , just RELAX...

Like everyone says real exam is much easier than given in K&B and very much simpler then mock test.
Believe in god and remember "Hard work is key to success".
All The Best

10 years ago

Certification Results