Package TSZ1;
Import java.sql.*;
public class Rushenzhou {
Connection con;
Statement STA;
ResultSet rs;
String driver;
String URL;
String user;
String pwd;
Public Rushenzhou ()
{
Driver = "Com.microsoft.jdbc.sqlserver.SQLServerDriver";
url = "Jdbc:microsoft:sqlserver://localhost:1433;databasename =xiongying";
Test is the database name
user = "SA";
PWD = "Chenxue";
Please change the appropriate user and password for you
Init ();
}
public void Init ()
{
try{
Class.forName (driver);
System.out.println ("Driver is OK");
con = drivermanager.getconnection (url,user,pwd);
System.out.println ("conection is OK");
/* STA = con.createstatement ();
rs = Sta.executequery ("Select * from room");
while (Rs.next ())
System.out.println (Rs.getint ("Roomnum")); */
}catch (Exception e)
{
E.printstacktrace ();
}
}
public static void Main (String args[])
{
Rushenzhou db=new Rushenzhou ();
}
}
Java.lang.ClassNotFoundException:com.mircsoft.jdbc.sqlserver.SQLserverDriver in MyEclipse Java project
I'm sure the driver has been installed and upgraded to SP3, the database table named Xiongying