nasha shaharan

Greenhorn

+ Follow

news 24 Posts 4 Threads

since Jun 01, 2011

Merit badge: grant badges

For More

Cows and Likes

Cows

Total received

In last 30 days

Forums and Threads

Recent posts by nasha shaharan

hyperlink the data from database

bad gateway.

anybody else? please help, thanks.

13 years ago

JSP

hyperlink the data from database

thank for the pointer.
but that seems to be hard-coded. i need to know how to display all the names from the database and make them clickable like a hyperlink. how can i do that?

13 years ago

JSP

hyperlink the data from database

hi all!

i have a problem. i'm making a dynamic web project where we can key in info about employees and displaying info about the employee. I'm using jsp and servlets and the database using postgresql.

now i'm stuck at the part where i need to retrieve the names of the employees and set it as a clickable hyperlink. when we click on the names (retrieved from database)...will lead to a page about his/her profile - info about name, department, position..etc

can anybody tell me how to go about that? i'll give my code if you'd like, but i had just done the retrieving info and put it in a table. which is not practical if theres a lot of data.

thanks in advance and i hope i made it clear

13 years ago

JSP

linking between applet pages

okay thanks! i'll go and learn more about cardlayout.

14 years ago

Applets

linking between applet pages

thanks for explaining..so, the panels will be in the same size of the applet? the panels will be on top of each other then?

14 years ago

Applets

linking between applet pages

oh CardLayout..can cardlayout contain applets in various sizes?

14 years ago

Applets

linking between applet pages

It's like a website with a login page. after login, press the enter button and the applet called ButtonView takes the place of the login applet.
then in the ButtonView applet will have 3 buttons which do different things and they will open other applets as well.

the login to buttonView successfully linked, but the buttons in buttonView cannot open their respective applets.

just take a look at my code...

i don't want to use showDocuments because it will use different web pages. i only want one webpage, but the applets in one place, responding to whatever button being pressed.
or is this not possible? an applet contents cannot be changed? but in login page it was successful...maybe the panel from buttonView that was called?

sorry because i don't know a lot about applets..thanks for your help

14 years ago

Applets

linking between applet pages

thanks for the example, Andrew! i will look into it and study more about cardlayout.
i'm wondering why i can't link to other applet in the same page, when my login page can do that whenever i hit the login button. when i log in successfully, the page changes to the content page.

this is my login page code:

//username : nasya , password : nasya
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
public class Login extends JApplet {
public static final String text = "<html><center>Central Manager</center> </html>";
JPanel jPanel1 = new JPanel();
BorderLayout borderLayout1 = new BorderLayout();
JLabel jLabel1 = new JLabel();
JPanel jPanel2 = new JPanel();
GridBagLayout gridBagLayout1 = new GridBagLayout();
JLabel jLabel2 = new JLabel();
JLabel jLabel3 = new JLabel();
JTextField loginTextField = new JTextField(20);
JPasswordField passwordTextField = new JPasswordField(20);
JPanel jPanel3 = new JPanel();
JButton exitButton = new JButton();
JButton enterButton = new JButton();
FlowLayout flowLayout1 = new FlowLayout();
private static String tableName = "users";
private static Connection conn = null;
private static Statement stmt = null;
/*public Login() {
try {
jbInit();
}
catch(Exception e) {
e.printStackTrace();
}
}*/
private void login(ActionEvent e) {
try
{
Class.forName("org.postgresql.Driver");
//gets a connection
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/test","postgres","870127");
stmt = conn.createStatement();
String login = loginTextField.getText();
String pass = new String(passwordTextField.getPassword());
ResultSet results = stmt.executeQuery("select username, password from " + tableName +" where username ='"+login+"'");
String username = "";
String password = "";
while(results.next())
{
username = results.getString("username");
password = results.getString("password");
}
//validate login and password here. validity will be done by sending login/password to the server
if (login.equals(username) && pass.equals(password)) {
System.out.println("login successful");
showButtonsView();
}
else {
JOptionPane.showMessageDialog(this,"Incorrect login or password","Error",JOptionPane.ERROR_MESSAGE);
loginTextField.setText("");
passwordTextField.setText("");
loginTextField.requestFocusInWindow();
}
results.close();
stmt.close();
}
catch (Exception ex)
{
ex.printStackTrace();
}
}
private void showButtonsView() {
getContentPane().removeAll();
ButtonView button = new ButtonView();
button.init();
getContentPane().add(button);
getContentPane().validate();
}
private void exit(ActionEvent e) {
setVisible(false);
}
/*public static void main(String[] args) {
Login f = new Login();
f.setLocation(200,200);
f.pack();
f.show();
}*/
public void init()
{
resize(500,200);
//getContentPane().setLocation(400,400);
//getContentPane().setSize(500, 500);
jPanel1.setLayout(borderLayout1);
jLabel1.setHorizontalAlignment(SwingConstants.CENTER);
jLabel1.setText(text);
jPanel2.setLayout(gridBagLayout1);
jLabel2.setText("Password:");
jLabel3.setText("Login:");
exitButton.setText("Exit");
exitButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
exit(e);
}
});
enterButton.setText("Enter");
enterButton.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
login(e);
}
});
jPanel3.setLayout(flowLayout1);
flowLayout1.setAlignment(FlowLayout.RIGHT);
this.getContentPane().add(jPanel1, BorderLayout.CENTER);
jPanel1.add(jLabel1, BorderLayout.NORTH);
jPanel1.add(jPanel2, BorderLayout.CENTER);
jPanel2.add(loginTextField, new GridBagConstraints(2, 1, 1, 1, 0.0, 0.0
,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(0, 11, 0, 0), 0, 0));
jPanel2.add(jLabel2, new GridBagConstraints(1, 2, 1, 1, 0.0, 0.0
,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(11, 0, 0, 0), 0, 0));
jPanel2.add(passwordTextField, new GridBagConstraints(2, 2, 1, 1, 0.0, 0.0
,GridBagConstraints.CENTER, GridBagConstraints.NONE, new Insets(11, 11, 0, 0), 0, 0));
jPanel2.add(jLabel3, new GridBagConstraints(1, 1, 1, 1, 0.0, 0.0
,GridBagConstraints.CENTER, GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0));
jPanel1.add(jPanel3, BorderLayout.SOUTH);
jPanel3.add(enterButton, null);
jPanel3.add(exitButton, null);
}
}

