Hvorfor virker dette IKKE ????
JPS-siden henter fint alle data op fra databasen, MEN ved at klikke på
submit knappen, OG lade JSP-siden kalde sig selv, for at hælde værdier i
Bean'en set'er-metoder, giver næste side kun tomme felter i browseren.
Hvad er fejlen !!! ???
<html>
<head>
<%@ page language="java" import="webconfig.UserBean" %>
<jsp:useBean id="UserBeanID" scope="page" class="webconfig.UserBean" />
<jsp:setProperty name="UserBeanID" property="*" />
<% String reqUserName = request.getParameter("QUserName"); %>
<% if (request.getParameter("JspCommand") != null)
{
if (request.getParameter("JspCommand").equals("show"))
{
UserBeanID.findUser(reqUserName);
}
else if (request.getParameter("JspCommand").equals("save"))
{
UserBeanID.updateUser(reqUserName);
}
} // end if .... JspCommand !=null ..
%>
<%! String convertTrueToSelected (String inStr)
{
// Java-metode - Konverterer TRUE -> ON og FALSE -> OFF
String outStr = "";
// Lav kun ændring, hvis input ikke er NULL
if (inStr != null)
{
if (inStr.equals("TRUE") )
{
outStr = "checked";
}
else if (inStr.equals("FALSE") )
{
outStr = "";
}
else
outStr = ""; //
}
}
return outStr;
} %>
<meta http-equiv="Content-Language" content="da">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<link REL="STYLESHEET" HREF="css/style01.css" TYPE="text/css">
<title>User - Config</title>
<base target="_self">
</head>
<body topmargin="5" leftmargin="10">
<table border="0" cellpadding="2" cellspacing="1" width="600" height="241">
<tr>
<td width="602" height="26" align="center">
</td>
</tr>
<tr>
<td width="586" height="26" align="center" bgcolor="#008080">
<p align="center"><b><u><font face="Verdana" color="#FFFFFF"
size="4">Bruger - (Vis / Rediger)</font></u></b>
</p>
</td>
</tr>
<tr>
<td width="602" height="1" align="center">
</td>
</tr>
<tr>
<td width="559" height="116" align="center"><form method="POST"
onSubmit="" action="User_ShowEdit?QUserName="+reqUserName>
<table border="0" width="112%" cellpadding="2" height="357">
<tr>
<td width="33%" height="25" bgcolor="#CCCCCC">
<p align="left"><b><font face="Verdana" color="#000000"
size="2">Bruger navn:</font></b></p>
</td>
<td width="75%" height="25"><font face="Verdana" size="1"><b><input
readonly type="text" name="UserName" size="50" value="<%=
UserBeanID.getuserName() %>" valuetabindex="1" style="font-family: Verdana;
font-size: 8pt"></b></font></td>
</tr>
<tr>
<td width="100%" colspan="2" height="21">
<hr>
</td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="25" align="right">
<p align="left"><b><font face="Verdana" size="2">Altid
øverst:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="25"><font size="1"><input
type="checkbox" name="AlwaysOnTop" value="<%= UserBeanID.getAlwaysOnTop()
%>" <%= convertTrueToSelected( UserBeanID.getAlwaysOnTop() ) %>></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="25" align="right">
<p align="left"><b><font face="Verdana" size="2">Start
minimeret:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="25"><font size="1"><input
type="checkbox" name="StartMinimized" value="<%=
UserBeanID.getStartMinimized() %>" <%=
onvertTrueToSelected( UserBeanID.getStartMinimized() ) %>></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="26" align="right">
<p align="left"><b><font face="Verdana" size="2">Blink ved indkommende
opkald:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="26"><font size="1"><input
type="checkbox" name="FlashWhenArrivingCall" value="<%=
UserBeanID.getFlashWhenArrivingCall() %>" <%=
onvertTrueToSelected( UserBeanID.getFlashWhenArrivingCall() )
%>></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font face="Verdana" size="2">Vis
Quit-Dialog:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><font size="1"><input
type="checkbox" name="ShowQuitDialog" value="<%=
UserBeanID.getShowQuitDialog() %>" <%=
onvertTrueToSelected( UserBeanID.getShowQuitDialog() ) %>></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font size="2" face="Verdana">Agent
Login-ID:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><font size="1"><input
type="text" name="AgentLoginId" size="50" value="<%=
UserBeanID.getAgentLoginId() %>" style="font-family: Verdana; font-size:
8pt"></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font size="2" face="Verdana">Udskyd call-back i
antal minutter:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><font size="1"><input
type="text" name="RejectCallBackTime" size="50" value="<%=
UserBeanID.getRejectCallBackTime() %>" style="font-family: Verdana;
font-size: 8pt"></font></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font size="2" face="Verdana">Automatisk <br>
besvar kald:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><input type="checkbox"
name="AutomaticAnswer" value="<%= UserBeanID.getAutomaticAnswer() %>" <%=
convertTrueToSelected( UserBeanID.getAutomaticAnswer() )%>></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font size="2" face="Verdana">Automatisk <br>
klar ved indmeld:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><input type="checkbox"
name="AutomaticReady" value="<%=UserBeanID.getAutomaticReady() %>" <%=
convertTrueToSelected( UserBeanID.getAutomaticReady() )%>></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font size="2" face="Verdana">ACD-Script udføres
som default ved kald:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><input type="checkbox"
name="ACDScriptDefault" value="<%= UserBeanID.getACDScriptDefault() %>" <%=
convertTrueToSelected( UserBeanID.getACDScriptDefault() )%>></td>
</tr>
<tr>
<td width="33%" bgcolor="#CCCCCC" height="1" align="right">
<p align="left"><b><font face="Verdana"
size="2">Bemærkninger:</font></b></p>
</td>
<td width="75%" bgcolor="#CCCCCC" height="1"><textarea rows="2"
name="remark" cols="48"><%= UserBeanID.getremark() %></textarea></td>
</tr>
<tr>
<td width="100%" colspan="2" height="21">
<hr>
</td>
</tr>
<tr>
<td width="102%" colspan="2" align="center" height="27"><font
face="Verdana" size="2"><input type="submit" value="GEM ændringer"
name="B1">
<input type="reset" value="Nulstil" name="B2"></font></td>
</tr>
<tr>
<td width="102%" colspan="2" align="center" height="21"> </td>
</tr>
</table>
</form>
</td>
</tr>
<tr>
<td width="602" height="26"><hr width="530">
</td>
</tr>
<tr>
<td width="456" height="22" align="center">
<p align="center">
</td>
</tr>
<tr>
<td width="568" valign="middle" align="center" height="53">
<font size="1" face="Verdana"><i>
© Copyright 2001 by TDC - Tele Danmark - All
rights reserved.</i></font></td>
</tr>
</table>
</body>
</html>
//////////////////////////////////////////////////////
package webconfig;
/**
* Title: webconfig
* Description:
* Copyright: Copyright (c) 2001
* Company:
* @author ABP
* @version 1.0
*/
import java.sql.*;
import java.util.*;
import java.util.Arrays;
public class UserBean extends SQLResult {
// public static webconfig.User user = new webconfig.User();
// Instans variabler
private static String ID = "0"; // Nøgle genereres udfra databaseopkald
til tabel ???? samt en beregn af næste nr.
private static String User = "";
private static String userName = "";
private static String Password = "";
private static String RegistryPath;
private static String AlwaysOnTop;
private static String StartMinimized;
private static String FlashWhenArrivingCall;
private static String OkColor;
private static String InfoColor;
private static String ErrorColor;
private static String ShowQuitDialog;
private static String QuitColor;
private static String ButtonUpColor;
private static String ButtonInterColor;
private static String ButtonDownColor;
private static String INFOWINBKCOLOR;
private static String INFOWINFONTCOLOR;
private static String AgentLoginId;
private static String RejectCallBackTime;
private static String AutomaticAnswer;
private static String AutomaticReady;
private static String ACDScriptDefault;
private static String Pos_MSPDNForm_TopLeft;
private static String Pos_MSPDNForm_BottomRight;
private static String Pos_GUIForm_TopLeft;
private static String Pos_GUIForm_BottomRight;
private static String Pos_InfoDialog_TopLeft;
private static String Pos_InfoDialog_BottomRight;
private static String Pos_LogForm_TopLeft;
private static String Pos_LogForm_BottomRight;
private static String Pos_MSPForm_TopLeft;
private static String Pos_MSPForm_BottomRight;
private static String Pos_MSPACDForm_TopLeft;
private static String Pos_MSPACDForm_BottomRight;
private static String Pos_ScripterForm_TopLeft;
private static String Pos_ScripterForm_BottomRight;
private static String Pos_ScriptInfo_TopLeft;
private static String Pos_ScriptInfo_BottomRight;
private static String DisplayColor;
private static String DnisDisplayColor;
private static String CallbackDisplayColor;
private static String Pos_CRCallbackDlg_TopLeft;
private static String Pos_CRCallbackDlg_BottomRight;
private static String INFOWINSTYLE;
private static String Pos_Callback_TopLeft;
private static String Pos_Callback_BottomRight;
private static String Pos_WEB_TopLeft;
private static String Pos_WEB_BottomRight;
private static String remark = "";
//**************************************************************************
***********
// Constructors
public UserBean() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}
//UserBean userBean = new UserBean();
//--END
CONSTRUCTORS----------------------------------------------------------------
---------//
// Set metoder
public void setID(String ID){
this.ID = ID;
}
public void setUser(String User){
this.User = User;
}
public void setuserName(String userName){
this.userName = userName;
}
public void setPassword(String Password){
this.Password = Password;
}
public void setRegistryPath(String RegistryPath){
this.RegistryPath = RegistryPath;
}
// --- ... tilføj alle de andre, .. engang ....->>>
public void setAlwaysOnTop(String AlwaysOnTop) {
this.AlwaysOnTop = AlwaysOnTop;
}
public void setStartMinimized(String StartMinimized) {
this.StartMinimized = StartMinimized;
}
public void setFlashWhenArrivingCall(String FlashWhenArrivingCall) {
this.FlashWhenArrivingCall = FlashWhenArrivingCall;
}
public void setShowQuitDialog(String ShowQuitDialog) {
this.ShowQuitDialog = ShowQuitDialog;
}
public void setAgentLoginId(String AgentLoginId)
this.AgentLoginId = AgentLoginId;
}
public void setRejectCallBackTime(String RejectCallBackTime)
this.RejectCallBackTime = RejectCallBackTime;
}
public void setAutomaticAnswer(String AutomaticAnswer)
this.AutomaticAnswer = AutomaticAnswer;
}
public void setAutomaticReady(String AutomaticReady)
this.AutomaticReady = AutomaticReady;
}
public void setACDScriptDefault(String ACDScriptDefault)
this.ACDScriptDefault = ACDScriptDefault;
}
// --- ... tilføj alle de andre, .. engang ....->>>
public void setremark(String remark){
this.remark = remark;
}
// end set metoder
//--------------------------------------------------------------------------
------------//
//Get metoder
public String getID(){
return ID;
}
public String getUser(){
return User;
}
public String getuserName(){
return userName;
}
public String getPassword(){
return Password;
}
public String getRegistryPath(){
return RegistryPath;
}
// --- ... tilføj alle de andre, .. engang ....->>>
public String getAlwaysOnTop(){
return AlwaysOnTop;
}
public String getStartMinimized(){
return StartMinimized;
}
public String getFlashWhenArrivingCall(){
return FlashWhenArrivingCall;
}
public String getShowQuitDialog(){
return ShowQuitDialog;
}
public String getAgentLoginId(){
return AgentLoginId;
}
public String getRejectCallBackTime(){
return RejectCallBackTime;
}
public String getAutomaticAnswer(){
return AutomaticAnswer;
}
public String getAutomaticReady(){
return AutomaticReady;
}
public String getACDScriptDefault(){
return ACDScriptDefault;
}
public String getremark(){
return remark;
}
//--------------------------------------------------------------------------
-<
public ResultSet getRsAllUsers() {
ResultSet allUsersRs = null;
//SQLResult sqlrs = new SQLResult();
rs = queryDB("Select * From User");
allUsersRs = rs;
return allUsersRs;
}
public ResultSet getRsUsers(String QueryUserName) {
ResultSet userNames = null;
rs = queryDB("Select * From User Where UserName = '" + QueryUserName +
"'");
userNames = rs;
return userNames;
}
public void findUser(String QueryUserName) {
//ResultSet userRs = null;
ResultSet userRs;
// userRs = queryDB("Select
UserName,Password,AlwaysOnTop,StartMinimized,ShowQuitDialog,AgentLoginId,Rej
ectCallBackTime,AutomaticAnswer,AutomaticReady,ACDScriptDefault,Remark " +
// "From User Where UserName = '" + QueryUserName +
"'");
userRs = queryDB("Select
User,UserName,Password,AlwaysOnTop,StartMinimized,FlashWhenArrivingCall,Show
QuitDialog,AgentLoginId,RejectCallBackTime,AutomaticAnswer,AutomaticReady,AC
DScriptDefault,Remark From User Where UserName = '" + QueryUserName + "'");
// userRs = queryDB("SELECT * FROM User");
clearUserContent(); // Rens object for tidligere data FØR næste
SQL-query
try {
while (userRs.next()) {
//user.setID(( userRs.getInt("ID") );
setUser(userRs.getString("User") );
//System.out.println("Hallo - nu r vi ved SetUserName");
setuserName(userRs.getString("UserName") );
setPassword(userRs.getString("Password") );
setAlwaysOnTop(userRs.getString("AlwaysOnTop") );
setStartMinimized(userRs.getString("StartMinimized") );
setFlashWhenArrivingCall(userRs.getString("FlashWhenArrivingCall") );
setShowQuitDialog( userRs.getString("ShowQuitDialog") );
setAgentLoginId(userRs.getString("AgentLoginId") );
setRejectCallBackTime(userRs.getString("RejectCallBackTime") );
setAutomaticAnswer( userRs.getString("AutomaticAnswer") );
setAutomaticReady( userRs.getString("AutomaticReady") );
setACDScriptDefault( userRs.getString("ACDScriptDefault") );
setremark(userRs.getString("Remark") );
} // while-løkke
// userRs.close(); // Lukker result-sæt
// SQLResult.con.close(); // Lukker database-forbindelse
System.out.println("Database kald ...");
}
catch (Exception e)
{
System.out.println("Exception catch ....");
System.out.println(e);
// return "Fejl";
}
} // end void findUser(String userName) {
public void updateUser(String QUserName)
{
System.out.println("updateUser metoden i JavaBean'en er her kaldt
"+QUserName);
}
public void clearUserContent() {
// user.setID(initValNr);
setID("0");
setUser("");
setuserName("");
setPassword("");
setRegistryPath("");
setAlwaysOnTop("");
setStartMinimized("");
setFlashWhenArrivingCall("");
setShowQuitDialog("");
setAgentLoginId("");
setRejectCallBackTime("");
setAutomaticAnswer("");
setAutomaticReady("");
setACDScriptDefault("");
setremark("");
} // end public void clearObjectContent() {
// -------------------------------------------------------------------------
-->
// Konverteringsmetoder -------------------------------->
public int StrToInt(String string) {
int tal = Integer.parseInt(string);
return tal;
}
public String IntToStr( int tal) {
String string = "";
string += tal;
return string;
}
// Konverteringsmetoder --------------------------------<
private void jbInit() throws Exception {
} // End
} // end public class UserBean extends SQLResult
Mvh
Alex B. P.
TDC A/S