Jump to content

  • Log In with Google      Sign In   
  • Create Account


Darego

Member Since 02 Jan 2011
Offline Last Active May 06 2013 01:59 PM

Topics I've Started

need help with a software logo please :)

06 May 2013 - 01:57 AM

howdy, if anyone feels kind enough and has a few spare minutes; i'm having trouble creating a logo for my college project! as i am absolutely terrible at any kind of art! also i have no software that would help me do the logo

 

anyway, looking for a simple logo that would look in any way similar to this one at the top of the picture. anything simple will do! or if anyone has links to any videos that i could follow to do it in paint.. i would be grateful smile.png thanks!

 

387b569890acb39242371e2723584314.png

 

instead of MediTech, Patient Management mine will be "YomiTech" and in small under it "Help Desk System" it will be located at the top of my system in the empty space: 

 

fe29d2910ff622eaba03856f0c0c1013.png


validating JTextField data from result set

05 May 2013 - 09:40 AM

hi guys,

 

 

I am trying to setup a login system where when a user enters his username and password and presses the login button, his username and password are sent in an SQL statements to be matched with a User in the database. if the username and password are correct(if they are matched in the database) a User object is created with all of the users data from the database and the user is brought to the Admin Dashboard

 

After doing a lot of research on Result sets etc and going through a lot of code, I still can not make it work in my system. Can anyone show me a good way to do this? Or tell me if there is something obvious wrong with this code?

 

At the moment when I enter in a username and password and press login I get an error in the console:

java.sql.SQLException: Invalid column index at oracle.jdbc.driver.OraclePreparedStatement.setStringInternal(OraclePreparedStatement.java:5321) at oracle.jdbc.driver.OraclePreparedStatement.setString(OraclePreparedStatement.java:5309) at oracle.jdbc.driver.OraclePreparedStatementWrapper.setString(OraclePreparedStatementWrapper.java:280) at database.UserOperations.validateLog(UserOperations.java:45) at gui.Login$2.mouseClicked(Login.java:77)

 

some of the gui code

 

 JButton btnLogin = new JButton("Login");
    btnLogin.addMouseListener(new MouseAdapter() {
        public void mouseClicked(MouseEvent e) {

            UserOperations userOperations = new UserOperations();

            ResultSet rset = userOperations.validateLog(textFieldUsername.getText(), textFieldPassword.getText());
            User user = null;
            try {
                if (rset.next()) {
                    user = new User(rset.getInt("userID"), rset.getString("userName"), rset.getString("userPassword"), rset.getString("securityQuestion"), rset.getString("securityAnswer"),
                        rset.getInt("adminRights"), rset.getString("email"), rset.getString("fName"), rset.getString("phoneNumber"), rset.getString("department"));

                    dispose();
                    AdminDashboard admin = new AdminDashboard();
                    admin.setVisible(true);

                }
                else{

                    JOptionPane.showMessageDialog(null, "Login fail!", "Error", JOptionPane.WARNING_MESSAGE);
                }
            } catch (SQLException e2) {
                e2.printStackTrace();
            }

        }
    });

 

 

validateLogin() method

 

public ResultSet validateLog(String username, String userpassword)
{
    try {
        String sql = "SELECT userid, username, userpassword, securityquestion, securityanswer, adminrights, email, fname, phonenumber, department FROM systeuser WHERE username = ? AND userpassword = ?";

        stmt = conn.prepareStatement(sql);
        stmt.setString (2, username);
        stmt.setString (3, userpassword);
        rset = stmt.executeQuery ( );

    }
    catch(Exception e){
        e.printStackTrace ( );
        JOptionPane.showMessageDialog (null, "Login Failed", null, JOptionPane.WARNING_MESSAGE);
    }
    return rset;

}

 

 

any help is greatly appreciated 


java swing link to new window

04 May 2013 - 02:49 AM

Hi guys, I'm using eclipse window builder for simple swing windows that i am trying to create. i have everything laid out except the forgotten username and password links. does anyone know how i create a link(not a button) like a html link that would take the user to a new window when clicked? what swing component would i use to do this?

 

71c60bb7c80a5eea8447d4e31be3a90f.png

 

edit: i need the link to take me to a new window in the program and not a web browser 


first time JDBC connection

28 April 2013 - 06:37 AM

Hi guys,

just installed oracle database express edition for my home computer. i have the database running and i am connected though SQL developer. i couldn't connect via the basic connection as i kept getting an error (listener refused connection... TNS: listener does not know of SID given connect descriptor) so i connected through a TNS connection with network alias: ORCL 

