Code example for Connection

Methods: createStatement

0
		 " PANEL_COUNT int, " +  
		 " fact_count int, " +  
		 " fact_panels int " +  
		 " )";  
		 Connection conn = dataSource.getConnection();
		 Statement stmt = conn.createStatement();
		stmt.executeUpdate(createSql);
		createSql = " CREATE  TABLE #DX  ( " + 
				 " ENCOUNTER_NUM int, " +  
				 " PATIENT_NUM int " +  
				 " ) " ; 
		stmt.executeUpdate(createSql);
		 
		stmt.executeUpdate("insert into #query_global_temp(encounter_num) values(1)");
		stmt.close();
		conn.close();
	} 
	 
} 
Contextual code suggestions in your IDE  Get Codota for Java