1.jdbc下载:http://www.microsoft.com/china/sql/downloads/2000/jdbc.asp
后setup.
2.加入classpath中
______________________________________________________________________
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import = "java.sql.*" %>
<%
/**address: SQL Server的连接参数*/
String address = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
/***user: 数据库用户名*/
String user="sa";
/**passwd: 用户密码*/
String passwd="";
/*数据库名*/
String database = "online"; DatabaseMetaData conMD = null;
java.sql.Statement stmt = null;
Connection con = null;
ResultSet sqlRst = null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(address,user,passwd); conMD = con.getMetaData();
con.setCatalog(database);
stmt = con.createStatement();
}catch(Exception fs) {
out.print("Connection ERROR</p> <br>");
}
out.print("Connection</p> <br>"); try
{
stmt=con.createStatement();
sqlRst = stmt.executeQuery("SELECT * FROM mytable");
out.print("stmt OK");
}catch(Exception gr)
{
out.print("stmt ERROR");
} while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("name") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("old") + "</p>");
}
%>
后setup.
2.加入classpath中
______________________________________________________________________
<%@ page contentType = "text/html; charSet=gb2312" %>
<%@ page language="java" import = "java.sql.*" %>
<%
/**address: SQL Server的连接参数*/
String address = "jdbc:microsoft:sqlserver://127.0.0.1:1433";
/***user: 数据库用户名*/
String user="sa";
/**passwd: 用户密码*/
String passwd="";
/*数据库名*/
String database = "online"; DatabaseMetaData conMD = null;
java.sql.Statement stmt = null;
Connection con = null;
ResultSet sqlRst = null; try
{
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
con = DriverManager.getConnection(address,user,passwd); conMD = con.getMetaData();
con.setCatalog(database);
stmt = con.createStatement();
}catch(Exception fs) {
out.print("Connection ERROR</p> <br>");
}
out.print("Connection</p> <br>"); try
{
stmt=con.createStatement();
sqlRst = stmt.executeQuery("SELECT * FROM mytable");
out.print("stmt OK");
}catch(Exception gr)
{
out.print("stmt ERROR");
} while (sqlRst.next())
{
out.print("<p>name :" + sqlRst.getString("name") + "</p> <br>");
out.print("<p>old :" + sqlRst.getString("old") + "</p>");
}
%>
解决方案 »
- servlet中用了流的形式输出html , 如何在浏览器中打开一个新的窗口
- 天气预报怎么做啊
- vbscript能不能用在JSP中?
- 请问:在JSP中怎么把字符串转换为DOUBLE和INT型???急急!!!!!
- 如何执行一个servlet文件
- 关于多语言开发、全局变量定义、树型结构和图文混排系统开发的几个问题请教
- 请问各位大虾!在jsp中如何调用xml格式的数据?
- oracle driver发在struts的什么位置上,tomcat启动时才能找到?
- JSP中如何禁用EXCEL组件的保存功能按钮
- hibernate 多对一映射
- jsp 如何实现 IE文件菜单中‘另存为’的功能。简单的说就是在网页中加个按钮,点击之后可以把本页的页面另存为txt/html文件。在线等待,
- 简单的痛苦的问题!
while (rs.next())
{
String s1 = rs.getString("name");
out.println(s1);
}
我想问一下。
到底应该具体把哪个加到classpath里呢?
我装的完了。
装在d盘的Microsoft SQL Server 2000 driver for JDBC了。
是不是在classpath里追加d:\Microsoft SQL Server 2000 driver for JDBC就可以了呢?
还是要加里面具体的哪个目录呢?
谢谢了。
谢谢各位对我的帮助。
弄好了一定加分。
现在运行 cayu(中原)的程序当然已经改了数据库和表名以及字段名
错误如下:A Servlet Exception Has Occurred
java.lang.NullPointerException
at org.apache.jsp.lala$jsp._jspService(lala$jsp.java:167)
at org.apache.jasper.runtime.HttpJspBase.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown Source)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown Source)
at org.apache.jasper.servlet.JspServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown Source)
at org.apache.catalina.core.StandardWrapperValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardContext.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.valves.AccessLogValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.core.StandardEngineValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invokeNext(Unknown Source)
at org.apache.catalina.core.StandardPipeline.invoke(Unknown Source)
at org.apache.catalina.core.ContainerBase.invoke(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.process(Unknown Source)
at org.apache.catalina.connector.http.HttpProcessor.run(Unknown Source)
at java.lang.Thread.run(Thread.java:484)各位高手看一下应该怎么弄。
是不是classpth还要加什么呢?
谢谢各位了。
http://www.j-netdirect.com/
你可以去看看,可以下载的是无连接限制的,30天试用的。还是jdbc4的呢。