急~~jdbc连接sqlserver 2000的问题
源码:
package DB;
import java.sql.*;
import javax.sql.*;
import javax.naming.*;
public class DBUtils
{
private String url = "jdbc:microsoft:sqlserver://127.0.0.1:1433;User=sa;Password=sa;DatabaseName=j2ee";
private String DriverName = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
private PreparedStatement st = null;
private Statement stmt = null;
private ResultSet rs = null;
private Connection conn = null;
public DBUtils(){}
public void select()
{
try
{
String sql = "select * from User";
Class.forName(DriverName);
conn = DriverManager.getConnection(url);
stmt = conn.createStatement();
rs = stmt.executeQuery(sql);
while(rs.next())
{
String name = rs.getString("name");
String password = rs.getString("password");
System.out.println(name);
System.out.println(password);
}
rs.close();
stmt.close();
conn.close();
}catch(Exception e)
{
System.out.println(e.getMessage());
}
}
public static void main(String []args)
{
DBUtils DB = new DBUtils();
DB.select();
}
}
错误:
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'User' 附近有语法错误。