package test;
import java.sql.*;
public class dbConn {
public static void main(String[] args) {
// TODO Auto-generated method stub
String driverName = "com.microsoft.sqlserver.jdbc.SQLServerDriver";
//指明驱动程序
String dbURL = "jdbc:sqlserver://localhost:1433; DatabaseName=test";
//使用jdbc连接
//指明服务器地址，以及数据库的名字
String userName = "sa";//数据库的用户名
String userPwd = "123456";//数据库的密码
Statement stmt = null;
ResultSet rs = null;//用来存放查询结果
Connection dbConn;//建立连接
try{
Class.forName(driverName);
dbConn = DriverManager.getConnection(dbURL, userName, userPwd);
System.out.println("Connection Successful!");
String SQL = "select * from grade"; //SQL查询代码
stmt = dbConn.createStatement();
rs = stmt.executeQuery(SQL);//执行SQL查询代码
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2) + " " + rs.getString(3)
+ " " + rs.getString(4) + "=" + rs.getString(5) + " " + rs.getString(6));
}
}
catch (Exception e) {
e.printStackTrace();
}
}
}
连接成功了但是有问题啊
Connection Successful! //连接成功了
com.microsoft.sqlserver.jdbc.SQLServerException: 索引 4 超出范围。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:226)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.verifyValidColumnIndex(SQLServerResultSet.java:571)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getterGetColumn(SQLServerResultSet.java:2008)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2037)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getValue(SQLServerResultSet.java:2023)
at com.microsoft.sqlserver.jdbc.SQLServerResultSet.getString(SQLServerResultSet.java:2454)
at test.dbConn.main(dbConn.java:28)