Question

数据库查询的时候rs.close()有错误

这个是我的代码
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class SqlODBCTest {
public static void main(String[] args) throws SQLException{
Connection con=null;
Statement stmt=null;
ResultSet rs=null;
String sql = "select * from user where uname='abc'";
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:bbs","sa","sa");
stmt = con.createStatement();
rs=stmt.executeQuery(sql);
String t=null;
while(rs.next()){
t = rs.getString("uName");
}if(t!=null){
System.out.println(t);
}else{
System.out.println("未找到用户!");
}

}catch(Exception e){
e.printStackTrace();
}finally{
rs.close();
stmt.close();
con.close();
}

}
}
这个是异常的报错
java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]关键字 'user' 附近有语法错误。
at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6957)
at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:7114)
at sun.jdbc.odbc.JdbcOdbc.SQLExecDirect(JdbcOdbc.java:3110)
at sun.jdbc.odbc.JdbcOdbcStatement.execute(JdbcOdbcStatement.java:338)
at sun.jdbc.odbc.JdbcOdbcStatement.executeQuery(JdbcOdbcStatement.java:253)
at com.accpteach.sql.SqlODBCTest.main(SqlODBCTest.java:19)
Exception in thread "main" java.lang.NullPointerException
at com.accpteach.sql.SqlODBCTest.main(SqlODBCTest.java:32)
我导入了驱动包
msbase.jar
msssqlserver.jar
msuitl.jar

Answer 1

String sql = "select * from [user] where uname='abc'";

改下这句应该就行了

Answer 2

得改下表名吧
user 貌似是保留字