java连接oracle数据库
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
String url="jdbc:oracle:thin:@192.239.99.109:1521:orcl";
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
conn = DriverManager.getConnection(url, "g4studio", "g4studio");
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,
ResultSet.CONCUR_UPDATABLE);
rs = stmt.executeQuery("SELECT * FROM GEO_ENTITY_RECOG where STMC like '%"+searchName+"%'");
ResultSetMetaData m=rs.getMetaData();
int columns=m.getColumnCount();
rs.beforeFirst();//将结果集指针指回到开始位置
while(rs.next())
{
for(int i=1;i<=columns;i++)
{