Nairaland Forum

I am working on a project (desktop-based application) on building a platform where students and lecturers can interact concerning the school projects being carried out by the students. I have just read a good part of Java SE and want to implement skills through tactile means. I have done a bit in designing interfaces, abstraction and modelling as well as creating classes to accommodate the Student, Staff , these two extending a generic User class. I am presently reading databases in order to be able to store information about the student, staff as well as the projects. I need people with experience in this aspect to help so that i can move faster and complete this project within the timeline I have. Thanks in advance.

Next time, Ask the particular area you need help with.
& please keep this thread updates, i sort of like this idea

What area do you need help exactly?

You want to create a chat engine, you gonna deal with networking a bit, I did one that has a blackboard for someone's project.

you need to learn how to use java to interact with mysql.
to be able to gather information pls try search foe dat

If you need immeadiate knowledge of MySQL, you can use the help documentation that comes with MySQL. 24 hrs should get you started

Thanks guys. I am getting a lot of help watching youtube videos. Thank you for your positive response. I will keep you posted on my progress.

Instead of mysql, u can use access as ur database without worrying your client with database installations. For a project like ds, access won't b a bad idea

a.r.okans:
I am working on a project (desktop-based application) on building a platform where students and lecturers can interact concerning the school projects being carried out by the students. I have just read a good part of Java SE and want to implement skills through tactile means. I have done a bit in designing interfaces, abstraction and modelling as well as creating classes to accommodate the Student, Staff , these two extending a generic User class. I am presently reading databases in order to be able to store information about the student, staff as well as the projects. I need people with experience in this aspect to help so that i can move faster and complete this project within the timeline I have. Thanks in advance.

Guys, I have been able to design User interfaces and the issue with the db is solved now and I still ended up using mysql. Thank you for your invaluable contributions. Really, the issue now is getting to login. I have written methods to handle that which is successfully built but fails to log in valid user. Below are code excerpts to explain my challenges. Meaningful contributions would be appreciated.

public String extractUserIDFromTextField ( JTextField textField){
return textField.getText();
}

public String extractPasswordFromPasswordField (JPasswordField passwordField){
return passwordField.getText();
}

THE ABOVE METHODS ARE OF CLASS USER.

