tester.java

这是一款应用程序与数据库联接

/* ===========================================================
 * JDBMonitor : a flexiable JDBC Monitor for the Java(tm) platform
 * ===========================================================
 *
 * (C) Copyright 2006-2006, by yang zhongke
 *
 * Project Info:  http://www.cownew.com
 *
 * This library is free software; you can redistribute it and/or modify it 
 * under the terms of the GNU Lesser General Public License as published by 
 * the Free Software Foundation; either version 2.1 of the License, or 
 * (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful, but 
 * WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY 
 * or FITNESS FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public 
 * License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, 
 * USA.  
 *
 * [Java is a trademark or registered trademark of Sun Microsystems, Inc. 
 * in the United States and other countries.]
 *
 * ---------------
 * Tester.java
 * ---------------
 * (C) Copyright 2006-2006, by yang zhongke
 *
 * Original Author:  yang zhongke;
 *
 * Changes
 * -------
 *
 */
package com.cownew.JDBMonitor.demo;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Tester
{
	public static void doIt() throws Exception
	{
		Class.forName("com.cownew.JDBMonitor.jdbc.DBDriver");
		// attention:here is /com/linco/DBListener/demo/config.xml
		// instead of com/linco/DBListener/demo/config.xml
		Connection conn = null;
		PreparedStatement ps = null;
		try
		{
			conn = DriverManager
					.getConnection("listenerconfig=/com/cownew/JDBMonitor/demo/config.xml:url=jdbc:odbc:MQIS");
			for (int i = 0; i < 1000; i++)
			{

				ps = conn
						.prepareStatement("select * from T_BD_Material");
				ps.executeQuery().close();
				ps.close();
				
				ps = conn.prepareStatement("update T_BD_Material set fid=fid");
				ps.execute();
				ps.close();
				
				Thread.sleep(1000L);
			}
		} finally
		{
			if(ps!=null)
			ps.close();
			if(conn!=null)
			conn.close();			
		}
		System.out.println("execute ok!");
	}

	public static void main(String[] args)
	{
		try
		{
			doIt();
		} catch (Exception e)
		{
			e.printStackTrace();
		}
	}

}