Creating a login form using sql server 2005 database

[kine]

Hello Guys
I'm creating a login form using java swing GUI and sql server 2005 database, i can connect to the database, but i have difficulty using created username and password in my database-security-user to login in the login GUI.

I will appreciate assistance from guys in creating a login form that will display another GUI.

help me out pls!

[Sno]

Please Present Code.

[kine]

Here is code for my database creating the username and password.

CREATE LOGIN nayd13 WITH PASSWORD = 'welcome';
USE SDIM;
CREATE USER Neyds FOR LOGIN neyd13;

now my connection to database sql server 2005 is

try {
Class.forName(“com.microsoft.sqlserver.jdbc.SQLSer verDriver”);

Connection con = DriverManager.getConnection(connectionUrl);
if(con != null)
{System.out.println("connection sucessful");}
else {System.out.println("no connection");}
}
catch (SQLException e) {
e.printStackTrace();
}
catch (ClassNotFoundException cE) {
e.printStackTrace();
}
which connect sucessfuly.

well using created username and password in the database is login, which will display another Jform window application is what i'm an having diffculty writing the code for it.
ie
private void entBtnActionPerformed(java.awt.event.ActionEvent evt){

Help me here pls...

}
using my created usename and password to login and display a new window

thanx

[Sno]

So wait... write out the steps of the process you are trying to do.

1. Login
2. Go to new window?

If these are your steps, In the login, on the btn you will have to use a select statement and compare your username to the one you typed in, than if correct, go to a new window.

so you should research passing sql statements and displaying displaying new window.

[Tolls]

It's not a login, as in a user table.
He's using SQL Server security, so the login is in the connection URL...at least that's what it looks like to me?

[kine]

Now i have difficulty writting out the code to reset user password in the database after login into the application.

Here is my code

char[] oldPass = jPasswordField1.getPassword();
String strOldPass = new String(oldPass);

char[] newPass = jPasswordField2.getPassword();
String strNewPass = new String(newPass);

char[] confPass = jPasswordField3.getPassword();
String strConfPass = new String(confPass);

try
{
Inventory objInven = new Inventory();//creating of the objectof the connection in class Inventory.

Statement stmt = objinven.con.createStatement();
ResultSet rs = stmt.getResult();

while(rs.next())
{
if(rs.getsring("Password").equals(strOldPass))
{
rs.moveToInserRow();
rs.updateString("Password", strNewPass);
rs.updateString("Password", strConfPass);

if(strNewPass.equals(strConfPass))
{
JOptionPane.showMessageDialog(this, "Password change successfuly");
}
else
{JOptionPane.showMessageDialog(this, "Password do not match");
}
}
else
{
JOptionPane.showMessageDialog(this, "Wrong old Password");

}
}
catch(SQLException ex)
{
ex.printStackTrace();
}
}

this code is to be performed when a submit button is clicked.
i have this error : Exception occurred during event dispatching: jana.lang.NullPointerException.

please help me out with this code that will allow users to change their old password to a new one in the database created by correcting my error

Thanx

[al_Marshy_1981]

Don't change password arrays to Strings

char[] oldPass = jPasswordField1.getPassword();
String strOldPass = new String(oldPass);

char[] newPass = jPasswordField2.getPassword();
String strNewPass = new String(newPass);

char[] confPass = jPasswordField3.getPassword();
String strConfPass = new String(confPass);


if(rs.getsring("Password").equals(strOldPass))

You defeat the reason why passwords are character arrays

do this

char oldPass[]=PasswordField1.getPassword();
char newPass[]=jPasswordField2.getPassword();
char confPass[]=jPassWordField3.getPassword();

// check if char arrays are equal
boolean same=Arrays.equals(newPass,confPass);

// change arrays when done
Arrays.fill(newPass, ' ');
Arrays.fill(oldPass, ' ');
etc..

[wzq110120]

china friend.

please give all of code.