Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.SQLException;
- import java.sql.DriverManager;
- import java.sql.Connection;
- import java.sql.PreparedStatement;
- import java.sql.ResultSet;
- import java.util.Formatter;
- import java.util.Locale;
- public class JdbcTest {
- public static void main(String[] args) throws SQLException {
- System.setProperty("java.security.egd", "file:///dev/urandom");
- DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
- String url = "//192.168.1.17:1521/wailua";
- String username = "sh";
- String password = "sh123";
- System.out.println("connecting.");
- Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@" + url, username, password);
- System.out.println("Total sales by country");
- String sql = " select c.country_name, sum (amount_sold) as dollar_sales"
- + " from sales s"
- + " join customers cus"
- + " on s.cust_id = cus.cust_id"
- + " join countries c"
- + " on cus.country_id = c.country_id"
- + " group by c.country_name"
- + " order by dollar_sales desc";
- PreparedStatement pstmt = conn.prepareStatement( sql );
- pstmt.execute();
- StringBuilder sb = new StringBuilder();
- Formatter formatter = new Formatter(sb, Locale.US);
- ResultSet rs = pstmt.getResultSet();
- while ( rs.next() )
- {
- sb.setLength( 0 );
- System.out.println( formatter.format("%-30s %15.2f",
- rs.getString( 1 ), rs.getFloat( 2 )) );
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement