In order to access a different computer and if it doesn't work from TotalCmd or Remote Desktop, you have to follow these steps:

A
1. Go into My Computer
2. In Tools - > click Map network drive
3. In the dialog box appeared insert:
path to computer: \\fileserver\kit2
4. Click Connect using different user name and enter user and pass

B
Next time you want to log on to the computer, if the connection cannot be establish
1. In My Computer - right click -> Disconnect
2. use the same steps (A 1-4)

My Wiki 1

Update DB

When I update project from CVS:
1. Check changelog.txt in order to see if DB schema has been updated.
2. If DB schema has been updated see which is the last update made.
3. In DbVis, go to the respective DB, into databasedescription table and see schemarevision field. Sort field descending.
4. In projects, search for the update doc and copy content of the doc
5. In DBvis, paste it into SQL Commander and click button Execute as SQL script.

Steps 4 and 5 repeat as long as necessary until the DB will be updated.

Stack Overflow

The first time I saw something about Stack Overflow was while I was investigating a way to find HTML elements in xpath, in order to use them with Selenium. Couple days ago I finally created my account there and started using it. So far my impression has been very positive.

Stack Overflow is basically just a question-answer site for software developers. But because of its active user mass good questions are replied rapidly and bad ones are moderated. Users receive more privileges the more they are writing good questions and answers.

What is a good question or answer then? That is up to other users who can vote, edit or close your entry.

JAVA - joc: ghiceste un numar !

Jocul Ghiceste numarul

Se genereaza un numar aleator intre 0 - 10 (inclusiv) care se posteaza intr-un cookie. Utilizatorul introduce numele sau si incepe jocul. Primeste raspunsuri in legatura cu raspunsul sau: numarul este mai mare sau mai mic decat cel introdus. La final se afiseaza numarul de incercari facute pentru a ghici numarul.

Codul primei pagini: startGuessGame.jsp

html


<%@page import="javax.servlet.http.Cookie" %>

Introduceti numele dumneavoastra:

html

Codul paginii a doua: guessGame.jsp

html


<%@page import="javax.servlet.http.Cookie" %>

Bine ai venit, <%if(request.getAttribute("playerName") != null){
out.print(request.getAttribute("playerName")); } %> !

Introduceti in textfield un numar intre 0 - 10!

<%
if(request.getAttribute("eroare") != null){
out.print(request.getAttribute("eroare"));
}
if(request.getAttribute("mesaj") != null){
out.print(request.getAttribute("mesaj"));
}
%>


html

Codul servletului GuessGame.java

package teste;

import java.io.IOException;
import javax.servlet.RequestDispatcher;
import javax.servlet.ServletException;
import javax.servlet.http.Cookie;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.util.Random;

