高分求解?高手请进! 不需要,看你的bean中访问ini文件的路径而定,如果只有文件名的话,ini放在web application根目录。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 不需要打包,只要放在你的bean 能访问的目录下就行--比如你的bean文件所在的目录(当然如果你使用的时候对它的引用路径有改动别论) to chenyuan_tongji:你能具体帮我看一下吗?这是我的bean的源文件:package login;import java.io.*;import java.sql.*;import java.util.*;public class sql_data{ Connection conn; Statement stmt; ResultSet rs; String sConnStr; String user; String password; String sDBDriver; public sql_data() { sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver"; try{ InputStream ins = new FileInputStream("login.DBConfig.ini"); Properties pr = new Properties(); pr.load(ins); String dbname = pr.getProperty("DataBaseName","").trim(); String ip = pr.getProperty("IPAddress","localhost").trim(); user = pr.getProperty("username","").trim(); password = pr.getProperty("password","").trim(); if(!"".equals(dbname)){ sConnStr = "jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName="+dbname; } //return true; }catch(IOException ioe){ //return false; } //sConnStr = "jdbc:microsoft:sqlserver://intel-5:1433;DatabaseName=arginfo"; conn = null; stmt = null; rs = null; //user = "sa"; //password = "123"; try { Class.forName(sDBDriver); } catch(ClassNotFoundException classnotfoundexception) { System.err.println("sql_data()" + classnotfoundexception.getMessage()); } } public ResultSet executeCmd(String s) { try { conn = DriverManager.getConnection(sConnStr, user, password); stmt = conn.createStatement(); rs = stmt.executeQuery(s); } catch(SQLException sqlexception) { System.err.println("sql_data.executeCmd:" + sqlexception.getMessage()); } return rs; } public void closeStmt() { try { stmt.close(); } catch(SQLException sqlexception) { sqlexception.printStackTrace(); } } public void closeConn() { try { conn.close(); } catch(SQLException sqlexception) { sqlexception.printStackTrace(); } } public static void main(String[] args) { try { sql_data dsf = new sql_data(); ResultSet rst = dsf.executeCmd("select * from info1"); while(rst.next()) { System.out.println(rst.getString("content")); } } catch(SQLException sqlexception) { sqlexception.printStackTrace(); } }}这是在jsp文件对它的调用<%@ page language="java" import="java.sql.*"%> <jsp:useBean id="addBean" scope="page" class="login.sql_data"/> tomcat的目录结构为:jsp源文件:C:\tomcat\webapps\ROOT\810\class文件:C:\tomcat\webapps\ROOT\WEB-INF\classes\login\我的数据库配置文件即DBConfig.ini应该放在那个目录下呢?谢谢你! 放在C:\tomcat\webapps\ROOT\WEB-INF\classes\login\目录下 struts2 s:textfield 传值问题 求Upload文件上传如何控制文件选择路径?解决方法越EASY越GOOD jquery 问题 急求 glassfish怎么发布几个项目共用的JAR 如何把一个Serializable的对象,存到Mysql数据库的Blob里? 你们的建议将可能影响我的未来 各位英雄~!救救~~! ibatis大于号>查询有时能查询出数据,有时不能,这是怎么回事呢 失去焦点时,触发一个事件 如何让浏览器跳转到下一页后就自动执行自己写的一段js代码 jsp、jbuilder显示问题,有分!!! Help!!!!
你能具体帮我看一下吗?
这是我的bean的源文件:
package login;import java.io.*;
import java.sql.*;
import java.util.*;public class sql_data
{
Connection conn;
Statement stmt;
ResultSet rs;
String sConnStr;
String user;
String password;
String sDBDriver;
public sql_data()
{
sDBDriver = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
try{
InputStream ins = new FileInputStream("login.DBConfig.ini");
Properties pr = new Properties();
pr.load(ins);
String dbname = pr.getProperty("DataBaseName","").trim();
String ip = pr.getProperty("IPAddress","localhost").trim();
user = pr.getProperty("username","").trim();
password = pr.getProperty("password","").trim();
if(!"".equals(dbname)){
sConnStr = "jdbc:microsoft:sqlserver://"+ip+":1433;DatabaseName="+dbname;
}
//return true;
}catch(IOException ioe){
//return false;
}
//sConnStr = "jdbc:microsoft:sqlserver://intel-5:1433;DatabaseName=arginfo";
conn = null;
stmt = null;
rs = null;
//user = "sa";
//password = "123";
try
{
Class.forName(sDBDriver);
}
catch(ClassNotFoundException classnotfoundexception)
{
System.err.println("sql_data()" + classnotfoundexception.getMessage());
}
} public ResultSet executeCmd(String s)
{
try
{
conn = DriverManager.getConnection(sConnStr, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery(s);
}
catch(SQLException sqlexception)
{
System.err.println("sql_data.executeCmd:" + sqlexception.getMessage());
}
return rs;
} public void closeStmt()
{
try
{
stmt.close();
}
catch(SQLException sqlexception)
{
sqlexception.printStackTrace();
}
} public void closeConn()
{
try
{
conn.close();
}
catch(SQLException sqlexception)
{
sqlexception.printStackTrace();
}
}
public static void main(String[] args) {
try
{
sql_data dsf = new sql_data();
ResultSet rst = dsf.executeCmd("select * from info1");
while(rst.next())
{
System.out.println(rst.getString("content"));
}
}
catch(SQLException sqlexception)
{
sqlexception.printStackTrace();
}
}}这是在jsp文件对它的调用
<%@ page language="java" import="java.sql.*"%>
<jsp:useBean id="addBean" scope="page" class="login.sql_data"/> tomcat的目录结构为:
jsp源文件:C:\tomcat\webapps\ROOT\810\
class文件:C:\tomcat\webapps\ROOT\WEB-INF\classes\login\
我的数据库配置文件即DBConfig.ini应该放在那个目录下呢?
谢谢你!