Get Data from Database without definited Structure

package tianye.test.rest.controller;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.util.ArrayList;

import tianye.test.rest.model.ContactInfoHana;

public class DBHana {
	
	Connection conn;
	
	public DBHana()
	{
		try {
			
			Class.forName("com.sap.db.jdbc.Driver").newInstance();
			conn = DriverManager.getConnection("jdbc:sap://localhost:30015/SYSTEM?user=&password=");			
			
		} catch (Exception ex) {
			// TODO Auto-generated catch block
			System.out.println("error");
		}						
	}
	
	public static void main(String args[])
	{
		DBHana dbh = new DBHana();
		
		try {
			ArrayList<String[][]> result = dbh.doSelect("select * from contactbook");
			
			for(String[][] r:result)
			{
				for(int i=0;i<r.length;i++)
				{
					System.out.println(r[i][0] + "," + r[i][1]);
				}
				System.out.println("======================");
			}
			
		} catch (Exception e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	
	public ArrayList<String[][]> doSelect(String selectStatement) throws Exception	
	{
		PreparedStatement ps = conn.prepareStatement(selectStatement.trim());
		ResultSet rs = ps.executeQuery();
		
		ResultSetMetaData rsmd = rs.getMetaData();
		
		int colcount = rsmd.getColumnCount();

		String[] args = new String[colcount];
		
		for(int i=0;i<colcount;i++)
		{
			args[i] = rsmd.getColumnLabel(i+1);
		}
		
		ArrayList<String[][]> returnList = new ArrayList<String[][]>();
		
		while(rs.next())
		{
			String[][] returnRow = new String[colcount][colcount];
			for(int i=0;i<args.length;i++)
			{							
				returnRow[i][0] = args[i];
				returnRow[i][1] = String.valueOf(rs.getObject(args[i]));
			}
			
			returnList.add(returnRow);
		}
		
		return returnList;
	}
	
	// _SELECT_ _FROM_ _WHERE_
	private int numberOfSubString(String statement, String s)
	{
		if(statement.contains(s))
		{
			int counter = 0;
			int lastIndex = 0;
			
			while(lastIndex != -1)
			{
				lastIndex = statement.indexOf(s);
				
				if (lastIndex != -1)
					counter ++;
			}
			
			return counter;
		}
		else
			return -1;
	}
}


评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值