package com.test.action;import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class SQL { public static void main(String[]args){
String dirverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动
String URL="jdbc:sqlserver://localhost:1433; DatabaseName=sic_itemSystem";
String SqlUsername="sa";
String SqlPwd="sa";
Connection conn=null;
Statement stmt=null;
ResultSet rset=null;
String pd=null;
try{
Class.forName(dirverName);
conn=DriverManager.getConnection(URL,SqlUsername,SqlPwd);
stmt=conn.createStatement();
rset=stmt.executeQuery("SELECT * FROM user");
while(rset.next()){
pd=rset.getString("userName");
System.out.println(pd);
}
}catch(ClassNotFoundException e1){
e1.printStackTrace();
}catch(SQLException e2){
e2.printStackTrace();
}catch(Exception e3){
e3.printStackTrace();
}finally{
try{
conn.close();
stmt.close();
rset.close();
}catch(SQLException e){
}
}
}
}出现一下问题com.microsoft.sqlserver.jdbc.SQLServerException: ' ' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
at com.test.action.SQL.main(SQL.java:26)
Exception in thread "main" java.lang.NullPointerException
at com.test.action.SQL.main(SQL.java:41)
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;public class SQL { public static void main(String[]args){
String dirverName="com.microsoft.sqlserver.jdbc.SQLServerDriver";//加载JDBC驱动
String URL="jdbc:sqlserver://localhost:1433; DatabaseName=sic_itemSystem";
String SqlUsername="sa";
String SqlPwd="sa";
Connection conn=null;
Statement stmt=null;
ResultSet rset=null;
String pd=null;
try{
Class.forName(dirverName);
conn=DriverManager.getConnection(URL,SqlUsername,SqlPwd);
stmt=conn.createStatement();
rset=stmt.executeQuery("SELECT * FROM user");
while(rset.next()){
pd=rset.getString("userName");
System.out.println(pd);
}
}catch(ClassNotFoundException e1){
e1.printStackTrace();
}catch(SQLException e2){
e2.printStackTrace();
}catch(Exception e3){
e3.printStackTrace();
}finally{
try{
conn.close();
stmt.close();
rset.close();
}catch(SQLException e){
}
}
}
}出现一下问题com.microsoft.sqlserver.jdbc.SQLServerException: ' ' 附近有语法错误。
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeQuery(Unknown Source)
at com.test.action.SQL.main(SQL.java:26)
Exception in thread "main" java.lang.NullPointerException
at com.test.action.SQL.main(SQL.java:41)
at com.test.action.SQL.main(SQL.java:41)调一调41行' ' 附近有语法错误。
是不是多个空格
SELECT * FROM user
这句中间原来好像有个全角空格 你把它删了 试试