test.java

用java写的一个使用jdbc访问oracle数据库的接口类

package com.nantian.tjdbc;

import java.sql.*;

public class test {

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String driver = "oracle.jdbc.OracleDriver";
		String url = "jdbc:oracle:thin:@10.1.32.7:1521:ora9";
		String user = "plc";
		String pwd = "plc";
		Tjdbc tjdbc = new Tjdbc(driver, url, user, pwd);

		//add your code here to database
		//String testStr = "select name from test where name='张三'";
		String testStr = "select * from TEST ";
		ResultSet rs = tjdbc.query(testStr);

		try {
			while(rs.next()){
				System.out.println(rs.getLong(1));
				System.out.println(rs.getString(2));
				System.out.println(rs.getString(3));
				System.out.println(rs.getString(4));
			}
		} catch (SQLException e) {
			System.out.println("no object in ResultSet!");
			e.printStackTrace();
		}
		//add ended

		tjdbc.closeConnection();
	}

}