databaseconnect.java

来自「简易的BBS,可以进行排行榜的查询,发布意见,建立一个新的主题」· Java 代码 · 共 53 行

package com.bbs.connect;

import org.springframework.web.context.WebApplicationContext;
import org.springframework.context.ApplicationContext;
import org.springframework.context.support.FileSystemXmlApplicationContext;
import java.sql.*;
import javax.sql.DataSource;

/*
   连接数据库操作
 */
public class DatabaseConnect {
  org.apache.commons.logging.Log log = org.apache.commons.logging.LogFactory.getLog(this.getClass());
  public DataSource DatabaseConnect() {
    DataSource ds1;
    String url = "jdbc:sybase:Tds:221.236.6.117:5555/scdx";
    String user = "srd_test_dengxh";
    String password = "12345678";
    Connection con = null;
    //Context ctx = null;
    /*
           try {
           Class.forName("com.sybase.jdbc2.jdbc.SybDriver");
           //ctx = new InitialContext();

           ctx = new InitialContext().createSubcontext("java:comp/env");
           DataSource ds = (DataSource) ctx.lookup("jdbc/dbname");
           ds1 = (javax.sql.DataSource) ctx.lookupLink("");
           con = ds1.getConnection("srd_test_dengxh", "12345678");
           System.out.println("success*****************");
           con = DriverManager.getConnection(url, user, password);
           Statement stmt = con.createStatement();
           System.out.println("world!!!!!!!!!!!!!!!!!");
         }
         catch (Exception ex2) {
         }*/
    String path="";
    path=this.getClass().getResource("/").getPath().substring(1);
    log.info("配置文件根目录路径："+path);
    ApplicationContext ctx = new FileSystemXmlApplicationContext(
        path+"applicationContext.xml");
    DataSource ds = (DataSource) ctx.getBean("dataSource");
    return ds;
  }

  protected WebApplicationContext getAppContext() {
    //WebApplicationContext context = DelegatingActionUtils
    //.findRequiredWebApplicationContext((ActionServlet) this.getAppContext(), null);
    return null;
  }

}