eclipse+tomcat+lomboz开发jsp连接mssql数据库
hjzr 2006-09-21 09:00:14 我写了个jsp用来连接mssql2000数据库,手动启动tomcat,在浏览器下测试成功,但在eclipse下却运行失败。我eclipse3.1装了lomboz-eclipse-emf-gef-jem-3.1RC2和tomcat5.5插件。
实在是纳闷,恳请高手赐教!
我的jsp文件如下:
=====================
<%@ page language="java" contentType="text/html; charset=ISO-8859-1"
pageEncoding="ISO-8859-1"%>
<%@ page import="java.sql.*"%>
<%!
public static String getGBString(String src) {
try {
return new String(src.getBytes("ISO-8859-1"), "gb2312");
} catch (java.io.UnsupportedEncodingException e) {
return null;
}
}
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<%Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver").newInstance();
String url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=CMS";
String user="sa";
String password="";
Connection conn= DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from 学生";
ResultSet rs=stmt.executeQuery(sql);
%>
<%while(rs.next()) {%>
<ul>
<li><%=getGBString(rs.getString(1))%> <br>
<li><%=getGBString(rs.getString(2))%> <br>
<li><%=getGBString(rs.getString(3))%> <br>
<li><%=getGBString(rs.getString(4))%> <br>
<li><%=getGBString(rs.getString(5))%> <br>
<li><%=getGBString(rs.getString(6))%> <br>
<li><%=getGBString(rs.getString(7))%> <br>
<li><%=getGBString(rs.getString(8))%> <br>
<li><%=getGBString(rs.getString(9))%> <br>
</ul>
<%}%>
<%out.print("OK");%> <br>
<%
rs.close();
stmt.close();
conn.close();
%>
</body>
</html>