各位能帮我找这个语法错误吗?谢谢了
易点互联 2004-09-08 09:51:57 错误信息:
java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'user' 附近有语法错误。
部分代码:
Connection con = null;
Statement stmt1 = null;
ResultSet rs = null;
String name;
String pass;
request.setCharacterEncoding("GB2312");
String employee_id = null;
String last_name=(String)request.getAttribute("last_name");
String first_name=(String)request.getAttribute("first_name");
%>
<%
try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=lb_db";
con = DriverManager.getConnection(url,"sa","123");
stmt1 = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY);
String query = "SELECT * FROM user";
rs = stmt1.executeQuery(query);
rs.last();
name = rs.getString("username");
pass = rs.getString("pass");
stmt1.close();
con.close();
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
finally
{
try {
if(con != null)
{
con.close();
}
}
catch(SQLException sqle)
{
out.println("sqle="+sqle);
}
}