jsp中连接不上SQL Server。
运行后在java的dos框里看不到出错信息(它是显示了,但是我无法移动左右键去看。)
我的数据源名为my_test,程序如下:
<%@ page language="java"%>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<%
Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
String url="jdbc:odbc:my_test";
Connection con=DriverManager.getConnection(url,"sa","");
Statement statement=con.createStatement();
String query="select * from classmate";
ResultSet result=statement.executeQuery(query);
%>
<html>
<head>
<title>ClassMate</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF">
<form name="form1" method="post" action="">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>classmate name</td>
<td>Gender</td>
<td>Telephone</td>
<td>Address</td>
</tr>
<%
while(result.next())
{%>
<tr>
<td><%=result.getString("clmname")%></td>
<td><%=result.getString("clmgender")%></td>
<td><%=result.getString("clmtel")%></td>
<td><%=result.getString("clmaddress")%></td>
</tr>
<%
}
%>
</table>
</form>
</body>
</html>
<%
con.close();
statement.close();
result.close();
%>