Steve Dyke

Ranch Hand

+ Follow

1,834 Posts 683 Threads 1 Cows

since Nov 16, 2004

Cows and Likes

Cows

Total received

1

In last 30 days

0

Total given

0

Likes

Total received

7

Received in last 30 days

0

Total given

11

Given in last 30 days

0

Forums and Threads

Scavenger Hunt

Ranch Hand Scavenger Hunt

Greenhorn Scavenger Hunt

Recent posts by Steve Dyke

Applying a Set Interface on an Existing List

Dave Tolls wrote:Along with Piet's suggestion, since you are (it looks like) getting a single field from the database (pathdef), I would recommend also using the DISTINCT keyword in you query.
That way you only bring back what you need, and won't have any duplicates.

I thought about that but since I am pulling potentially three different record set that will not work for an overall distinct list.

I wondered if I get all the potential values that need to match part number then run one sql but can you use a list clause in a prepared statement?

17 hours ago

Java in General

Applying a Set Interface on an Existing List

Piet Souris wrote:Then why not make a Set in the first place, instead of a list? If order is important, it could be a LinkedHashSet, or use Stream.distinct.toList on the lis with duplicates.

This is my new code but when I iterate thru it I only get one value(See last output in my Console output).

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.HashSet;
import java.util.LinkedList;
import java.util.List;
import java.util.Set;
import java.util.TreeSet;
import com.FAIWebApp.AS400LibraryStringsV5;
import com.FAIWebApp.coV8.COSupportDrawing;
import com.FAIWebApp.coV8.COSupportDrawingList;
public class ATRHeaderDataPointList {
private Set<ATRHeaderDataPoint> atrHeaderDataPointlistv8 = null;
public ATRHeaderDataPointList(Connection dc, COSupportDrawingList coSupportDrawingList){
String sql = "";
Set temp = new TreeSet();
try{
boolean hasrecords = false;
for(COSupportDrawing cosd: coSupportDrawingList.getCosupportdrawingslistv8()){
if(cosd.getDwgtype() == 1 || cosd.getDwgtype() == 3 || cosd.getDwgtype() == 6){
String modifiedDrawingNumber = cosd.getDwgno().substring(0, Math.min(cosd.getDwgno().length(), 6));
sql = "Select Distinct pathdef From " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegh" +
" Left Join " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegp On " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegp.hindex = " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegh.recseq" +
" Where posstr(partno,?) > 0";
PreparedStatement stmt = dc.prepareStatement(sql);
stmt.setString(1, modifiedDrawingNumber);
ResultSet rs = stmt.executeQuery();
while(rs.next()){
hasrecords = true;
System.out.println("ATRHeaderDataPointList: pathdef: " + rs.getString("pathdef").trim());
temp.add(new ATRHeaderDataPoint(rs));
}
rs.close();
stmt.close();
}
}
if(hasrecords){
atrHeaderDataPointlistv8 = temp;
//Set<ATRHeaderDataPoint> atrHeaderDataPointlistv8 = new TreeSet<>(temp);
}
}
catch(Exception e){
System.out.println("ATRHeaderDataPointList: sql: " + sql);
System.out.println("ATRHeaderDataPointList: " + e);
e.printStackTrace();
}
}
public Set<ATRHeaderDataPoint> getAtrHeaderDataPointlistv8() {
return atrHeaderDataPointlistv8;
}
}

Console output

