首次使用jdbc,很多不懂,请教大家,我从microsoft上下载了sqlserver的jdbc,测试代码如下
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
//pubs 为你的数据库的
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from message";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
您的第一个字段内容为:<%=rs.getString(1)%><br>
您的第二个字段内容为:<%=rs.getString(2)%><br>
<% } %>
<% out.print("数据库操作成功,恭喜你"); %>
<% rs.close();
stmt.close();
conn.close();这个是网上搜索来的最多的测试代码
但是一直都不成功
错误如下::/book/sql.jsp:5: illegal character: \12288
\u3000
^
/book/sql.jsp:7: illegal character: \12288
String\u3000url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
^
/book/sql.jsp:7: not a statement
String\u3000url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
^
/book/sql.jsp:9: illegal character: \12288
String\u3000user="sa";
^
/book/sql.jsp:9: not a statement
String\u3000user="sa";
^
/book/sql.jsp:10: illegal character: \12288
String\u3000password="sa";
^
/book/sql.jsp:10: not a statement
String\u3000password="sa";
^
/book/sql.jsp:11: illegal character: \12288
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:11: not a statement
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:11: illegal character: \12288
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:12: illegal character: \12288
Statement\u3000stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
/book/sql.jsp:12: not a statement
Statement\u3000stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
/book/sql.jsp:13: illegal character: \12288
String\u3000sql="select * from\u3000message";
^
/book/sql.jsp:13: not a statement
String\u3000sql="select * from\u3000message";
^
/book/sql.jsp:14: illegal character: \12288
ResultSet\u3000rs=stmt.executeQuery(sql);
^
/book/sql.jsp:14: not a statement
ResultSet\u3000rs=stmt.executeQuery(sql);
^
/book/sql.jsp:15: illegal character: \12288
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:15: illegal character: \12288
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:18: illegal character: \12288
\u3000}\u3000
^
/book/sql.jsp:18: illegal character: \12288
\u3000}\u3000
^
/book/sql.jsp:19: illegal character: \12288
\u3000out.print("\u6570\u636e\u5e93\u64cd\u4f5c\u6210\u529f\uff0c\u606d\u559c\u4f60");\u3000
^
/book/sql.jsp:19: illegal character: \12288
\u3000out.print("\u6570\u636e\u5e93\u64cd\u4f5c\u6210\u529f\uff0c\u606d\u559c\u4f60");\u3000
^
/book/sql.jsp:20: illegal character: \12288
\u3000rs.close();
^
/book/sql.jsp:15: cannot resolve symbol
symbol : variable rs
location: class _jsp._book._sql__jsp
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:21: cannot resolve symbol
symbol : variable stmt
location: class _jsp._book._sql__jsp
stmt.close();
^
/book/sql.jsp:22: cannot resolve symbol
symbol : variable conn
location: class _jsp._book._sql__jsp
conn.close();
^
26 errors
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
//pubs 为你的数据库的
String user="sa";
String password="sa";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from message";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
%>
您的第一个字段内容为:<%=rs.getString(1)%><br>
您的第二个字段内容为:<%=rs.getString(2)%><br>
<% } %>
<% out.print("数据库操作成功,恭喜你"); %>
<% rs.close();
stmt.close();
conn.close();这个是网上搜索来的最多的测试代码
但是一直都不成功
错误如下::/book/sql.jsp:5: illegal character: \12288
\u3000
^
/book/sql.jsp:7: illegal character: \12288
String\u3000url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
^
/book/sql.jsp:7: not a statement
String\u3000url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=booksms";
^
/book/sql.jsp:9: illegal character: \12288
String\u3000user="sa";
^
/book/sql.jsp:9: not a statement
String\u3000user="sa";
^
/book/sql.jsp:10: illegal character: \12288
String\u3000password="sa";
^
/book/sql.jsp:10: not a statement
String\u3000password="sa";
^
/book/sql.jsp:11: illegal character: \12288
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:11: not a statement
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:11: illegal character: \12288
Connection\u3000conn=\u3000DriverManager.getConnection(url,user,password);
^
/book/sql.jsp:12: illegal character: \12288
Statement\u3000stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
/book/sql.jsp:12: not a statement
Statement\u3000stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
^
/book/sql.jsp:13: illegal character: \12288
String\u3000sql="select * from\u3000message";
^
/book/sql.jsp:13: not a statement
String\u3000sql="select * from\u3000message";
^
/book/sql.jsp:14: illegal character: \12288
ResultSet\u3000rs=stmt.executeQuery(sql);
^
/book/sql.jsp:14: not a statement
ResultSet\u3000rs=stmt.executeQuery(sql);
^
/book/sql.jsp:15: illegal character: \12288
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:15: illegal character: \12288
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:18: illegal character: \12288
\u3000}\u3000
^
/book/sql.jsp:18: illegal character: \12288
\u3000}\u3000
^
/book/sql.jsp:19: illegal character: \12288
\u3000out.print("\u6570\u636e\u5e93\u64cd\u4f5c\u6210\u529f\uff0c\u606d\u559c\u4f60");\u3000
^
/book/sql.jsp:19: illegal character: \12288
\u3000out.print("\u6570\u636e\u5e93\u64cd\u4f5c\u6210\u529f\uff0c\u606d\u559c\u4f60");\u3000
^
/book/sql.jsp:20: illegal character: \12288
\u3000rs.close();
^
/book/sql.jsp:15: cannot resolve symbol
symbol : variable rs
location: class _jsp._book._sql__jsp
while(rs.next())\u3000{\u3000
^
/book/sql.jsp:21: cannot resolve symbol
symbol : variable stmt
location: class _jsp._book._sql__jsp
stmt.close();
^
/book/sql.jsp:22: cannot resolve symbol
symbol : variable conn
location: class _jsp._book._sql__jsp
conn.close();
^
26 errors
解决方案 »
- 关于filter
- jsp通过 < a href="xxxxxxxxxxxx/xxxx/action"/>提交的问题。。。
- lomboz eclipse3.3运行jsp页面 web browser怎么启动不起来???
- 怎么实现网络上打开服务器上的文件?另有好的方法也可。帮忙侃侃!
- ???????????
- 能否告诉这个错误在哪?
- 急啊,各位高手帮帮忙啊,谢谢了……
- select的option问题,请大家帮忙
- 撒分啦!JTable的问题
- 为何insert语句在access中可执行,在jsp里执行数据无法加入表中呢!
- 绝对高手,非高手删.AJAX,sql,php,骇客 技术俱乐部QQ群14471754
- 请各位哥们,帮忙修改一下!
一大堆乱七八糟的字符
从网上直接复制下来是不行的
要将中文空可和符号删掉