WE PROVIDE ALL

How to Retrive the Database table and Sorting table using Java




package com.nt.sense;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Collections;

public class Restore {

static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
static final String DB_URL = "jdbc:mysql://localhost:3307/organization";

// Database credentials
static final String USER = "root";
static final String PASS = "root";

public static void main(String[] args) throws SQLException,
ClassNotFoundException {
Connection conn = null;
Statement stmt = null;
@SuppressWarnings("unused")
BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

// STEP 2: Register JDBC driver
Class.forName("com.mysql.jdbc.Driver");

// STEP 3: Open a connection
System.out.println("Connecting to database");
conn = DriverManager.getConnection(DB_URL, USER, PASS);

// STEP 4: Execute a query
System.out.println("Creating statement...");
stmt = conn.createStatement();
String sql;
sql = "SELECT ename,epassword,phonenumber,email FROM employee";
ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
String sname = rs.getString("ename");
String password = rs.getString("epassword");
BigDecimal phonenumbers = rs.getBigDecimal("phonenumber");
String eemail = rs.getString("email");
System.out.print(sname);
System.out.print("\t");
System.out.print(password);
System.out.print("\t");
System.out.print(phonenumbers);
System.out.print("\t");
System.out.print(eemail);
System.out.println();
}
System.out.println("this is the display of ename only");
String sql2;
sql2 = "SELECT epassword from employee";
ResultSet rs1 = stmt.executeQuery(sql2);
System.out.println("start.....");
ArrayList<String> al = new ArrayList<String>();
while (rs1.next()) {
{
al.add(rs1.getString("epassword"));
}

}

for (String s : al) {
System.out.println(s);
}

Collections.sort(al);
System.out.println("After sorting");
for (String s1 : al) {
System.out.println(s1);
}
}

}

0 comments:

Post a Comment