my problem is now i don't know how to connect my java code to the database so i can run CreateContacts class to make the tables ... currently when i run the CreateContacts class and check in SQL developer if the tables were made, they are not in the database so i assume my java connection(// Home Oracle XE) is incorrect in the DBConnection class. can anyone have a look please and help me get my java connected to my database so i can run the CreateContacts class?

DBConnection class

 

package database;
  
import java.sql.*;
  
import oracle.jdbc.pool.OracleDataSource;
  
public class DBConnection {
  
    private Connection conn = null;
  
    public Connection openDB()
    {
        try
            {   
                OracleDataSource ods = new OracleDataSource();
  
  
                // College
                // ods.setURL("jdbc:oracle:thin:@//10.10.2.7:1521/global1");
                // ods.setUser("x00075734");
                // ods.setPassword("db27Oct90");
  
                // Home Oracle XE
                ods.setURL("jdbc:oracle:thin:HR/SYSTEM@localhost:1521:XE"); // not sure if this line is
                                                                            //is correct
                ods.setUser("SYSTEM");  // username i use to log into oracle database
                ods.setPassword("db27Oct90"); //password i use to log into oracle database
  
                conn = ods.getConnection();
                System.out.println("connected.");               
            }
        catch (Exception e)
            {
                System.out.print("Unable to load driver " + e);
                System.exit(1);
            }   
        return conn;
    }
    public void closeDB()
    {
        try
            {   
                conn.close();
                System.out.print("Connection closed");
            }
        catch (SQLException e)
            {
                System.out.print("Could not close connection ");
                e.printStackTrace();
            }
    }
}

 

 

CreateContacts class

 

package database;
  
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
  
public class CreateContacts
{ 
    private Connection conn = null;
    private PreparedStatement stmt = null;
    private DBConnection db;
  
    public CreateContacts()
    {
        db = new DBConnection();
        conn = db.openDB();
    }   
    public void CreateContactsTable()
    {
        try
            {           
                // Dropping a Table
                String drop = "DROP TABLE Contacts";
                stmt = conn.prepareStatement(drop);
                stmt.executeUpdate();
  
                // Create a Table
                String create = "CREATE TABLE Contacts " +
                        "(id NUMBER PRIMARY KEY, name VARCHAR(40), address VARCHAR(30), pnumber VARCHAR(30), email VARCHAR(20))";
                stmt = conn.prepareStatement(create);
                stmt.executeUpdate(create);
  
                // Insert data into table
  
                String insertString = "INSERT INTO Contacts(id,name,address,pnumber,email) values(?,?,?,?,?)";          
                stmt = conn.prepareStatement(insertString);
  
                stmt.setInt(1, 1);
                stmt.setString(2, "Peter");
                stmt.setString(3, "23 Lime Lane");
                stmt.setString(4, "018776543");
                stmt.setString(5, "p.cassisy@b.com");               
                stmt.executeUpdate();
  
                stmt.setInt(1, 2);
                stmt.setString(2, "Donal");
                stmt.setString(3, "2 Shelbourne rd");
                stmt.setString(4, "012445678");
                stmt.setString(5, "d.oreilly@b.com");               
                stmt.executeUpdate();
  
                stmt.setInt(1, 3);
                stmt.setString(2, "Mary");
                stmt.setString(3, "4 Richmond rd");
                stmt.setString(4, "018765456");
                stmt.setString(5, "m.lawlor@b.com");                
                stmt.executeUpdate();
  
                stmt.setInt(1, 4);
                stmt.setString(2, "Glen");
                stmt.setString(3, "4 Richmond lane");
                stmt.setString(4, "017854563");
                stmt.setString(5, "g.whelan@b.com");                
                stmt.executeUpdate();
  
                conn.commit();
                stmt.close();
                db.closeDB();
            }       
            catch (SQLException e)
            {
                System.out.print("SQL Exception " + e);
                System.exit(1);
            }   
    }   
    public static void main(String args[]) 
    {
        CreateContacts ct = new CreateContacts();
        ct.CreateContactsTable();   
    }
  
}

 


thanks in advance


noob question

11 January 2013 - 12:40 PM

feel stupid for asking this but in java, to create an object of a class i thought you needed the class name then the name of the object you wanted to create.. like this

Student student1 = new Student();

but in this tutorial i am following the author created 2 Image objects in a different way:

plane = new Image("data/plane.png");
land = new Image("data/land.jpg");


what is he doing above? is he creating 2 Image objects or is he doing something else? is this not the correct way to create an object below?:

Image plane = new Image("data/plane.png");
Image land = new Image("data/land.jpg");

PARTNERS