package com.test.dbc.server;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import com.google.gwt.user.server.rpc.RemoteServiceServlet;
import com.test.dbc.client.DataBaseConn;

@SuppressWarnings("serial")
public class DataBaseConnImpl extends RemoteServiceServlet implements
		DataBaseConn {

	@Override
	public ArrayList<String> getnames() {
		
		ArrayList<String> res = new ArrayList<String>();
		DAO dao;
		try {
			dao = DAO.getConnection();			
			Connection co = dao.getCon();
			Statement st = co.createStatement();
			ResultSet rs = st.executeQuery("select Nume from Tabel1 order by Nume");
			while (rs.next()) {
				// System.out.println(rs.getString(1));
				res.add(rs.getString(1));
			}
		} catch (ClassNotFoundException e) {
			e.getMessage();
		} catch (SQLException e) {
			e.getMessage();
		}
		
		return res;
	}

}