/*
* Copyright 2008 biaoping.yin
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.frameworkset.common.poolman;
import java.sql.SQLException;
import javax.naming.NamingException;
/**
* @author biaoping.yin
* created on 2005-3-30
* version 1.0
*/
public class Test {
public static void main(String[] args) throws SQLException
{
try {
System.out.println( DBUtil.getDataSourceByJNDI("bspf_datasource_jndiname"));
} catch (NamingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
// //try {
// TestThread testThread[] = new TestThread[] {new TestThread(),new TestThread(),new TestThread()};
// testThread[0].start();
// testThread[1].start();
// testThread[2].start();
//
//
//// DBUtil dbutil = new DBUtil();
//// try {
//// for(int i = 0 ; i < 5; i ++)
//// {
//// dbutil.executeInsert("insert into oa_meetingpromptsound(soundCode,soundName,soundFileName) values('aaa','bb','dd')");
//// }
//
// //Class.forName("oracle.jdbc.driver.OracleDriver");
// //Connection con = DriverManager.getConnection("jdbc:oracle:thin:@202.197.40.150:1521:test","system","manager");
//// Connection con = DBUtil.getConection();//DriverManager.getConnection("jdbc:oracle:thin:@202.197.40.131:1521:ora8isol","oa","oa");
//// System.out.println("con1:"+con);
////
//// Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
//// //stmt.setFetchSize(maxsiz);
//// //stmt.setMaxRows(2);
//// ResultSet rs = stmt.executeQuery("select table_name,table_id_name,table_id_increment,table_id_value from tableinfo");
////
//// //rs.beforeFirst();
//// int i = 0;
//// // rs.absolute(12);
//// while(rs.next())
//// {
//// i ++;
//// System.out.println("hasNext:" + true);
//// }
//// System.out.println("i:" + i);
//// rs.absolute(-4);
//// while(rs.next())
//// {
//// i ++;
//// System.out.println("hasNext:" + true);
//// }
//// System.out.println("i:" + i);
//// rs.close();
////
//// stmt.close();
//// con.close();
////// System.out.println(- i);
//// //while(rs.)
//// //rs.absolute(2);
//// //System.out.println("id:" + rs.next());
//// //System.out.println("hasNext:" + rs.next());
//// }
////// catch (ClassNotFoundException e) {
//////
////// // e.printStackTrace();
////// }
//// catch (SQLException e) {
////
//// e.printStackTrace();
//// }
//// } catch (SQLException e) {
//// // TODO Auto-generated catch block
//// e.printStackTrace();
//// }
//
}
static class TestThread extends Thread
{
public void run()
{
DBUtil dbutil = new DBUtil();
try {
for(int i = 0 ; i < 5; i ++)
{
System.out.println(this + "||result:" + dbutil.executeInsert("insert into oa_meetingpromptsound(soundCode,soundName,soundFileName) values('aaa','(b,b)','dd')"));
}
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
}