Shulou(Shulou.com)06/01 Report--

Package org.nlpcn.es4sql

Import com.alibaba.druid.pool.DruidDataSource

Import com.alibaba.druid.pool.ElasticSearchDruidDataSourceFactory

Import org.junit.Assert

Import org.junit.Test

Import java.math.BigDecimal

Import java.sql.*

Import java.util.ArrayList

Import java.util.Calendar

Import java.util.List

Import java.util.Properties

/ * *

* Created by allwefantasy on 8-26-16.

, /

Public class JDBCTests {

@ Test

Public void testJDBC () throws Exception {

Properties properties = new Properties ()

Properties.put ("url", "jdbc:elasticsearch://192.168.1.101:9300/" + TestsConstants.TEST_INDEX)

DruidDataSource dds = (DruidDataSource) ElasticSearchDruidDataSourceFactory.createDataSource (properties)

Connection connection = dds.getConnection ()

PreparedStatement ps = connection.prepareStatement ("SELECT * from" + TestsConstants.TEST_INDEX + "where id='46091023'")

Calendar Htime= Calendar.getInstance ()

Double nowtime = Htime.getTime () .getTime ()

ResultSet resultSet = ps.executeQuery ()

Calendar Ltime= Calendar.getInstance ()

Double endtime = Ltime.getTime () .getTime ()

BigDecimal longtime = new BigDecimal ((endtime-nowtime) / 1000)

Double second = longtime.setScale (3Magnum BigDecimal.ROUNDseaHALFUP). DoubleValue ()

List result = new ArrayList ()

While (resultSet.next ()) {

Result.add (resultSet.getInt ("id") + "," + resultSet.getString ("age") + "," + resultSet.getString ("name"))

}

System.out.println ("query results:" + result)

System.out.println ("time:" + second+ "seconds")

Ps.close ()

Connection.close ()

Dds.close ()

}

}

Package org.nlpcn.es4sql

Public class index {

Public static void main (String [] args) {

/ / TODO Auto-generated method stub

Gotop ()

}

Public static void gotop () {

JDBCTests server = new JDBCTests ()

Try {

Server.testJDBC ()

} catch (Exception e) {

/ / TODO Auto-generated catch block

E.printStackTrace ()

}

}

}

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.