JAVA问题啊

来源:百度知道 编辑:UC知道 时间:2024/06/25 21:19:24
原程序:
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.DriverManager;
import java.sql.Date;
public class QueryODBCTest
{
private Connection con;
public static void main(String[] args)
{
QueryODBCTest test = new QueryODBCTest();
Connection con = test.getConnection();
String sql = "select * from student";
test.getStudent(con, sql);
}
public void getStudent(Connection con, String sql)
{
try
{
Statement st = con.createStatement();
ResultSet rs = st.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("studentName");
String number = rs.getString("studentNumber");
Date date = rs.getDate("studentBirthday");
String sex = rs.getString("studentSex");
System.out.println(("\nstudentName:

找不到驱动.你确定你放的是sqlserver的驱动包吗?放在了Lib目录下?反正就是确认你的classpath中可以找到驱动.
应该是sqlserver.少了个r

jdbc:microsoft:sqlsever://localhost:1433;DatabaseName=Student

jdbc:microsoft:sqlsever://localhost:1433/;DatabaseName=Student

提示是没有找到适当的驱动,有没有SQLServer那个Jar包

驱动没找到.驱动jar包要放在项目web-inf/lib下

还是你的驱动没弄好啊!