db

Home Answers Viewqa Java-Beginners db

daksesh

db
0 Answer(s) a year and 2 months ago
Posted in : Java Beginners

<%@ page import="java.sql.*" %>
<%@ page import="java.io.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
<h2><center>TELECOM STORE INVENTORY</center></h2>

<title>Add Product</title>
<table>
    <tr>

    <td width="800"><p align ="center"></p></td>

    </tr>
</table>


<table align="center" border="3" cellpadding="7" cellspacing="2"  >

    <tr>
    <td width="220" align="center" bgcolor="#B0C4DE"><font size="5"  ><a href="main1.html">  Home  </a></font></td>
    <td width="220" align="center" bgcolor="#B0C4DE"><font size="5" color=""><a href="main2.html">  Product  </a></font></td>
    <td width="220" align="center" bgcolor="#B0C4DE"><font size="5" color=""><a href="main3.html" >  Stock  </a></font></td>
    <td width="220" align="center" bgcolor="#B0C4DE"><font size="5" color=""><a href="main4.html">  Sales Promotion  </a></font></td>

    </tr>
</table>
<h2><center></>UPDATE PRODUCT MODEL</center></h2>
</head>
<body>
<form name="update" method="post" action="Login">
<%
        String connectionURL = "jdbc:oracle:thin:@localhost:1521:XE"; 
        Connection connection = null;
        Statement statement = null;
        ResultSet rs = null;
        Class.forName("oracle.jdbc.driver.OracleDriver").newInstance();
        connection = DriverManager.getConnection(connectionURL, "system", "ora10g");
        statement = connection.createStatement();
        String QueryString = "SELECT * from producttest";
        rs = statement.executeQuery(QueryString);%>
 <table  align="center" cellpadding="10" cellspacing="10" >

<tr>
    <td>Product Model Name</td>
    <td><select name="productName">
     <%
     if (  (request.getAttribute("a") == null ))
     {
        while (rs.next())
        {
        %><option><%=rs.getString(1)%></option><%
        }}
        else
        {%>


    <option><%=request.getAttribute("a")%></option>
  <%} %>
    </select></td>
    <td><input type="submit" value="Search" name="searchproduct"></input></td>
  </tr>
  <%
        if (  (request.getAttribute("a") != null )||(request.getAttribute("b") != null ) || (request.getAttribute("c") != null ) || (request.getAttribute("d") != null)  || (request.getAttribute("e") != null ) )
        {
        %>


  <tr>
    <td>features</td>
    <th><input type="text" name="features" value=<%=request.getAttribute("b")%>></th>
  </tr>
  <tr>
    <td>Description </td>
    <th><input type="text" name="Description" value=<%=request.getAttribute("c")%>></th>
  </tr>

  <%} 
        else
        {%>

          <tr>
            <td>features</td>
            <th><input type="text" name="features"></th>
          </tr>
          <tr>
            <td>Description</td>
            <th><input type="text" name="Description"></th>
          </tr>

        <% }%>
</table>
 <center><input type="submit" value="UPDATE" name="updateproduct"></center>
</body>

View Answers

db connectivity
db connectivity hi i am beginner in objective c lang and having knowlwgde of basic syntax of this lang and need statements that can be used to connect to sqlite. please do send me the simple example code. i am using GNUstep

DB connectivity - EJB
DB connectivity DB connectivity

JSP,DB

no data in db

j2me with derby db - MobileApplications
j2me with derby db Hello, Presently Iam working on the j2me(wireless toolkit2.0).I have done so many applns in j2me,but I want to install derby db in j2me.I am new to derbydb. Can u tell me briefly abt derby db,which version

about db - Struts
About DB in Struts I have one problem about database. i am using netbeans serveri glassfish. so which is the data source struts config file should be? Please help me

Zend Db error - WebSevices
Zend Db error Hello friends, How i get the values from the database using zend framework Any one know the code. Help me