and this is the code for the other applet when 'enter' button is pressed:

import java.awt.*;
import java.awt.event.ActionEvent;
import javax.swing.BoxLayout;
import javax.swing.JApplet;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
public class ButtonView extends JApplet
{
//GridLayout gridLayout1 = new GridLayout(2,2);
BorderLayout borderLayout1 = new BorderLayout();
//JScrollPane jScrollPane1 = new JScrollPane();
JPanel jPanel1 = new JPanel();
JButton jButton1 = new JButton();
JButton jButton2 = new JButton();
JButton jButton3 = new JButton();
JButton jButton4 = new JButton();
/*public ButtonView() {
try {
jbInit();
}
catch(Exception ex) {
ex.printStackTrace();
}
}*/
public void init()
{
getContentPane().add(jPanel1);
this.setLayout(borderLayout1);
jButton1.setText("View FileSystem");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
new FileExplorer();
setVisible(true);
//showFile();
}
});
jButton2.setText("Employee Profile");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
employeeView();
setVisible(true);
}
});
jButton3.setText("Hello,Hi!");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(ActionEvent e) {
helloWorld();
setVisible(true);
}
});
jButton4.setText("Example");
this.add(jPanel1, BorderLayout.CENTER);
jPanel1.setLayout(new BoxLayout(jPanel1, BoxLayout.PAGE_AXIS));
jPanel1.add(jButton1, null);
jButton1.setAlignmentX(CENTER_ALIGNMENT);
jPanel1.add(jButton2, null);
jButton2.setAlignmentX(CENTER_ALIGNMENT);
jPanel1.add(jButton3, null);
jButton3.setAlignmentX(CENTER_ALIGNMENT);
jPanel1.add(jButton4, null);
jButton4.setAlignmentX(CENTER_ALIGNMENT);
}
private void showFile() {
getContentPane().removeAll();
FileExplorer file = new FileExplorer();
//getContentPane().add(file);
//getContentPane().validate();
}
private void employeeView()
{
getContentPane().removeAll();
Employee emp = new Employee();
emp.init();
//getContentPane().add(emp);
//getContentPane().validate();
}
private void helloWorld()
{
getContentPane().removeAll();
Hello h = new Hello();
h.init();
getContentPane().add(h);
getContentPane().validate();
}
}

please help because i'm confused...

14 years ago

Applets

linking between applet pages

same web page..how can it be visible? i need to click a button, say: View Profile. then it will take me to another applet called Profile.
just like a website. can you tell me more?

14 years ago

Applets

linking between applet pages

no..not a webpage. it's an applet also.

14 years ago

Applets

simple questions about applets

http://java.sun.com/applets/jdk/1.4/index.html

check it out :P

14 years ago

Applets

linking between applet pages

hi guys,
i have an applet with many buttons. i wanna be able to press a button and directs it to another page.
it is kinda like clicking a link in a webpage. i am not sure how to do this. can you please tell me how?

this is what i did in the button's actionPerformed:

thanks in advance!

14 years ago

Applets

Swastik Dey wrote:ResultSet results = stmt.executeQuery("select username, password from " + tableName +" where username ='"+login+"'");

The above code it self will satisfy your purpose, then what is the below code. Why are you checking once again?
if (login.equals(username) && pass.equals(password))

just by doing this your purpose should get solved, with an assumption that username and password forms a unique record
ResultSet results = stmt.executeQuery("select username, password from " + tableName +" where username ='"+login+"'"); if(results.next()){ //valid login } else{ //invalid login }

im doing that because i wanna compare if the user inputs the right set of username and password.
if i follow your suggestion, then how to compare the password part?

14 years ago

JDBC and Relational Databases

oh i solved it!
thanks andrew and venkat!

anyways this is my code now:

private void login(ActionEvent e) {
try
{
Class.forName("org.postgresql.Driver");
//gets a connection
conn = DriverManager.getConnection("jdbc:postgresql://localhost:5432/test","postgres","870127");
stmt = conn.createStatement();
String login = loginTextField.getText();
String pass = new String(passwordTextField.getPassword());
ResultSet results = stmt.executeQuery("select username, password from " + tableName +" where username ='"+login+"'");
String username = "";
String password = "";
while(results.next())
{
username = results.getString("username");
password = results.getString("password");
}
//validate login and password here. validity will be done by sending login/password to the server
if (login.equals(username) && pass.equals(password)) {
System.out.println("login successful");
showButtonsView();
}
else {
JOptionPane.showMessageDialog(this,"Incorrect login or password","Error",JOptionPane.ERROR_MESSAGE);
loginTextField.setText("");
passwordTextField.setText("");
loginTextField.requestFocusInWindow();
}
results.close();
stmt.close();
}
catch (Exception ex)
{
ex.printStackTrace();
}
}

14 years ago

JDBC and Relational Databases

i think i put the if else code in the wrong place..because it iterates my record (i think)..
this is because when i log in..the incorrect password warning flashes 2 times when i entered user-a/password-a

can you suggest where i was to put the if else code?

14 years ago

JDBC and Relational Databases