Home Answers Viewqa JSP-Servlet retrive data from oracle to jsp

 
 


akshatha
retrive data from oracle to jsp
0 Answer(s)      2 years and 3 months ago
Posted in : JSP-Servlet

i am a beginer in jsp so please help me out..... in file create project i am entering proj details such as id name cost and manager name and storing it in the data base. in search proj fiel if user enters any one of the feild such as id name cost and manager the full details of the project should be displayed.

SearchProjDAO import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.sql.PreparedStatement; import java.util.ArrayList; import java.util.PropertyResourceBundle; import javax.naming.InitialContext; import javax.naming.NoInitialContextException; import javax.sql.DataSource;

import oracle.sql.ARRAY; import weblogic.jdbc.pool.ResultSet;

import cruit.util.DBConnection;

import cruit.vo.SearchProjVO;

public final class SearchProjDAO { private static InitialContext context; String CLASS_NAME="DBConnectionFactory";

public void  submitProjectDetails(SearchProjVO searchprojVO) 
{
    String methodname="createConnection";
    Connection conn  = null;
    PreparedStatement psmt;
    try {
        System.out.println("searchprojVO id=="+searchprojVO.getProjid());
        System.out.println("in DAO");


        conn = DBConnection.getJNDIConnection();
        ArrayList ar = new ArrayList();
        ResultSet rs = null;
        while(rs.next())
        {
            SearchProjVO searchprojVO = new SearchProjVO();
            psmt= conn.prepareStatement("select * from CR_EMPLOYEE_DETAILS");
                psmt.setString(1,searchprojVO.getProjid());
                psmt.setString(2,searchprojVO.getProjname());
                 psmt.setString(3,searchprojVO.getCost());
                psmt.setString(4,searchprojVO.getManager());
                psmt.executeQuery();
                ar.add(searchprojVO);
                            }

        System.out.println("conn==="+conn); 
    } catch (Exception e) {
        e.printStackTrace(System.err);
    } 

}

} SearchProjVO import java.io.IOException; import java.sql.Connection; import java.sql.DriverManager; import java.util.PropertyResourceBundle; import javax.naming.InitialContext; import javax.naming.NoInitialContextException; import javax.sql.DataSource;

public final class SearchProjVO {

String projid;
String projname;
String cost;
String manager;

public String getCost() {
    return cost;
}
public void setCost(String cost) {
    this.cost = cost;
}
public String getManager() {
    return manager;
}
public void setManager(String manager) {
    this.manager = manager;
}
public String getProjid() {
    return projid;
}
public void setProjid(String projid) {
    this.projid = projid;
}
public String getProjname() {
    return projname;
}
public void setProjname(String projname) {
    this.projname = projname;
}

}

in SearchProjDAO i have to call servlet also how can i do this i have connected to data base

View Answers