public boolean validateStudentUserID (JTextField textField ) throws Exception{
return extractUserIDFromTextField(textField).matches ("[a-z]{3}/[0-9]{4}/[a-z]{3}";
}

public boolean studentValidityMethod (JTextField textField, JPasswordField passwordField) {
try{

String submittedUserID = extractUserIDFromTextField(textField);
String submittedPassword = extractPasswordFromPasswordField(passwordField);


connection = DriverManager.getConnection ("jdbc:mysql://localhost:3306/spma", "root", null);
statement = connection.createStatement();
resultSet =statement.executeQuery("SELECT matriculationNumber, password FROM studentuser WHERE matriculationNumber = submittedUserID ORDER BY matriculationNumber, password";

resultSet.next();
String correctUserID = resultSet.getString(1);
String correctPassword = resultSet.getString(2);

if ((submittedUserID.equals(correctUserID)) & (submittedPassword.equals(correctPassword)))

studentValidity = true;
else
studentValidity = false;
}
catch(SQLException e){
e.printStackTrace();
}

finally {
return studentValidity;
}

THE METHODS ARE OF StudentUser which extends the previous class User
Then in the login JFrame, under the event handler method i wrote this:
private void logInButtonFieldActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
/** method to grant access to the HomePage is granted if grantAccessToStudentOrNot method returns true or
* if otherwise, access is declined with a response message
*/
try{


if (su.validateStudentUserID(userIDTextField) == true)
{
if (su.studentValidityMethod(userIDTextField, passwordPasswordField) == true)
{this.setVisible(false);
hp.setVisible(true);
}
else
JOptionPane.showMessageDialog(null, "You are not a student", "Error", JOptionPane.ERROR_MESSAGE);
}


After this I run my application and there is no error but the next page HomePage is not displayed.
Suggestions are duly welcomed. Lots of appreciation to you guys.

Let us chat on gTalk or skype for suggestions. my email is a.r.okans@gmail.com

Are you using Netbeans ? if yes, then try to upload a screenshot here please to see what you have done so far that way i can give suggestions

[img][/img]

Nice, was thinking of the same project a few months back but i got occupied by many projects of mine
Anyway, as of this moment apart from the login screen what other screen do you have ?
You posted a non working code of your login- here is a snipet from my own login in my projects i did a year ago

    String sql="Select * from login";
    try {
    Class.forName("com.mysql.jdbc.Driver";
    Connection con= (Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/mine","root","root";
    Statement stmt=con.createStatement();
    ResultSet rs = stmt.executeQuery(sql);
    
    String user=jTextField1.getText();
    String pwd= new String (jPasswordField1.getPassword());
    while(rs.next()) {
    String uname=rs.getString("username";
    
    String password=rs.getString("password";
    if ((user.equals(uname)) && (pwd.equals(password)))  {
    new admin().setVisible(true);
    
    
    }
    else { 
    JOptionPane.showMessageDialog(this, "incorrect username or password";
    }
    }
    }
    catch (Exception e){
    JOptionPane.showMessageDialog(this, e.getMessage());
    }

ermmm.. Why not use git?? (Am assuming by projects you mean software projects though it can manage any thing that is text based) Its opensource and it has been tested. If you don't like the command line or if you want to add features that are particular to students, provide a wrapper application then run git as a seperate process and communicate with it using any IPC method you prefer.

a.r.okans:


Guys, I have been able to design User interfaces and the issue with the db is solved now and I still ended up using mysql. Thank you for your invaluable contributions. Really, the issue now is getting to login. I have written methods to handle that which is successfully built but fails to log in valid user. Below are code excerpts to explain my challenges. Meaningful contributions would be appreciated.

public String extractUserIDFromTextField ( JTextField textField){
return textField.getText();
}

public String extractPasswordFromPasswordField (JPasswordField passwordField){
return passwordField.getText();
}

THE ABOVE METHODS ARE OF CLASS USER.

public boolean validateStudentUserID (JTextField textField ) throws Exception{
return extractUserIDFromTextField(textField).matches ("[a-z]{3}/[0-9]{4}/[a-z]{3}";
}

public boolean studentValidityMethod (JTextField textField, JPasswordField passwordField) {
try{

String submittedUserID = extractUserIDFromTextField(textField);
String submittedPassword = extractPasswordFromPasswordField(passwordField);


connection = DriverManager.getConnection ("jdbc:mysql://localhost:3306/spma", "root", null);
statement = connection.createStatement();
resultSet =statement.executeQuery("SELECT matriculationNumber, password FROM studentuser WHERE matriculationNumber = submittedUserID ORDER BY matriculationNumber, password";

resultSet.next();
String correctUserID = resultSet.getString(1);
String correctPassword = resultSet.getString(2);

if ((submittedUserID.equals(correctUserID)) & (submittedPassword.equals(correctPassword)))

studentValidity = true;
else
studentValidity = false;
}
catch(SQLException e){
e.printStackTrace();
}

finally {
return studentValidity;
}

THE METHODS ARE OF StudentUser which extends the previous class User
Then in the login JFrame, under the event handler method i wrote this:
private void logInButtonFieldActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
/** method to grant access to the HomePage is granted if grantAccessToStudentOrNot method returns true or
* if otherwise, access is declined with a response message
*/
try{


if (su.validateStudentUserID(userIDTextField) == true)
{
if (su.studentValidityMethod(userIDTextField, passwordPasswordField) == true)
{this.setVisible(false);
hp.setVisible(true);
}
else
JOptionPane.showMessageDialog(null, "You are not a student", "Error", JOptionPane.ERROR_MESSAGE);
}


After this I run my application and there is no error but the next page HomePage is not displayed.
Suggestions are duly welcomed. Lots of appreciation to you guys.

Try adding Class.forName("mysqldriver"; d mysql deriver shud b smth lyk com.mysql something. Am not actually sure but u did not refer to any database driver here. The only place you can do dis is in javaDB(derby) it sort of broadcast itself like JINI

@Op, have you populated your database? Please post a screen shot of your computer screen, that will make it easier.

The persistence technology you are using is Obsolete.Please go and readUp about Java Persistence API.So you dnt have to go through the pain of logging into the database with the DriverManager class,in Jpa ,the persistence.xml has the persistence unit configured with the entity classes.What ide are you using to develop? JPA has simplified database applications by persisting entity Objects

javadoctor, im using netbeans. I have heard stuffs about that JPA but ve nt really done anything on it. Please, can we chat?

Please, guys, im sorry for not giving regular updates on this topic. Actually, im on internship with a software firm in Victoria Island and the beginning of the year is usually filled with activities, so im a bit busy now with office DULLING work that I cannot abandon(that is what I'm being paid for now). I will be completing my stuff there in 3 weeks. Then, I can focus more on this project as I mean to really complete it Insha Allah. Please, suggestions are welcome at any time. Keep them coming in. I am also interested in any1 with JSP and servlets knowledge. Let us exchange ideas and help each other grow, Candles light candles. Thank you.

No p,check for my  pin or phone number on my profile