源代码
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=qgy";
// pubs为数据库名称
String user = "xk";
String password = "xksql";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = "select * from cd_ryxx";
ResultSet rs = stmt.executeQuery(sql);
int i = 0;
while (rs.next()) {
if (i > 3)
break;
else
i++;
%>
您的第一个字段内容为:<%= rs.getString(1) %>
您的第二个字段内容为:<%= rs.getString(2) %>
<% } %>
<% out.print("数据库操作成功,恭喜你"); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</BODY>
</HTML>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY>
<%
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url = "jdbc:microsoft:sqlserver://127.0.0.1;DatabaseName=qgy";
// pubs为数据库名称
String user = "xk";
String password = "xksql";
Connection conn = DriverManager.getConnection(url, user, password);
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
String sql = "select * from cd_ryxx";
ResultSet rs = stmt.executeQuery(sql);
int i = 0;
while (rs.next()) {
if (i > 3)
break;
else
i++;
%>
您的第一个字段内容为:<%= rs.getString(1) %>
您的第二个字段内容为:<%= rs.getString(2) %>
<% } %>
<% out.print("数据库操作成功,恭喜你"); %>
<%
rs.close();
stmt.close();
conn.close();
%>
</BODY>
</HTML>
解决方案 »
- weblogic 文件下载线程问题?
- Struts2的跳转问题
- struts2实现权限控制的问题!【快来人啊!!!!】
- 关于获取下载文件名的问题
- Quartz在pauseJob后resume的时候,trigger连续触发!怎么办?
- J2EE项目打包发布后打不开
- 要做个web系统,不知道选什么server,那位高人给点意见
- 关于hibernate的问题,急。,,
- 关于webwork2里的validator如何用呢?
- 部署到jboss上面,jboss为什么总用它自己的数据源,怎么配置到我的数据源???
- 关于用paintComponent(Graphics comp)绘图的问题,为什么我画的东西没有显示?
- IIS6.0与Resin_3.0.8的整合
500 Servlet Exception
java.lang.ClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
at com.caucho.util.DynamicClassLoader.loadClass(DynamicClassLoader.java:530)
at java.lang.ClassLoader.loadClass(ClassLoader.java:255)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:315)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:140)
at _myjsp._databaselink__jsp._jspService(/myjsp/databaselink.jsp:6)
at com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at com.caucho.jsp.Page.subservice(Page.java:506)
at com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at com.caucho.server.http.Invocation.service(Invocation.java:315)
at com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at com.caucho.server.http.RunnerRequest.handleRequest(RunnerRequest.java:344)
at com.caucho.server.http.RunnerRequest.handleConnection(RunnerRequest.java:274)
at com.caucho.server.TcpConnection.run(TcpConnection.java:139)
at java.lang.Thread.run(Thread.java:536)
--------------------------------------------------------------------------------
Resin 2.1.9 (built Tue Apr 15 14:28:40 PDT 2003)
你这个是邮箱,还是qq啊