设置CLASSPATH为 .;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar把以上三个文件直接考到tomcat/common/lib文件夹里试试看。
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con=DriverManager.getConnection("jdbc:odbc:ds");
Statement stmt=con.createStatement();
}
catch(Throwable e)
{
e.printStackTrace();
}
.;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msbase.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\msutil.jar;C:\Program Files\Microsoft SQL Server 2000 Driver for JDBC\lib\mssqlserver.jar把以上三个文件直接考到tomcat/common/lib文件夹里试试看。
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@ page contentType="text/html;charset=ISO8859_1"%>
<!--不支持用out.print输出中文-->
<title>JSP-JDBC网页</title>
</head>
<body>
<%@ page language="java" import="java.io.* java.sql.*"%>
<%
java.sql.Connection sqlconn;
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
sqlconn=java.sql.DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=Agriculture","sa","");
Statement stmt=null;
stmt=sqlconn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
%>
<%
String selsql="select * from Information";
ResultSet result=stmt.executeQuery(selsql);
out.println("<table border=1>");
while(result.next())
{
out.println("<tr><td>");
out.println(result.getInt("Info_ID"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Supply"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Product"));
out.println("</td>");
out.println("<td>");
out.println(result.getString("Ground"));
out.println("</td>");
out.println("<td>");
out.println(result.getDate("Info_AnnounceDate"));
out.println("</td></tr>");
}
//getTime时间
out.println("</table>");
result.close();
stmt.close();
sqlconn.close();
%>
<%!
public String GBK2UNI(String s)
throws UnsupportedEncodingException
{
String temp=s;
temp=new String(s.getBytes("GBK"),"ISO8859_1");
return temp;
}
%>
<%
String str1;
str1="数据库操作成功,恭喜你!";
out.println(GBK2UNI(str1));
%>
<font color='red' size='5'>连接sql数据库!</font>
</body>
</html>
刚测试完!