getting db in action class
getting db in action class hi, Am usin struts in ma application... n i need to interact with the db .. so i used.. getDataSource(request) but it gives me an error.. java.lang.NoSuchMethodError: LoginAction.getDataSource(Ljavax

Server DB connection - JDBC
Server DB connection Hello Guys I want to connect two databases at the same time but it looks like the java is only picking up the second database. One database is on my localhost and the other one is on server, I want

JSP,DB,SERVLET
JSP,DB,SERVLET I have a jsp page with 3 text fields name,age ,city.i populated these datas into a database table.I have another jsp page with 4 fields name, city , age and phone.Once the user enter the name, city and age should

ERRor in executing DB program
ERRor in executing DB program While executing following code an Error was generated.can any one help me for this. LiveDB liveDBObj = DataSourceFactory.getLiveDBInstance(); PreparedStatement pstmt=null; String qry=""; qry

Aggregrate function Max() in db
Aggregrate function Max() in db Hi everyone i have a question and stuck with this problem. i have a table like Brand in mySql db where brandid(varchar) is generating automatically.. im having a Db connection class and a method

db error - Java Beginners
db error Hi, how to insert text area content into database...://192.168.10.126/"; String db = "roseindia"; String driver = "com.mysql.jdbc.Driver...(driver); con = DriverManager.getConnection(url+db, user, pass

how to migrate java db to mysql
how to migrate java db to mysql I have an aplication,for migrating java db to mysql db.how it will done

DB Schema Viewer
DB Schema Viewer DB Schema Viewer is an Eclipse plugin that builds a graphical view of an existing database. Reverse Engineering is performed through JDBC

JSP,DB,SERVLET
JSP,DB,SERVLET hi thank you for your reply.With this code i can insert the data successfully into database but In ajax.jsp once i give the name;;;age and city are not automatically fetched......instead sumthing get filled

JSP,DB,SERVLET
JSP,DB,SERVLET hi thank you for your reply.With this code i can insert the data successfully into database but once i give submit button in insert.jsp it should be forwarded to ajax.jsp.In ajax.jsp once i give the name;;;age

JSP,DB,SERVLET
JSP,DB,SERVLET I have a jsp page called page1.jsp with 3 text fields name,phone ,city.i populated these datas into a database table through servlet (page1servlet.java) and bean(page1bean.java).I have another jsp page(display.jsp

Java DB
Java DB Java DB is an open source Apache Derby database supported by Sun. Java DB is completely written in the Java programming language having the functionality write once run

Java and DB - Java Interview Questions
Java and DB What is the difference between database null and Java null

Db - Java Beginners

Comparison of corresponding rows in a DB

java connecting to oracle db

DB Visual Architect for Eclipse
DB Visual Architect for Eclipse Extensive Database Coverage DB Visual ARCHITECT... developers and DB administrators can create diagrams much faster than any tool

Entity DB design pattern - Java Interview Questions
Entity DB design pattern I want the information for Entity DB design pattern

same thing i want but from db..
same thing i want but from db.. http://www.roseindia.net/tutorial/javascript/dynamicCombo.html same thing i want but from db

View Photo From Db MySql
View Photo From Db MySql Good Morning Sir, Please help me, I make a small code but i have a error. I want to make viewer photo from database MySql into my project in netbeans. this is my code : try

JAVA DB connenting Office access..
JAVA DB connenting Office access.. hai friends....iam shackir.. i did 1 program to connect OfficeAccess...in this program everything except insertions are working fine...i cant understand what is the problem..."ANY ONE PLEASE

how to featch data form db?
how to featch data form db? how to featch data form db? /* * To change this template, choose Tools | Templates * and open the template in the editor. */ package com.tcs.ignite.app.servlets; import

Todd oracle DB connection through PHP
Todd oracle DB connection through PHP Can u please explain how to connect Todd oracle DB using PHP & What are the setups we need to perform? Thanks

java connecting to oracle db - JDBC

javascript variable value insertion in DB

retrieving from db - JSP-Servlet

DB Schema Viewer
DB Schema Viewer DB Schema Viewer is an Eclipse plugin that builds a graphical view of an existing database. Reverse Engineering is performed through JDBC

Saving image and text in mysql db using spring?
Saving image and text in mysql db using spring? Hii, My requirement is to save the employee details(including image) into mysql db.i want to save the image location in db .And actual image(binary formate) should save

Mysql DB backup size increases rapidly
Mysql DB backup size increases rapidly we are using mysql 5.1 with jboss application server. recently database size increases rapidly. it goes upto 8GB. how can we optimize the DB? or shall we delete any log files? let me know

to upload a table from DB to the same html page
to upload a table from DB to the same html page how to make this booklist table to be opened in the same html page itself using a third frame

where is my sqlite data files(.db) will be saved?
where is my sqlite data files(.db) will be saved? Hi, i am using SQLite with JDBC in Netbeans 7.1.1 for my project. So far, i am dealing... of SQLite will be stored in my computer? Also whether my .jar file will include the db

upload csv to mysql db using jsp upload
upload csv to mysql db using jsp upload Hello all, Please give me the code to uplad .csv from jsp page and insert values into MySQl db. I have a table with 8 cloumns.(MDN--varchar(30),Otafdate date,crt varchar(30),dmdn

Hibernate Performing the usual DB operations
HIBERNATE-BASICS Hibernate Performing the usual DB operations (part-2) ... the usual DB operations. Hybernate2 can be downloaded from http

help me in inserting data into db using hibernate
help me in inserting data into db using hibernate How to insert data into dependent tables through hybernate Hi Friend, Please visit the following link: http://www.roseindia.net/hibernate/insert-data-database.shtml

retrieving info from DB using struts?
retrieving info from DB using struts? Hi. I was looking info about retrieving info from a database using struts. I need a .java that I suppose connects to a database and show the info on a jsp. Somebody could help me

URGENT: Export Table in Oracle db to CSV file
URGENT: Export Table in Oracle db to CSV file Hi, Could you basically help me by providing a program in Java. I want a program to connect and export a table in the oracle database to a folder in my local harddrive. Thankyou

Read data from Excel and insert in to DB and export data from DB to Excel
Read data from Excel and insert in to DB and export data from DB to Excel Read data from Excel and insert in to DB and export data from DB to Excel Hi, I need to read the data from excel and I need to insert the same in to DB

how to insert, retrieve data from,to db(code)....
how to insert, retrieve data from,to db(code).... Hi..... i ve... that data will b stored in db(m using sybase). 2.also hw to retrieve the data from db. cn u plz tel me the code in detail.n i thk it shud b written in jdbc

JSP:select image for db and display in image tag
JSP:select image for db and display in image tag Hi, i am new to this forum. My query is that, i am trying to display image in tag but i am not getting, how to do this by using this code. plz help me. if(rs1.next

JSP:select image for db and display in image tag
JSP:select image for db and display in image tag Hi, i am new to this forum. My query is that, i am trying to display image in image tag but i am not getting, how to do this by using this code. plz help me. if(rs1.next

Latest
Frameworks
Category