[6/23/18 18:11:18:380 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-B
[6/23/18 18:11:18:382 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-C
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-D
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-E
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-F
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-B
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-C
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-D
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-E
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: G-F
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:383 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef:
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:384 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-B
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-C
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-D
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O ATRHeaderDataPointList: pathdef: F-E
[6/23/18 18:11:18:385 CDT] 00000079 SystemOut     O COV8: ATR Path Def:G-B

17 hours ago

Java in General

Applying a Set Interface on an Existing List

I would like to apply the Set interface on the existing list to eliminate the duplicates.

package com.FAIWebApp.coV8.atr;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.HashSet;
import java.util.LinkedList;
import java.util.List;
import java.util.Set;
import java.util.TreeSet;
import com.FAIWebApp.AS400LibraryStringsV5;
import com.FAIWebApp.coV8.COSupportDrawing;
import com.FAIWebApp.coV8.COSupportDrawingList;
public class ATRHeaderDataPointList {
private List<ATRHeaderDataPoint> atrHeaderDataPointlistv8 = null;
public ATRHeaderDataPointList(Connection dc, COSupportDrawingList coSupportDrawingList){
String sql = "";
List temp = new LinkedList();
try{
boolean hasrecords = false;
for(COSupportDrawing cosd: coSupportDrawingList.getCosupportdrawingslistv8()){
if(cosd.getDwgtype() == 1 || cosd.getDwgtype() == 3 || cosd.getDwgtype() == 6){
String modifiedDrawingNumber = cosd.getDwgno().substring(0, Math.min(cosd.getDwgno().length(), 6));
sql = "Select pathdef From " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegh" +
" Left Join " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegp On " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegp.hindex = " + AS400LibraryStringsV5.PRODUCTION + ".wqmsifegh.recseq" +
" Where posstr(partno,?) > 0";
PreparedStatement stmt = dc.prepareStatement(sql);
stmt.setString(1, modifiedDrawingNumber);
ResultSet rs = stmt.executeQuery();
while(rs.next()){
hasrecords = true;
temp.add(new ATRHeaderDataPoint(rs));
}
rs.close();
stmt.close();
}
}
if(hasrecords){
atrHeaderDataPointlistv8 = temp;
//Set<ATRHeaderDataPoint> atrHeaderDataPointlistv8 = new TreeSet<>(temp);
}
}
catch(Exception e){
System.out.println("ATRHeaderDataPointList: sql: " + sql);
System.out.println("ATRHeaderDataPointList: " + e);
e.printStackTrace();
}
}
public List<ATRHeaderDataPoint> getAtrHeaderDataPointlistv8() {
return atrHeaderDataPointlistv8;
}
}

2 days ago

Java in General

Getting Radio Group Value Using Change Event

I have gotten it resolved by adding a class attribute to the radio button group:

<div class="miscdisplaysections yellowBG">
<div class="placeOnHoldOptions">
<input type="radio" class="placeOnHoldOption" name="nplaceOnHoldOption" value="0">This Serial# Only<br>
<input type="radio" class="placeOnHoldOption" name="nplaceOnHoldOption" value="1">All Serial#'s on this CO<br>
<c:choose>
<c:when test="${userDataObj.managerflag || userDataObj.clear_do_not_ship_flag}">
<input type="radio" class="placeOnHoldOption" name="nplaceOnHoldOption" value="2">Remove 'No Ship Flag' for this Serial#<br>
<input type="radio" class="placeOnHoldOption" name="nplaceOnHoldOption" value="3">Remove 'No Ship Flag' for this CO
</c:when>
</c:choose>
</div>
</div>
<div class="miscdisplaysections">
<div class="dNoShipCmt t-margin">
Reason for Holding<br>
<textarea class="cNoShipCmt" rows="2" cols="50" readonly>${saidetailsV8Obj.noshipcmt}</textarea>
<img title="Update" class="modified20 cNoShipCmt-update hide" src="/QMSWebApp/Images/submit[9].png">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
var vplaceOnHoldOption = 0;
$('.saiPlaceOnHoldV8Close').on("click", function(){
$('.saiV8-miscdisplay3').hide("slide", { direction: "right" }, 1000);
$('.saiV8-miscdisplay2').hide("slide", { direction: "right" }, 1000);
});
$('.placeOnHoldOption:radio').on("change", function(){
vplaceOnHoldOption = parseInt($(this).val());
switch(vplaceOnHoldOption){
case 0: case 1:
var answer = confirm("Are you sure you want to add a 'No Ship Flag' to selected Serial#'s? Process will complete when 'Reason' is uploaded.");
if(answer){
$('.dNoShipCmt').show();
$('.cNoShipCmt-update').show();
$('.cNoShipCmt').removeAttr("readonly");
}
break;
case 2: case 3:
$('.dNoShipCmt').hide();
var answer = confirm("Are you sure you want to remove the 'Do Not Ship Flag' from selected Serial#('s)?");
if(answer){
$.post("/QMSWebApp/SeatAssemblyInspectionV8ControllerServlet",
{lifecycle:"removeDoNotShipFlagV8",
placeonholdOption:vplaceOnHoldOption},
defaultDisplayResults, 'json');
}
break;
}
});

1 week ago

HTML Pages with CSS and JavaScript

Getting Radio Group Value Using Change Event

I know that this line will not work after looking at it. Because it is referencing a class and the radio buttons only has a name attribute.

2 weeks ago

HTML Pages with CSS and JavaScript

Getting Radio Group Value Using Change Event

Bear Bibeault wrote:And, clean code points:

Dont use the same name for different things. You use the same name for an element class and for control names.
Use one of camel case or train case for identifiers with multiple words. Just running all the words together in lowercase doesn't follow any accepted convention.

Thanks for your help tonight.

My modified code. But still not getting any response when I click on one of the radio buttons.

<div class="miscdisplaysections yellowBG">
<div class="placeOnHoldOptions">
<input type="radio" name="placeOnHoldOption" value="0">This Serial# Only<br>
<input type="radio" name="placeOnHoldOption" value="1">All Serial#'s on this CO<br>
<c:choose>
<c:when test="${userDataObj.managerflag || userDataObj.clear_do_not_ship_flag}">
<input type="radio" name="placeOnHoldOption" value="2">Remove 'No Ship Flag' for this Serial#<br>
<input type="radio" name="placeOnHoldOption" value="3">Remove 'No Ship Flag' for this CO
</c:when>
</c:choose>
</div>
</div>
<div class="miscdisplaysections">
<div class="dNoShipCmt t-margin">
Reason for Holding<br>
<textarea class="cNoShipCmt" rows="2" cols="50" readonly>${saidetailsV8Obj.noshipcmt}</textarea>
<img title="Update" class="modified20 cNoShipCmt-update hide" src="/QMSWebApp/Images/submit[9].png">
</div>
</div>
<script type="text/javascript">
$(document).ready(function(){
$('.saiPlaceOnHoldV8Close').on("click", function(){
$('.saiV8-miscdisplay3').hide("slide", { direction: "right" }, 1000);
$('.saiV8-miscdisplay2').hide("slide", { direction: "right" }, 1000);
});
$('.placeOnHoldOption').on("change", function(){
var vplaceOnHoldOption = parseInt($(this).val());
alert("placeOnHoldOption : changed: " + vplaceOnHoldOption);
switch(vplaceOnHoldOption){
case 0: case 1:
var answer = confirm("Are you sure you want to add a 'No Ship Flag' to selected Serial#'s? Process will complete when 'Reason' is uploaded.");
if(answer){
$('.cNoShipCmt-update').show();
$('.cNoShipCmt').removeAttr("readonly");
}
break;
case 2: case 3:
$('.dNoShipCmt').hide();
var answer = confirm("Are you sure you want to remove the 'Do Not Ship Flag' from selected Serial#'s?");
if(answer){
$.post("/QMSWebApp/SeatAssemblyInspectionV8ControllerServlet",
{lifecycle:"removeDoNotShipFlagV8",
placeonholdOption:vplaceOnHoldOption},
defaultDisplayResults, 'json');
}
break;
}
});

2 weeks ago

HTML Pages with CSS and JavaScript

Getting Radio Group Value Using Change Event

Bear Bibeault wrote:The code isn't very useful without the HTML structure that it is instrumenting.

Are you sure that your selector is selecting the elements you intend? That's about 75% of jQuery bugs.

Sorry, I realized after posting I forgot the HTML:

2 weeks ago

HTML Pages with CSS and JavaScript

Getting Radio Group Value Using Change Event

I have a div container that contains a group of radio buttons. I would like to check when a change event happens on the group and get the value.

My code that does not work as I expect:

2 weeks ago

HTML Pages with CSS and JavaScript

Correct Way to Check for Duplicates

I am building a list of Objects. I would like to check the list before the add method to make sure the element has not already been added.

Here is a piece of the code that builds to list:

3 weeks ago

Java in General

Use Java Object and Properties in my JSP

Bear Bibeault wrote: ncrlineitemparmsObj
Surely you can use a name that is more readable? (Hint: camel-case)

What is it supposed to contain? Did you look at the results of the JSP evaluation by doing a View Source in the browser?

let code

This is my servlet code:

my parms class:

public class NCRLineItemParmsV8 {
private int source = 0;
private String description = "";
private boolean edit = false;
private boolean add = false;
private boolean del = false;
private String colNames = "";
private boolean nroflag = false;
private boolean nhideflag = false;
private boolean inspector = false;
public NCRLineItemParmsV8(HttpServletRequest request, User user, NCR ncr){
//source 1 = NCR
//source 2 = MRR
//source 3 = FAI
try{source = Integer.parseInt(request.getParameter("source"));}catch(Exception e){}
switch(source){
case 1:
description = "NCR";
nroflag = true;
nhideflag = true;
if(user.isFaiinspectorflag()){
inspector = true;
}
//try{colNames = "Id,Row,Qty,imrr,Include on MRR,icert,Certs Rcvd,Defect,Hdefect,Description";}catch(Exception e){}
try{colNames = "Id,Row,Qty,imrr,Include on MRR,icert,Certs Rcvd,Defect,Hdefect,Description,ReworkInst,idc,DwgChange,DCRdesc,Assignment,Priority";}catch(Exception e){}
break;
case 2:
description = "MRR";
try{colNames = "Id,Row,Qty,Defect,Hdefect,Description,ReworkInst,idc,DwgChange,DCRdesc,Assignment,Priority";}catch(Exception e){}
break;
case 3:
description = "FAI";
break;
}
if(ncr.isNcrinitializeflag() || user.isManagerflag() || user.isQamanagerflag() || user.isRejectiontagqaadminflag() || user.isQaleadflag() || user.getMrbsignoffauthority() == 4){
try{edit = true;}catch(Exception e){}
try{add = true;}catch(Exception e){}
try{del = true;}catch(Exception e){}
}
else if(user.isRejectiontagmeadminflag() || user.isFaiinspectorflag()){
try{edit = true;}catch(Exception e){}
}
//try{colNames = "ID,Row,Qty,imrr,Include on MRR,Certs Rcvd,Certs Rcvd,Defect Codes,Defect Code Lit,Description,Instructions,Dwg Change,Dwg Change,Change Description,Change Assignment,Priority";}catch(Exception e){}
//try{colNames = "Id,Row,Qty,imrr,Include on MRR,Defect,Hdefect,Description";}catch(Exception e){}
  
}
public int getSource() {
return source;
}
public boolean isEdit() {
return edit;
}
public boolean isAdd() {
return add;
}
public boolean isDel() {
return del;
}
public String getColNames() {
return colNames;
}
public String getDescription() {
return description;
}
public boolean isNroflag() {
return nroflag;
}
public boolean isNhideflag() {
return nhideflag;
}
public boolean isInspector() {
return inspector;
}
}

This is the jsp code. Note that this works but I should be able to pass the object to the JSP and then in the js code get the class property values in lieu of each property individually.

<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/functions" prefix="fn"%>
<div class="hide">
<input type="hidden" class="ncrlineitemparmssource" size="5" value="${ncrlineitemparmsObj.source}">
<input type="hidden" class="ncrlineitemparmsdesc" size="5" value="${ncrlineitemparmsObj.description}">
<input type="hidden" class="ncrlineitemparmscolnames" size="5" value="${ncrlineitemparmsObj.colNames}">
<input type="hidden" class="ncrlineitemparmsinspector" size="5" value="${ncrlineitemparmsObj.inspector}">
<input type="text" class="ncrlineitemiconlist" size="5" value="${ncrlineitemdisplayObj.ncrlineitemiconlist}">
</div>
<div>
<div class="floatleft">
<table id="ncrlineitemlist"></table>
<div id="ncrlineitemlistpager"></div>
</div>
</div>
<div class="dclear"></div>
<script type="text/javascript">
$(document).ready(function(){
var ncrlineitemsource = $('.ncrlineitemparmssource').val();
var colnames = $('.ncrlineitemparmscolnames').val();
var inspector = $('.ncrlineitemparmsinspector').val();

1 month ago

HTML Pages with CSS and JavaScript

Use Java Object and Properties in my JSP

I posted a similar thread earlier but this is a little more info.

I want to use my java class property values in javascript. This code returns undefined:

1 month ago

HTML Pages with CSS and JavaScript

Use Java Object in my HTML Page

I use java objects in the HTML code using JSTL all the time to populate lists.

I would like to use a java class and its fields in my HTML without JSTL.

I have attempted to assign the class object to an input element but the properties are displayed as undefined.

1 month ago

HTML Pages with CSS and JavaScript

Convert Date to a String

I have a date(string) in the form of 4/6/2018 I need to change it to 040618.

this code does not do what I was hoping for:

Output is: Tue Jan 18 00:20:00 CST 5

2 months ago

Java in General

Using SMB to Copy Directories

I was able to make it work by placing an "/" at the end of the 'from' and 'to' paths.

2 months ago

Java in General

Using SMB to Copy Directories

The follow code only copies the directories but not the directory content.

Example of console output:

[4/3/18 7:09:47:548 CDT] 00000085 SystemOut O SupplierDrawingList: file://gvsvr03/Drawings/Release PDF/VendorPrintsSpecsTestReports/AMSAFE/HISTORY/1027
[4/3/18 7:09:47:548 CDT] 00000085 SystemOut O SupplierDrawingList: smb://corp.zodiac.lan;srv.drawchg6zsus:Webabc6!@sgai-fs02/qmsattachments$/SupplierDocuments/AM-SAFE INC/HISTORY/1027

2 months ago

Java in General