主题:ms sqlserver的驱动有问题,请教大家一下
import java.sql.*;
public class tt
{
public static void main(String args[])
{
Connection con=null;
String url="jdbc:microsoft:sqlserver://localhost:1433/movie;user=sa";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select name,price from Bookinfo");
while(rs.next())
{
System.out.println("*********************"+"\n"+"name:"+"\t"+rs.getString("Name")+"\n"+"price:"+"\t"+rs.getString("price"));
}
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
三个jar文件都放到resin中的lib下了,.conf文件的dirver-name也改成com.microsoft.jdbc.sqlserver.SQLServerDriver了
url改成了jdbc:microsoft:sqlserver://localhost:1433;databaseName=movie,我觉得应该都改好了啊,唉
但是还是提示ClassNoFoundException:com.microsoft.jdbc.sqlserver.SQLServerDriver.真郁闷!!
请会的高手哥哥姐姐帮忙看一下,帮我解决吧!!先谢过!!!
public class tt
{
public static void main(String args[])
{
Connection con=null;
String url="jdbc:microsoft:sqlserver://localhost:1433/movie;user=sa";
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con=DriverManager.getConnection(url);
Statement stmt=con.createStatement();
ResultSet rs=stmt.executeQuery("select name,price from Bookinfo");
while(rs.next())
{
System.out.println("*********************"+"\n"+"name:"+"\t"+rs.getString("Name")+"\n"+"price:"+"\t"+rs.getString("price"));
}
con.close();
}
catch(SQLException e)
{
e.printStackTrace();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
三个jar文件都放到resin中的lib下了,.conf文件的dirver-name也改成com.microsoft.jdbc.sqlserver.SQLServerDriver了
url改成了jdbc:microsoft:sqlserver://localhost:1433;databaseName=movie,我觉得应该都改好了啊,唉
但是还是提示ClassNoFoundException:com.microsoft.jdbc.sqlserver.SQLServerDriver.真郁闷!!
请会的高手哥哥姐姐帮忙看一下,帮我解决吧!!先谢过!!!