مشکل در فرم login

[sajadjamalian]

سلام دوستان:
من دارم یه فرم ورود طراحی میکنم ولی موقع اجرا ایراد میگیره، کسی میدونه باید چیکار کنم؟؟؟؟؟

کد:

import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.sql.*;

import javax.swing.JOptionPane;

public class Form1 extends Applet implements ActionListener {

TextField name, pass;
Button login;
String msg, msg1, user1, pass1;
private static Connection link;
private static Statement statement;
private static ResultSet results;

public void init() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.sqlserverdriver");
String connectionurl = "jdbc:sqlserver://localhost:1433;databasename=rs;user=sa;password=12 3456;";
link = DriverManager.getConnection(connectionurl);
}
catch(ClassNotFoundException cnfex)
{
JOptionPane.showMessageDialog(this, cnfex.toString());
}
catch (SQLException sqlex) {
showStatus("not connect");
}
this.setSize(200, 200);
login = new Button("login");
Label namep = new Label("Name: ", Label.RIGHT);
Label passp = new Label("Password: ", Label.RIGHT);
name = new TextField(12);
pass = new TextField(12);
pass.setEchoChar('*');

add(namep);
add(name);
add(passp);
add(pass);
add(login);

// register to receive action events
name.addActionListener(this);
pass.addActionListener(this);
login.addActionListener(this);
}

// user pressed enter.
public void actionPerformed(ActionEvent ae) {
String str = ae.getActionCommand();
if (str == "login") {
try {
statement = link.createStatement();
String select = "select * from users where username= "
+ name.getText().toString() + " and password= "
+ pass.getText().toString() + "";
results = statement.executeQuery(select);
while (results.next()) {
user1 = results.getString("username");
pass1 = results.getString("password");
}
if (name.getText().equals(user1)
&& pass.getText().equals(pass1)) {
JOptionPane.showMessageDialog(this, "correct");
} else {
JOptionPane.showMessageDialog(this, "incorrect");
}
} catch (SQLException sqlex) {
JOptionPane.showMessageDialog(this, "cannot connect");
}
}
repaint();
}

public void paint(Graphics g) {

}
}


خطا:

java.lang.ClassNotFoundException:com.microsoft.sql server.jdbc.sqlserverdriver

[javaphantom]

سلام دوستان:
من دارم یه فرم ورود طراحی میکنم ولی موقع اجرا ایراد میگیره، کسی میدونه باید چیکار کنم؟؟؟؟؟

کد:

import java.awt.*;
import java.awt.event.*;
import java.applet.*;
import java.sql.*;

import javax.swing.JOptionPane;

public class Form1 extends Applet implements ActionListener {

TextField name, pass;
Button login;
String msg, msg1, user1, pass1;
private static Connection link;
private static Statement statement;
private static ResultSet results;

public void init() {
try {
Class.forName("com.microsoft.sqlserver.jdbc.sqlserverdriver");
String connectionurl = "jdbc:sqlserver://localhost:1433;databasename=rs;user=sa;password=12 3456;";
link = DriverManager.getConnection(connectionurl);
}
catch(ClassNotFoundException cnfex)
{
JOptionPane.showMessageDialog(this, cnfex.toString());
}
catch (SQLException sqlex) {
showStatus("not connect");
}
this.setSize(200, 200);
login = new Button("login");
Label namep = new Label("Name: ", Label.RIGHT);
Label passp = new Label("Password: ", Label.RIGHT);
name = new TextField(12);
pass = new TextField(12);
pass.setEchoChar('*');

add(namep);
add(name);
add(passp);
add(pass);
add(login);

// register to receive action events
name.addActionListener(this);
pass.addActionListener(this);
login.addActionListener(this);
}

// user pressed enter.
public void actionPerformed(ActionEvent ae) {
String str = ae.getActionCommand();
if (str == "login") {
try {
statement = link.createStatement();
String select = "select * from users where username= "
+ name.getText().toString() + " and password= "
+ pass.getText().toString() + "";
results = statement.executeQuery(select);
while (results.next()) {
user1 = results.getString("username");
pass1 = results.getString("password");
}
if (name.getText().equals(user1)
&& pass.getText().equals(pass1)) {
JOptionPane.showMessageDialog(this, "correct");
} else {
JOptionPane.showMessageDialog(this, "incorrect");
}
} catch (SQLException sqlex) {
JOptionPane.showMessageDialog(this, "cannot connect");
}
}
repaint();
}

public void paint(Graphics g) {

}
}


خطا:

java.lang.ClassNotFoundException:com.microsoft.sql server.jdbc.sqlserverdriver

شما باید jar فایلی که مربوط به sql server هست رو به class path اضافه کنید