Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Connection showUser() throws Exception {
- try {
- Connection conn = (Connection) getConnection() ;
- String query = "SELECT * FROM user" ;
- java.sql.Statement stmt = conn.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- System.out.println("idUser "+ " | " + "Name "+ " | " + "Surname "+ " | " + "Password "+ " | " + "Sex " + " | "+ "Mail "+ " | " + "Address "+ " | " + "phone_number");
- while (rs.next()){
- System.out.println(rs.getString("idUser") + " | " + rs.getString("Name") + " | " + rs.getString("Surname")+ " | " + rs.getString("Password")+ " | " + rs.getString("Sex")+ " | " + rs.getString("Mail")+ " | " + rs.getString("Address")+ " | " + rs.getString("Phone_Number"));
- }
- }catch (Exception e){
- System.out.println(e);
- }
- finally{
- System.out.println("\nsuccess\n");
- };
- return null ;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement