我的jsp页面:
(在ie中运行出错提示:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'user' 附近有语法错误)
-------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>test_bean</title>
</head>
<body><%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Web1";
try
{
Class.forName(sDBDriver).newInstance();
}
catch(ClassNotFoundException e){out.print(e);}
try{
//连接数据库
conn=DriverManager.getConnection(sConnStr,"sa","");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from user");
//将数据在表格中显示
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=50>"+"name");
out.print("<TH width=300>"+"email");
out.print("<TH width=50>"+"www");
out.print("<TH width=50>"+"oicq");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString("name")+"</TD>");
out.print("<TD>"+rs.getString("email")+"</TD>");
out.print("<TD>"+rs.getString("www")+"</TD>");
out.print("<TD>"+rs.getString("oicq")+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
stmt.close();
conn.close();
}
catch(SQLException e){out.print(e);}
%>
</body>
</html>
(在ie中运行出错提示:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]在关键字 'user' 附近有语法错误)
-------------------------------------
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<title>test_bean</title>
</head>
<body><%
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
String sDBDriver="com.microsoft.jdbc.sqlserver.SQLServerDriver";
String sConnStr="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Web1";
try
{
Class.forName(sDBDriver).newInstance();
}
catch(ClassNotFoundException e){out.print(e);}
try{
//连接数据库
conn=DriverManager.getConnection(sConnStr,"sa","");
stmt=conn.createStatement();
rs=stmt.executeQuery("select * from user");
//将数据在表格中显示
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=50>"+"name");
out.print("<TH width=300>"+"email");
out.print("<TH width=50>"+"www");
out.print("<TH width=50>"+"oicq");
out.print("</TR>");
while(rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString("name")+"</TD>");
out.print("<TD>"+rs.getString("email")+"</TD>");
out.print("<TD>"+rs.getString("www")+"</TD>");
out.print("<TD>"+rs.getString("oicq")+"</TD>");
out.print("</TR>");
}
out.print("</Table>");
stmt.close();
conn.close();
}
catch(SQLException e){out.print(e);}
%>
</body>
</html>
解决方案 »
- 如何把字符串"220.45.100"转变成Color?
- 求电子书 Tcp/ip Sockets in Java
- 用swing 做个增加用户界面
- 如何利用java的“短路”现象?
- 关于JTable和JScrollPane的问题
- 各位帮忙看下服务器验证身份的一段代码,先谢谢了!今晚本人一直在线,急!
- 诚心请教JAVA图形用户界面和IO处理问题!
- 请教:linux下字符的问题
- 现在有没有支持jdk1.5.0的开发工具(IDE)?
- 能否贴个二叉树结构和遍历的源程序?50相送
- 如何能让一个JFRAME在运行显示时,总是处在桌面的最前面。
- OutOfMemoryException与StackOverFlowError
比如UserTable
然后 select * from UserTable
因为user可能是关键字
我就把user 改为了user1就好了
结贴