/**
* Servlet implementation class GuessGame
*/
public class GuessGame extends HttpServlet {
private static final long serialVersionUID = 1L;

private static int searchCookie(HttpServletRequest request, String cookieName){
int value = 0;
Cookie[] cookieArray = request.getCookies();
if(cookieArray != null){
for(int i = 0; i < cookieArray.length; i++){
String name = cookieArray[i].getName();
if(name.equals(cookieName)){
//ia valoarea cookie-ului si o pune intr-un String, apoi o transf in int:
String valCookie = cookieArray[i].getValue();
value = Integer.parseInt(valCookie);
}
}
}
return value;
}

/**
* @see HttpServlet#HttpServlet()
*/
public GuessGame() {
super();
}

/**
* @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response)
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doRequest(request, response);
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doRequest(request, response);
}

protected void doRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
int guessingNumber = 0;
int number = 0;
int numarIncercari = 0;

String mesaj = "";
String eroare = "";
String aux = "";

String playerName = request.getParameter("playerName");
log("playerName: " + playerName);

Random randomNumber = new Random();
if(playerName != null){
guessingNumber = randomNumber.nextInt(11);
} else {
guessingNumber = searchCookie(request,"guessNumber");
}

Cookie trialNumber = new Cookie("trialNumber", "trialNumber");
Cookie guessNumber = new Cookie("guessNumber", "guessNumber");

String initGuessCookie = Integer.toString(numarIncercari);
trialNumber.setValue(initGuessCookie);

String initNumberCookie = Integer.toString(guessingNumber);
guessNumber.setValue(initNumberCookie);

try{
String nr = request.getParameter("number");
number = Integer.parseInt(nr);
if(number numarIncercari++;
log("< incercari: " + numarIncercari);
} else if(number>guessingNumber){
numarIncercari++;
log("> incercari: " + numarIncercari);
} else {
numarIncercari++;
log("= incercari: " + numarIncercari);
}
} catch (NumberFormatException nfe) {
eroare = "Eroare! Introduceti un numar valid!";
} finally {
int value = 0;
if(number value = searchCookie(request,"trialNumber");
value++;
aux = Integer.toString(value);
trialNumber.setValue(aux);
mesaj = "Numarul este mai mic! Mai incearca! Incercari: "+ trialNumber.getValue();
log("Numarul de incercari este: "+ trialNumber.getValue());

} else if (number>guessingNumber){
value = searchCookie(request,"trialNumber");
value++;
aux = Integer.toString(value);
trialNumber.setValue(aux);
mesaj = "Numarul este mai mare! Mai incearca! Incercari: "+ trialNumber.getValue();
log("Numarul de incercari este: "+ trialNumber.getValue());

} else if(number == guessingNumber){
value = searchCookie(request,"trialNumber");
value++;
aux = Integer.toString(value);
trialNumber.setValue(aux);
mesaj = "Ati ghicit numarul! Incercari: "+ trialNumber.getValue();
log("Numarul de incercari este: "+ trialNumber.getValue());
trialNumber.setValue("0");
}
request.setAttribute("mesaj", mesaj);
request.setAttribute("eroare", eroare);
request.setAttribute("playerName", playerName);
response.addCookie(trialNumber);
response.addCookie(guessNumber);

RequestDispatcher dispatcher=getServletContext().getRequestDispatcher( "/teste/guessGame.jsp" );
dispatcher.forward( request, response );
}
}
}

Dialogul de afisare a continutului bazei de date

import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.util.Iterator;
import java.util.List;
import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.GroupLayout.Alignment;
import problema080915.Produs;
import problema080922.DepozitApp;
import problema081017.ProdusDao;

public class FindEntryDlg extends JDialog implements ActionListener {

JLabel label;
ProdusDao produsDao;
JTable table;
List list;

public FindEntryDlg(JFrame owner){
super(owner, "Whatever", true);

label = new JLabel();
produsDao = ((DepozitApp)owner).getProdusDao();

JButton ok = new JButton("OK");
ok.setActionCommand("ok");
ok.addActionListener(this);

JButton cancel = new JButton("Cancel");
cancel.setActionCommand("cancel");
cancel.addActionListener(this);

Dimension size = ok.getPreferredSize();
ok.setBounds(25, 40, size.width, size.height);
size = cancel.getPreferredSize();
cancel.setBounds(25, 80, size.width, size.height);

JScrollPane scrollPane = null;

try{
list = produsDao.gasesteProduse();

// initializare tabel cu rezultate:
Object[][] data = new Object[list.size()][5];
String[] columnNames = {"Cod",
"Data",
"Denumire",
"Cantitate",
"Valoare unitara"};

int contor = 0;
for(Iterator it = list.iterator(); it.hasNext(); ){
Produs pr = (Produs)it.next();

data[contor][0] = pr.getCod();
data[contor][1] = pr.getData();
data[contor][2] = pr.getDenumire();
data[contor][3] = pr.getCantitatea();
data[contor][4] = pr.getValoarea_unitara();
contor++;
}

table = new JTable(data, columnNames);
table.setPreferredScrollableViewportSize(new Dimension(500, 70));
table.setFillsViewportHeight(true);

// Create the scroll pane and add the table to it.
scrollPane = new JScrollPane(table);
}catch (SQLException e){
System.out.println("Exceptie.");
e.printStackTrace();
}

GroupLayout layout = new GroupLayout(this.getContentPane());
this.getContentPane().setLayout(layout);
layout.setAutoCreateGaps(true);
layout.setAutoCreateContainerGaps(true);

GroupLayout.SequentialGroup hGroup = layout.createSequentialGroup();

hGroup.addGroup(layout.createParallelGroup().
addComponent(ok).addComponent(scrollPane));
hGroup.addGroup(layout.createParallelGroup().
addComponent(cancel));
layout.setHorizontalGroup(hGroup);

GroupLayout.SequentialGroup vGroup = layout.createSequentialGroup();

vGroup.addGroup(layout.createParallelGroup(Alignment.BASELINE).
addComponent(scrollPane));
vGroup.addGroup(layout.createParallelGroup(Alignment.BASELINE).
addComponent(ok).addComponent(cancel));
layout.setVerticalGroup(vGroup);

this.setSize(600, 300);
}

public void actionPerformed(ActionEvent event) {

String cmd = event.getActionCommand();

if("ok".equals(cmd)) {
label.setText("Butonul ok a fost apasat");

try{
list = produsDao.gasesteProduse();

MetodeUtilitare.afiseazaRezultateInterogare(list);

}catch (SQLException e){
System.out.println("Exceptie.");
e.printStackTrace();
}
} else if ("cancel".equals(cmd)) {
label.setText("Butonul cancel a fost apasat");
}
this.setVisible(false);
}
}

Dialog Cautare Produs dupa Cod

package dialogDemo;

import java.awt.Dimension;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.SQLException;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Iterator;
import java.util.List;

import javax.swing.GroupLayout;
import javax.swing.JButton;
import javax.swing.JDialog;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.JTextField;
import javax.swing.GroupLayout.Alignment;
import javax.swing.table.DefaultTableModel;

import problema080915.Produs;
import problema080922.DepozitApp;
import problema081017.ProdusDao;

public class SearchByCodDlg extends JDialog implements ActionListener {

JLabel label;
JLabel label1 ;
JTextField tf1;
JTable table;
Produs produs;
JButton ok;
JButton cancel;

ProdusDao produsDao;
DefaultTableModel model;

String[] columnNames = {"Cod",
"Data",
"Denumire",
"Cantitate",
"Valoare unitara"};

public SearchByCodDlg(JFrame owner){
super(owner, "Whatever", true);

label = new JLabel();
label1 = new JLabel("Denumirea");
Dimension size = label1.getPreferredSize();
label1.setBounds(25, 40, size.width, size.height);
tf1 = new JTextField();
size = tf1.getPreferredSize();
//tf1.setBounds(25, 40, size.width, size.height);
//tf1.setColumns(20);
//tf1.setSize(20, 30);

produsDao = ((DepozitApp)owner).getProdusDao();

JScrollPane scrollPane = null;

try {
produs = produsDao.gasesteDupaCod(tf1.getText());

Object[][] data = initModelData(produs);

model = new DefaultTableModel(data, columnNames);

table = new JTable(model);
table.setPreferredScrollableViewportSize(new Dimension(500, 70));
table.setFillsViewportHeight(true);

// Create the scroll pane and add the table to it.
scrollPane = new JScrollPane(table);
} catch (SQLException e) {
e.printStackTrace();
}

ok = new JButton("OK");
ok.setActionCommand("ok");
ok.addActionListener(this);

cancel = new JButton("Cancel");
cancel.setActionCommand("cancel");
cancel.addActionListener(this);

size = ok.getPreferredSize();
ok.setBounds(25, 40, size.width, size.height);
size = cancel.getPreferredSize();
cancel.setBounds(25, 80, size.width, size.height);

GroupLayout layout = new GroupLayout(this.getContentPane());
this.getContentPane().setLayout(layout);

layout.setAutoCreateGaps(true);
layout.setAutoCreateContainerGaps(true);

GroupLayout.ParallelGroup hGroup = layout.createParallelGroup(Alignment.LEADING);
hGroup.addGroup(layout.createSequentialGroup().
addComponent(label1).
addComponent(tf1))
.addGroup(layout.createSequentialGroup().
addComponent(scrollPane))
.addGroup(layout.createSequentialGroup().
addComponent(ok).
addComponent(cancel));
layout.setHorizontalGroup(hGroup);

GroupLayout.SequentialGroup vGroup = layout.createSequentialGroup();
vGroup.addGroup(layout.createParallelGroup(Alignment.LEADING).
addComponent(label1).
addComponent(tf1));
vGroup.addGroup(layout.createParallelGroup(Alignment.LEADING).
addComponent(scrollPane));
vGroup.addGroup(layout.createParallelGroup(Alignment.LEADING).
addComponent(ok).
addComponent(cancel));
layout.setVerticalGroup(vGroup);

this.setSize(500, 300);
}

private Object[][] initModelData(Produs pr) {
// initializare tabel cu rezultate:
Object[][] data = new Object[1][5];

data[0][0] = pr.getCod();
data[0][1] = pr.getData();
data[0][2] = pr.getDenumire();
data[0][3] = pr.getCantitatea();
data[0][4] = pr.getValoarea_unitara();

return data;
}

public void actionPerformed(ActionEvent event) {

String cmd = event.getActionCommand();

if("ok".equals(cmd)) {
label.setText("Butonul ok a fost apasat");

try{
Produs produs = produsDao.gasesteDupaCod(tf1.getText());
Object[][] data = initModelData(produs);

//MetodeUtilitare.afiseazaRezultateInterogare(list);

//se schimba datele din modelul tabelului:
model.setDataVector(data, columnNames);

}catch (SQLException e){
System.out.println("Exceptie.");
e.printStackTrace();
}
} else if ("cancel".equals(cmd)) {
label.setText("Butonul cancel a fost apasat");
this.setVisible(false);
}
}
}

Aplicatie pentru lucru cu intrari din Depozit

Clasa Produs:

import java.util.Date;

public class Produs implements Comparable{

private String cod;
private String denumire;
private Date data;
private Integer valoarea_unitara;
private Integer cantitatea;

public String getCod() {
return cod;
}
public void setCod(String cod) {
this.cod = cod;
}
public String getDenumire() {
return denumire;
}
public void setDenumire(String denumire) {
this.denumire = denumire;
}
public Integer getCantitatea() {
return cantitatea;
}
public void setCantitatea(Integer cantitatea) {
this.cantitatea = cantitatea;
}
public Date getData() {
return data;
}
public void setData(Date data) {
this.data = data;
}
public Integer getValoarea_unitara() {
return valoarea_unitara;
}
public void setValoarea_unitara(Integer valoarea_unitara) {
this.valoarea_unitara = valoarea_unitara;
}
public int compareTo(Object arg0) {

if(arg0 instanceof Produs){
Produs produs = (Produs)arg0;

return -produs.getDenumire().compareTo(denumire);//produs.getDenumire().compareTo(this.getDenumire())

}
return 1;
}
}