Related Pages:
retrive data from oracle to jsp
retrive data from oracle to jsp  i am a beginer in jsp so please help... cost and manager name and storing it in the data base. in search proj fiel...(); psmt= conn.prepareStatement("select * from CR_EMPLOYEE_DETAILS
retrive data from database using jsp in struts?
retrive data from database using jsp in struts?   *search.jsp* <... searchProduct(SearchDTO sdto) { String query="select * from product...()); Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521
To retrive data from database - Struts
To retrive data from database  How to get values ,when i select a select box in jsp and has to get values in textbox automatically from database? eg... come to jsp page automatically from database
GWT -- retrive the data from Database
GWT -- retrive the data from Database  the user can create an event... button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url. Means anyone
retrive data from database?
retrive data from database?  hellow i have a database sheet name..... now i want retrive sn,roll no and name and textbox like....,rllno,and name retrive
Request URl using Retrive data from dtabase
Request URl using Retrive data from dtabase  Using With GWT the user... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should
retrive the data from access database to drop down list box in jsp
retrive the data from access database to drop down list box in jsp  hai, im new to jsp now im using the jsp along with access database.in table i load all the data's i need to retrive the data from database to dropdown list box
retrive data from database
retrive data from database   hi.. i made a application form. it's have attribute s.no,name,roll no and i enter a few records. now i want to view all record not in database access sheet i want to view it at any another
By dropdownlist retrive data from database and show in textbox in jsp.
By dropdownlist retrive data from database and show in textbox in jsp.  Hello Sir, I am doing project in jsp.I have to retrive data from database, when I select value from dropdownlist, and that data I want to show in textbox
how to retrive data grom database in jsp pages.
how to retrive data grom database in jsp pages.  sir, i have problem to retrieve data from table of the database on the html web pages , so would... immediately. i want sample code of jsp to retrieving data from table of database to html
store & retrive the image from oracle database
store & retrive the image from oracle database  how can i store the image path in tha database & fetch that image from oracle database
url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp   the user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public
retrive data from data base and print it in every page until logout
retrive data from data base and print it in every page until logout  ... the USER NAME through retriving from database.suppose from home page he go to next... in JSP
java and oracle - JSP-Servlet
java and oracle  hai i am doing a project in which i have stored some data (think as 50 records) in database. Now i want to retrive the data from... Mysql for this purpose. Try the following code: Pagination of JSP
url parameter using retrive data from database in jsp
url parameter using retrive data from database in jsp  The user can... clicks the Preview button, you have to create a dynamic jsp which should read the contents from the db based on the event id. But this jsp url should be a public url
Retrive values from an arraylist and display in a jsp?
Retrive values from an arraylist and display in a jsp?  Hi, I need help in jsp to display values of an ArrayList in jsp. There is a java file.... It might be helpful for you. http://www.roseindia.net/jsp/servlet-jsp-data
Retrive values from an arraylist and display in a jsp?
Retrive values from an arraylist and display in a jsp?  Hi, I need help in jsp to display values of an ArrayList in jsp. There is a java file...://www.roseindia.net/jsp/servlet-jsp-data-list.shtml
how to display or retrive an image in jsp whose path is stored in oracle database
how to display or retrive an image in jsp whose path is stored in oracle database  how to display or retrive an image in jsp whose path is stored in oracle database and the image is stored in my pictures folder
retrive values - JSP-Servlet
retrive values  how to get multiple values from html to jsp
how to load a table of data from oracle, to a jsp page using hashmap.
how to load a table of data from oracle, to a jsp page using hashmap.  I have a jsp page which ask for project ID,team name,member name according to this data i have to retrieve their details from the database(oracle). I have
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp
data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp   data (image ,audio) inserting to data base (oracle 10g) and retriving the same data from jsp with script of data base plz help me
how to read data from excel file through browse and insert into oracle database using jsp or oracle???
how to read data from excel file through browse and insert into oracle database using jsp or oracle???  sir.. i have number of excel sheets which...://www.roseindia.net/answers/viewqa/JSP-Servlet/28123-write-excel-file-into-the-oracle
How to get data from Oracle database using JSP
problem in jsp in the sense to get data from the database like oracle . I have... data from the database like oracle), I have created one jsp program like... in the sense to get data from the database like oracle . I have created one jsp
Retrive only requird data from a table in MYSQL databade to JSP file..on a field submit button.
Retrive only requird data from a table in MYSQL databade to JSP file... from table TR_LIST on typing TR values in an input-text-box and by clicking<Submit> button===> i.e.,select node,package from tr_list where tr='yyy
retrive record from the text field and insert into to database
retrive record from the text field and insert into to database  the following code is inserting values in the my sql database but i want to insert the data into oracle database , i want what changes i have to make
Retrive the data from the table in data base using jdbc
Retrive the data from the table in data base using jdbc  Retrive the data from the table in data base using jdbc   JDBC Tutorials
retrive values - JSP-Servlet
retrive values  how to retrive multiple values from html to jsp  Hi Friend, Try the following code: 1)calljsp.html: Enter Name: Enter Address: Gender:MF Qualification: Btech MBA MCA MSC
how to retrive
ArrayList(); String query = "select * from PRODUCT_LIST"; smp... (Exception e) { System.out.println("......."+e); } } and this is my jsp
insert and retrive data and time - SQL
insert and retrive data and time  hello everybody . Is there any... be retrieve that date and time from database ? ..........................  ... current_dateTime = sdf.format(now) ; String queryString = "select * from
fetch record from oracle database using jsp-servlet?
fetch record from oracle database using jsp-servlet?  how can i fetch data from oracle database by using jsp-servlet. i'm using eclipse, tomcat server and oracle database and creating jsp pages and also using servlet
how retrive data from google analystics dashbord on the client machine
how retrive data from google analystics dashbord on the client machine   sir i am digvijay subj: retrive data from google analystics dashbord respected sir, According above subject i request you , i want retrive data from
Retrive data from databse to a text field - Java Server Faces Questions
Retrive data from databse to a text field  Hi, Can you give me a source code to rertrve data from Mysql databse to a text field using JSF.....by selecting option from a dropdown option
retrive image from database using jsp without stream
retrive image from database using jsp without stream  How to retrive image from database using jsp without stream like (inputStream
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
jsp page connectivity with oracle - SQL
jsp page connectivity with oracle  I am unable to database connectivity jsp with oracle. Please send the code for solving problem. thanks ... * from data"); 5) Close the statement,resultset and connection: rs.close
insert and retrive image from sql server database in jsp
insert and retrive image from sql server database in jsp  what is the code to insert and retrive an image from sql server database in jsp
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end
How to get the data from the database (Oracle) in console or in ie using servlet or jsp as Front end  hello i have a simple problem in jsp in the sense to get data from the database like oracle . I have created one jsp
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data..
Unable to connect servet, jsp to oracle 10g database.. Unable to retrieve data... from oracle sql*plus as rajalakshmi and password by granting privilege from scott... max("+pkid+") from "+tableName); if(rs.next
how to create a bar chart in jsp by fetching value from oracle databse?
how to create a bar chart in jsp by fetching value from oracle databse?  i want to show the population of various states in a bar chart in my jsp page by fetching the data from my oracle table. i am using my eclipse as my IDE
jsp retrive image - JSP-Interview Questions
jsp retrive image  How to Display Images in JSP retrieved from MYSQL database? plz help me..  Hi Friend, Please visit the following link: http://www.roseindia.net/jsp/retrieve-image.shtml Thanks
unable to get datas from oracle database
unable to get datas from oracle database  Dear Sir, I am again struck in my project.. i want to display data from oracle database but i get this error when i run the jsp file in tomcat, I post my code below.. kindly let me
correct the sql error and retrive data....plez
correct the sql error and retrive data....plez  i am getting a SQL Error while retriving data from access to jframe called "datatype mismatch...=con.createStatement(); ResultSet rs=st.executeQuery("select * from STUDENT where
how to retrive the particular data from database in php with mysql?
how to retrive the particular data from database in php with mysql?  ..._db("samp", $con); $Name=$_POST['unames']; $data=mysql_query("SELECT * FROM tbl_sample where Name='$Name'"); /*$info=mysql_fetch_array($data);*/ while
Select tag to fetch data from oracle database
Select tag to fetch data from oracle database  I created a select box... oracle database.Similarly when address will be selected by the user from... of a student and when regnno is selected from the drop down list by a user
unable to retrive the data from mysql using servlet using jdbc driver
unable to retrive the data from mysql using servlet using jdbc driver  Hi, i have a servlet program..to verify the login and redirect to correct... = stmt.executeQuery("SELECT * FROM login where username="+username+" and password
retrive the result of a serach string from other sites - JSP-Servlet
retrive the result of a serach string from other sites  Sir, suppose i have create my own websites, and i want to search an item in my sites and as well as from other search sites and i want to show all the search result in my
error in uploading image from jsp to oracle 10g database
error in uploading image from jsp to oracle 10g database  ... please advice how to get rid of error   JSP upload image in Mysql database...;BODY> <FORM ENCTYPE="multipart/form-data" ACTION="upload.jsp" METHOD=POST>
java and oracle - JSP-Servlet
... data types in oracle database. And I need to write the code in servlets and jsp
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... jsp coding in rose india for sql and i changed the drivers for oracle.. when i try to run the jsp file from tomcat i get this error.. let me know what i am doing
oracle - JDBC
to store these two fields into oracle database for that i have given one jsp page... doing this some times data is inserted and some times data is inserting it is giving error like java.sql.SQLException:[MICROSOFT][ODBC Driver for oracle][oracle