在自学java，用的是myeclipse6.5 服务器是jboss
按照教材写的的代码。
DB.properties 文件时是放在src目录下.从myeclipse里打开这个文件说com.microsoft.....这些拼写错误。下面画了红线。但我没在意。我觉得这个没什么问题。
- Java code
className = com.microsoft.sqlserver.jdbc.SQLServerDriverurl = jdbc:sqlserver://127.0.0.1:1433;DatabaseName=STUDENTSname= sapassword=3401
DBProperty.java 文件读取上面的配置文件。 放在src/beans
- Java code
package beans;import java.io.InputStream;import java.util.Properties;public class DBProperty { private String className; private String url; private String name; private String password; public String getClassName() { return className; } public void setClassName(String className) { this.className = className; } public String getUrl() { return url; } public void setUrl(String url) { this.url = url; } public String getName() { return name; } public void setName(String name) { this.name = name; } public String getPassword() { return password; } public void setPassword(String password) { this.password = password; } public String getProperty(String pro){ InputStream in; Properties p = new Properties(); try{ in = Class.forName("beans.DBProperty").getResourceAsStream("/DB.properties"); p.load(in); }catch(Exception ex){ ex.printStackTrace(); } return p.getProperty(pro); }}index.jsp进行测试。
- Java code
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@ page import ="java.sql.*" %><%@ page import="javax.sql.*" %><%@ page import="javax.naming.*" %><%@ page import="beans.DBConst"%><%@ page import="beans.DBProperty"%><%String path = request.getContextPath();String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html> <head> <base href="<%=basePath%>"> <title>My JSP 'index.jsp' starting page</title> <meta http-equiv="pragma" content="no-cache"> <meta http-equiv="cache-control" content="no-cache"> <meta http-equiv="expires" content="0"> <meta http-equiv="keywords" content="keyword1,keyword2,keyword3"> <meta http-equiv="description" content="This is my page"> <!-- <link rel="stylesheet" type="text/css" href="styles.css"> --> </head> <body>“ This is my JSP page. <br> <% DBProperty pro = new DBProperty(); Connection conn= null; Class.forName(pro.getClassName()).newInstance(); String url=pro.getUrl(); String user=pro.getName(); String password=pro.getPassword(); conn = DriverManager.getConnection(url,user,password); out.print("get a connection of databases!\n"); out.print(conn.toString()); %> </body></html>项目导入了sqljdbc.jar在WEB-INF/lib 内
运行后，结果错误。是不是属性文件没有读入啊？
页面报错如下：
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.