![]() |
#2
bigpeach2010-02-11 22:11
数据库的连接文件 DBOper.java (说明一下:这个文件原来是连的Oracle数据库,但我电脑配置太低,怕跑不起来,换成SQL Server 2000了,相应的语句也改了,不知有没有错误?):
package comm; import java.sql.*; import *; import java.util.*; import oracle.jdbc.*; // 引用JDBC驱动包 import Information.*; public class DBOper { private Connection conn = null; private Statement stmt = null; // 数据库连接 public void connectDB() throws Exception { String hostName = "localhost"; // 主机名或者IP地址 String portNumber = "1433";//"1521"; // 端口号,默认为1521 String databaseSID = "oracledb"; // SID名称 // String userName = "devsys"; // 用户名 // String password = "devsys"; // 用户密码 String userName = "sa"; // 用户名 String password = "newsmanager"; // 用户密码 String url = "jdbc:microsoft:sqlserver://"+hostName+":"+portNumber+":"+databaseSID; //String url = "jdbc:oracle:thin:@"+hostName+":"+portNumber+":"+databaseSID; // 连接字符串 System.out.println(url); // 打印连接字符串 try{ // 装载驱动程序 Class.forName("com.microsoft.JDBC.sqlserver.SQLServerDriver"); //Class.forName("oracle.jdbc.driver.OracleDriver"); // 建立连接 conn = DriverManager.getConnection(url,userName,password); } catch (Exception e){ // 如果有异常,则抛出错误 System.out.println("=====Exception : DBOper connectDB() exception: " + e.getMessage()); } } // 获取数据库连接对象 public Connection getConnection() throws Exception { return conn; } // 执行查询,返回单一结果 public ResultSet getResultSet(String sql) throws SQLException { try{ // 如果数据库没有连接,则连接数据库 if(conn==null) connectDB(); } catch (Exception e){ throw new SQLException(e.getMessage()); } // 如果语句为空,则创建语句 if(stmt ==null) stmt =conn.createStatement(); // 执行查询,返回查询结果集 return stmt.executeQuery(sql); } // 添加、删除、更新操作 public void DataUpdate(String sql) throws SQLException { try { // 连接数据库 if(conn==null) connectDB(); // 创建语句 if(stmt ==null) stmt =conn.createStatement(); // 执行更新操作 stmt.executeUpdate(sql); } catch (Exception e) { throw new SQLException(e.getMessage()); } } // 关闭 public void close() throws SQLException { // 设置自动提交 conn.setAutoCommit(true); // 关闭语句,关闭连接 if(stmt!=null) {stmt.close();stmt =null;} if(conn!=null) {conn.close();conn =null;} } } |
首先是我的环境变量:
classpath :.;D:\Java\jdk1.6.0_18\lib\tools.jar;D:\Java\jdk1.6.0_18\lib\dt.jar
JAVA_HOME : D:\Java\jdk1.6.0_18
Path : D:\Java\jdk1.6.0_18\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\Thunder Network\KanKan\Codecs;C:\Program Files\Microsoft SQL Server\80\Tools\BINN
我的Tomcat 路径是:C:\Program Files\Apache Software Foundation\Tomcat 5.5
我把整个代码包括Jsp和Java所有的文件都放在文件夹 Code 里;
Code的路径是 : C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\myapp\Code
Code里除了有些JSP和html文件外还有三个文件夹:admin(里面放着JSP文件)、WEB-INF(此文件夹中有一个classes文件夹 ,classes文件夹中包括comm和 Information文件夹,这两个文件夹中放着java文件)和images(里面是图片)。
我在浏览器地址栏中输入:http://localhost:9090/myapp/Code/index.jsp
出现错误:
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 42 in the jsp file: /Code/admin/InfoComm.jsp
User cannot be resolved to a type
39: public String getName(String Userid)throws Exception
40: {
41: try{
42: User o_user = new User();
43: o_user.setUserId(Userid);
44: if(o_user.getUser())
45: {
An error occurred at line: 30 in the jsp file: /Code/left.jsp
Categories cannot be resolved to a type
27: //如果是管理员,则可以设置用户信息,如果是其他用户则可以更改自己的密码
28: // 定义用户对象
29: Vector v_Cate = new Vector();
30: Categories o_Cate = new Categories();
31: v_Cate = o_Cate.getMoreCategories();
32: for(int i=0;i <v_Cate.size();i++)
33: {
An error occurred at line: 34 in the jsp file: /Code/left.jsp
Categories cannot be resolved to a type
31: v_Cate = o_Cate.getMoreCategories();
32: for(int i=0;i <v_Cate.size();i++)
33: {
34: o_Cate = (Categories)v_Cate.elementAt(i);
35: %>
36: <tr> <td align="center"> <a href="infoList.jsp?cid= <%=o_Cate.getCateId()%>" target="main" style="text-decoration: none"> <%=o_Cate.getCateTitle()%> </a> </td> </tr>
37: <% }%>
Stacktrace:
org.apache.(DefaultErrorHandler.java:93)
org.apache.(ErrorDispatcher.java:330)
org.apache.(JDTCompiler.java:451)
org.apache.(Compiler.java:319)
org.apache.(Compiler.java:298)
org.apache.(Compiler.java:286)
org.apache.jasper.(JspCompilationContext.java:564)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:302)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.28 logs.
--------------------------------------------------------------------------------
Apache Tomcat/5.5.28
下面我将把其中几个文件贴上来,大家帮忙分析一下到底是哪里的问题或错误,谢谢!
[ 本帖最后由 bigpeach 于 2010-2-11 22:28 编辑 ]