代码运行时出现错误,代码如下:
import java.sql.*;
public class Test
{
public static void main(String[] args)
{
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try
{
String Url = "jdbc:sqlserver://localhost:1433;" +
"databaseName=XSCJ;user=lenovo;password=12345;";
conn = DriverManager.getConnection(Url); stmt=conn.createStatement();
sql="select * from t_seledon";
rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
显示错误如下:
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:14)
工程建立如下:
import java.sql.*;
public class Test
{
public static void main(String[] args)
{
String sql;
Connection conn;
Statement stmt;
ResultSet rs;
try
{
String Url = "jdbc:sqlserver://localhost:1433;" +
"databaseName=XSCJ;user=lenovo;password=12345;";
conn = DriverManager.getConnection(Url); stmt=conn.createStatement();
sql="select * from t_seledon";
rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
显示错误如下:
at com.microsoft.sqlserver.jdbc.SQLServerConnection.login(SQLServerConnection.java:817)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(SQLServerConnection.java:700)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(SQLServerDriver.java:842)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at Test.main(Test.java:14)
工程建立如下:
而LZ的就只是一个String
换一下试试看吧
String username = "aaa";
String password = "aaa";Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();Connection conn = DriverManager.getConnection(url, username, password);你少了这个:Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();