Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package aufgabe3;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- public class DBconnect {
- public static void main(String[] args){
- final String DBNAME = "test";
- final String URL = "jdbc:oracle:thin:@localhost:1521:oracle";
- final String USER = "KUBE";
- final String PASSWORD = "chris1711";
- final String DRIVER = "com.oracle.jdbc.Driver";
- try{
- Connection con = DriverManager.getConnection( URL, USER, PASSWORD );
- Statement stmt = con.createStatement();
- String SQL = "SELECT * FROM aoldata.querydata";
- ResultSet rs = stmt.executeQuery(SQL);
- int i = 0;
- while(rs.next()&&i<10){
- int id = rs.getInt("ID");
- String query = rs.getString("QUERY");
- String clickurl = rs.getString("CLICKURL");
- System.out.println(id +" | "+ query + "| " + clickurl);
- i++;
- }
- }catch(SQLException err){
- System.out.println(err.getMessage());
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement