Can't Retrieve Employees IDs
Oct 15, 2014
If my xml file (shown below as sample) has different employees with id's - is there a way I can get just the id's on there own?
Java Code:
<Employees>
<Employee id="1">
<age>29</age>
<name>Pankaj</name>
<gender>Male</gender>
<role>Java Developer</role>
</Employee>
<Employee id="2">
<age>35</age>
<name>Lisa</name>
<gender>Female</gender>
<role>CEO</role>
</Employee>
</Employees> mh_sh_highlight_all('java');
This is the code Im using - I know at the minute it gets the id details of id 3 but realistically I just want the id's and nothing else
Java Code:
private static String getEmployeeById(Document doc, XPath xpath, int id) {
String env = null;
try {
XPathExpression pathExpression =
xpath.compile("/Employees/Employee[@id=3]"); // line gets everything to do with id 3 but doesn't display the id
[code]....
Can this be achieved using xpath? I've been stuck on it for ages and I can't seem to really find anything to do with it
View Replies
ADVERTISEMENT
Apr 26, 2014
I have now four types of employees. Managers (who receive a fixed weekly salary), Design workers (who receive a fixed hourly wage for up to the first 40 hours they work and "time-and-a-half," i.e., 1.5 times their hourly wage, for overtime hours worked), Sales workers (who receive a $250 plus 5.7% of their gross weekly sales), and Manufacturing (who receive a fixed amount of money per item for each of the items they produce -- each manufacture in this company works on only one type of item). and here are my classes:
employee class
the problem is i get this output:
You chose to open this file: Employees.txt
John Smith Manufacturing 6.75 120 444
0.0
Betty White Manager 1200.0 0 111
0.0
Stan Slimy Sales 10000.0 0 332
250.0
Betty Boop Design 12.5 50 244
0.0
meaning that it is getting 0 for all my calculations and leading to this weekly report:
WEEKLY PAY REPORT FOR Wacky Widgets COMPANY
Employee
0
WEEKLY PAY
250
Total Payroll: $0.0
Total number of managers paid:1
Total number of Design Employees paid:1
Total number of Sales Employees paid:1
Total number of Manufacturing Employees paid:1
fixing my methods so they can accept the integers of the file and use them in the calculation since all im getting at the moment are 0 values.
here is the abstract class from which all the other employees type are extending from
public abstract class Employee {
public abstract double calculateWeeklyPay();
private String fName;
private String lName;
private int EmpId;
private Position p ;
[code]....
View Replies
View Related
Oct 5, 2014
i am very new to java programming what i am doing wrong here. Write a program that calculates how much an employee would earn over a period of time (in months), if, every month, the employee’ pay-per-hour rate is one dollar more than the month before (so if his starting perhour rate is 7.25, next month it will be 8.25, next month 9.25, and so on). The employee is going to work 20 hours per week, 4 weeks per month.
The program should input from the user and validate both number of months (which should be a positive integer larger than 0) and the pay-per-hour rate (which should be a floating-point number larger than $7.25 – the minimum federal wage pay-per-hour rate). For each one of these values; if the value is wrong, the program should repetitively ask for that value until the value entered is correct. The program should confirm/output the correct value.
/*
This program calculates how much as employee would earn if every month the employee pay per hour would increase by a dollar
*/
package nick.employee;
import java.util.Scanner;
public class nickemployee {
[Code]...
what i am doing wrong
View Replies
View Related
Jan 9, 2015
I need to retrieve an image from the MySQL DB and display it in my JSP. The code below retrieves and displays the image with success. But, an exception is thrown:
SEVERE: Servlet.service() for servlet [jsp] in context with path [/FileFinalText] threw exception
[java.lang.IllegalStateException: getOutputStream() has already been called for this response] with root cause
java.lang.IllegalStateException: getOutputStream() has already been called for this response
[code]...
how can I resolve the cause with the getOutputStream() and prevent this exception to occur?
View Replies
View Related
Mar 7, 2014
String charAt() method returns a particular Character at the specified index in the String.
How is this function implemented internally?. How a particular character can be retrieved from String?.
View Replies
View Related
Nov 25, 2014
I wish to retrieve just one value from db;
so I use this code:
@Transactional
public long getSequenceSedeB(Long id) {
BigDecimal seqValue = nu
String sql = "SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id";
SQLQuery query = getSession().createSQLQuery(sql);
[Code] ....
But it do not works; this is the log.
type.NullableType (NullableType.java:182) - could not read column value from result set: ID; Invalid column name
2014-11-25 14:45:14,476 WARN [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:77) - SQL Error: 17006, SQLState: null
2014-11-25 14:45:14,478 ERROR [btpool0-2] util.JDBCExceptionReporter (JDBCExceptionReporter.java:78) - Invalid column name
But in the database the query
SELECT MAX(ID) FROM SEDE_B_ALLEGATI_A WHERE ID_SEDE=:id
run correctly;
Also I need to rewrite the statement
query.setParameter("id", 923);
in this way
query.setParameter("id", AAA);
where AAA is gotten from out of the procedure;
View Replies
View Related
Apr 20, 2015
I am pretty new to java and where I should start. What I am trying to do, is to retrieve live information from poker sites as I play, typically my hand and the pot size. Is this possible? I know poker sites probably are very secure, but I can see those things (my hand, and the pot) anyway, I just want it to happen automatically. What I am trying to do, is to create a program that retrieves the information, and then calculate the odds of me winning.
View Replies
View Related
Apr 2, 2014
I have retrieve the data in listbox from my database already and now again i want to select the data from this listbox and query on it , is it possible?
For Ex i have listbox as follows
<h4>Models For Selected Pattern:</h4>
</br>
<select Name="drop_model" multiple="true">
<%
try {
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url,username,userPassword);
Statement stmt = conn.createStatement();
[Code] ....
In this listbox some values are retrieved from database as
<option value="xyz">xyz</option>
<option value="pqr">pqr</option>
<option value="abc">abc</option>
<option value="lmn">lmn</option>
I want to select this values from listbox and query on them....
View Replies
View Related
Jan 20, 2014
<html>
<body>
<form action="login">
Male:<input type ="radio" name ="sex" value="Male"> <br>
Female:<input type = "radio" name="sex" value="Female"> <br>
<input type="submit" value="Enter">
[Code] ....
when the see the result i just get a strange value as "ON" but I am not getting the required value ,I mean Male or Female.
View Replies
View Related
May 8, 2014
I have one table in mysql in that some rows are there i want to retrieve all rows using servlet and jsp concept and i have done half of the way but not getting output it is showing some info and nothing getting printed on page except columns heading and here is my bean class..
public class TimeDetailBean {
private Time intime;
private Time outtime;
private Date date;
private String eid;
public Time getInTime() {
return intime;
[Code] .....
View Replies
View Related
Mar 3, 2015
I'm trying to iterate through an array of integers and find the start position of the part of the array containing the most consecutive 1s.
For example given the array {1,3,1,1,1,1,5,3,2,1,1}, the method should return 2 and given {1,4,5,1,1,1,5,1} the method should return 3.
So far, I've managed to retrieve the element where the consecutive 1s begin. However, I'm unsure how to get the index of this element and this implementation doesn't work if there is more than one set of consecutive 1s.
public class GetIndex {
public static int getPosition(int[] myArray) {
int index = 0;
int tracker = 0;
int mostOnes = 0;
for(int i = 0; i < myArray.length; i++) {
[Code] .....
View Replies
View Related
Mar 6, 2015
I have to create a webpage such that there is an 'import' and 'save' button.
When the user clicks import button, it will retrieve inventories under PRODUCTS table which contains product title, SRP and Sold by (input field) under his account. Average possible returned rows will be around 1k-5k. If the 'Sold By' has value, it will show as read only. But if not, it will be editable.
Then the user has a list of product IDS printed on a paper that was sold by his employees and he has to scan each product id and put the name of his employee under Sold By and the price sold. This is a manual procedure..
Then after he finishes encoding, he has to click save button to save changes in the db.
what is the best way to implement this? Is it efficient to use js functions such as datatables?
View Replies
View Related
Nov 27, 2014
create table imagedb (usd varchar(255) , image blob , primary key (usd), foreign key (usd) references logindb(user) on update cascade on delete cascade)
Using JSP i am able to upload the file into the blob. But icant retrieve or display;
The HTML Tag :
<table style="margin: 0px; margin-top: 15px;">
<tr>
<td id="photo">
<img src="displayimage" />
</td>
</tr>
The Servlet
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
Connection conn = null;
Statement stmt = null;
try {
conn = (Connection) DriverManager.getConnection(DB_URL, USER, PASS);
stmt = (Statement) conn.createStatement();
// constructs SQL statement
Class.forName("com.mysql.jdbc.Driver");
Scanner s = new Scanner(System.in);
[code].....
I am not getting the image.
View Replies
View Related
Nov 4, 2014
I am creating a shopping list, with each element and object called product from the Item attribute class. Each product object has a description, price, and priority. From user input, I am able to create each product object, and then .add to my arraylist. I know that it successfully adds because I have it printed in each iteration of the do-while loop. Once the user indicates they want to quit, the loop ends. I then want to print each description, price, and quantity but this for loop will only print the last element over and over. Here is what I have:
ArrayList <ItemAttribute> list = new ArrayList<ItemAttribute>();
Scanner keyboard = new Scanner(System.in);
ItemAttribute product = new ItemAttribute();
public void findDescrPrice() {
/**
* Get the item name (description) for each list item
[code]...
View Replies
View Related
Mar 25, 2014
I am trying to retrieve jtext fields and combo box values from another frame and to put them in database but .getText() doesn't return anything ...
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
try{
String sql = "select * from login where uid = ? and pass = ?";
pst = con.prepareStatement(sql);
pst.setString(1, jTextField1.getText());
pst.setString(2, jTextField2.getText());
rs = pst.executeQuery();
if(rs.next()){
[Code] .....
View Replies
View Related
Jul 16, 2014
i want to store and retrieve thumb impression from a database using java.now i am learning java so i want to do the coding using java.i want to know which database is used to store thumb impressions ?
View Replies
View Related
Dec 23, 2014
I am trying to retrieve data from my database by joining my tables. So far i have managed to join my four tables in my database and retrieve all the information in that table. Now what i want to do is create a prepared statement in java that allows me to retreive certain data. Here is my joining query.
SELECT student.idNumber,student.names, student.surname,
course.description,
coursemarks.mark,
class.form,class.id
FROM `student`
LEFT JOIN `coursemarks` on student.idNumber = coursemarks.studentid
LEFT JOIN `course` on course.courseid = coursemarks.courseid
LEFT JOIN `class`on student.idNumber = class.studentID;
What I want is to select all the data depending on the class passed and the form passed, e.g a person might decide to select a certain form only or a certain form and class
View Replies
View Related
May 4, 2015
I am creating a read/write, RandomAccessFile that I will use to store several student ID and gpa score. What I don't understand is how I should go about retrieving a particular set of data.
public class ReadWrite {
static Scanner keyboard = new Scanner(System.in);
static String fileName = "Stu.dat";
static RandomAccessFile raf;
public static void main(String [] args) throws FileNotFoundException, IOException {
[Code] .....
View Replies
View Related
Apr 25, 2014
Ok I am trying to auto populate a bean and retrieve the values from it using the jsp:useBean tags ect..
My code looks like this..
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
String redirect = request.getParameter("page").trim();
if(redirect.equals("create_account"))
response.sendRedirect("/WebProgrammers/sign_on_server_pages/"+redirect+".jsp");
if(redirect.equals("confirm_info"))
[Code] ....
The error my Apache Tomcat is throwing
org.apache.jasper.JasperException: An exception occurred processing JSP page /sign_on_server_pages/confirm_info.jsp at line 91
88:
89:
90: %>
91: <jsp:useBean id="acct" type="beans.Creating_Account" scope="application"></jsp:useBean>
[Code] ....
I have tried sever different values for the scope attribute and all of them say the same thing about 'not found in scope'.
View Replies
View Related
May 21, 2015
I am working on a Java program that calls a stored procedure in an Oracle 11.2g database and retrieves a set of records via a ref cursor. The program follows the standard Connection/CallableStatement/ResultSet pattern. A ResultSet object is used to access and iterate through the returned cursor, processing each record in turn.
One of the database fields returned in the cursor is a CLOB, which I'm retrieving using the NClob class's getNClob() method. Two other methods - length() and getSubString() are then used to get the length of the CLOB and copy of it off to a String object respectively.
The problem is that these latter two method calls are relatively slow, taking around 80ms to complete for modestly sized CLOBs of, say, around 10KB in size.
Is this the most efficient way to access a CLOB and retrieve its contents? If so, is there anything I can do, to make it run faster?
View Replies
View Related
Mar 5, 2015
I am having an issue with retrieving "grouped" data from HTML form to servlet. I will describe the scenario below.
In companies, they record the salary of the employees once a month.When they record it, they do not do it by visiting each an every employees personal "profile" (or whatever according to the system). Instead what they do is apply the salaries of all of them in one page.
To do the above thing they prefer excel like tabular sheets. Now, I have a html form, where the form content is a table. One row is dedicated to a one employee.
Below is my form.
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
[Code] .....
As you can see, I have wrapped every row with a `<tbody>`. The `value` attribute of the `<tbody>` will contain the employee id. Once the form is submitted, the below servlet will capture it.
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
[Code] .....
What I was trying is get the `value` attribute of `<tbody>` (so I can identify the id of the employee) and get the data inside that `<tbody>`. However this didn't work, because I ended up with `NullpointerException` because it failed to read the `<tbody>` value.
So, how can I pass the data from table to servlet where it can clearly understand that one row is representing data belong to a one employee? If this is not the way to do it, I am also open for other methods.
View Replies
View Related
Aug 31, 2014
I am creating a small application.I have a jsp font page.i have a jdbc connection code.I have a sample table in my database.i want to retrieve datas from the database and display them in the view page.
My questions are:
-Where do i have to write jdbc code?
-How can i display the retrieved data in the display page?
View Replies
View Related
Jan 22, 2014
We created one web application which runs on tomcat 7.0.35 using spring mvc 3.0 . Its working perfectly on 32-bit windows machine in IE 8 on Windows 7 OS, when we tried to run this on 64-bit windows 2008 Server, jquery is not working. Also I populate data from Pop-up JSP to parent JSP, and it works 3/10 times only and does not work always.
We used the following jquery plugins in our project
jquery 1.8.3
jquery.ui.custom.1.9.2
jquery.ui.custom.min-1.9.
View Replies
View Related
Sep 5, 2014
Having trouble figuring out the code in order to find the price column for all items in a ArrayList. So far i have:
private double calculateSubtotal() {
try {
myConnection = DriverManager.getConnection(DATABASE_URL);
myStatement = myConnection.createStatement();
myResultSet = myStatement.executeQuery("SELECT price FROM menu");
[Code] ....
I am not sure if i am going about this the right way or not?
View Replies
View Related
Apr 30, 2015
I am unable to find a way to retrieve all the comments, likes and shares from a facebook page post using restfb. I know about the concept of paging but I am unable to do so. I get only first 25 comments and like.i get blank output as Comment: [] wen i try to get the comments on other pages. my code so far is:
public class FacebookAPI {
String pageAccessToken;
String pageID;
FacebookClient fbClient;
static User myuser = null; //Store references to myr user and page
[Code] .....
View Replies
View Related
Apr 1, 2015
I want to retrieve the data from this table given below and insert that data in the database in the next servlet
package com.sk;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
[Code] .....
View Replies
View Related