JDBC 3: (inserting)





public class User{
    private Long id;
    private String name;
    private String contactDetail;
    private String username;
    private String password;
    
    public User(){}
    
    public User(String name,String contactDetail,String username,String password){
        this.name = name;
        this.contactDetail = contactDetail;
        this.username = username;
        this.password = password;
    }
    
    public User(Long id,String name,String contactDetail,String username,String password){
        this.id =id;
        this.name = name;
        this.contactDetail = contactDetail;
        this.username = username;
        this.password = password;
    }
    
    public Long getId(){
        return id;
    }
    public void setId(Long id){
        this.id =  id;
    }
    public String getName(){
        return name;
    }
    public void setname(){
        this.name = name;
    }
    public String getContactDetail(){
        return contactDetail;
    }
    public void setContactDetail(String contactDetail){
        this.contactDetail = contactDetail;
    }
    public String getUsername(){
        return username;
    }
    public void setUsername(String username){
        this.username = username;
    }
    public String getPassword(){
        return password;
    }
    public void setPassword(String password){
        this.password = password;
    }

}
___________________________________________________________________________

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.ResourceBundle;
public class DBConnection {
public static Connection getConnection() throws SQLException {        
        ResourceBundle rb = ResourceBundle.getBundle("oracle");
        String url = rb.getString("db.url");
        String username = rb.getString("db.username");
        String password = rb.getString("db.password");
        Connection conn = DriverManager.getConnection(url,username,password);
        return conn;
    }
}
______________________________________________________________________________
 import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class UserDAO {
    public List<User> getAllUser() throws SQLException {
        List<User> userList = new ArrayList<User>();
        Connection conn = DBConnection.getConnection();
    Statement stmt = conn.createStatement();
String query = "select * from \"user\"";
ResultSet rs = stmt.executeQuery(query);
while(rs.next()) {
Long id = rs.getLong(1);
String name = rs.getString(2);
String contact = rs.getString(3);
            String username = rs.getString(4);
            String password = rs.getString(5);
User user = new User(id,name,contact,username,password);
userList.add(user);
user=null;
}
        return userList;
    }
    
    public void insertDetails(User user)throws SQLException {
        Connection conn=DBConnection.getConnection();
    String query = "insert into \"user\" (name,contact_detail,username,password) values (?,?,?,?)";
PreparedStatement pr = conn.prepareStatement(query);
//pr.setLong(1, user.getId());
pr.setString(1,user.getName() );
pr.setString(2, user.getContactDetail());
        pr.setString(3, user.getUsername());
        pr.setString(4, user.getPassword());
pr.executeUpdate();
pr.close();
    }
}
______________________________________________________________________________
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import java.util.Scanner;

public class Main {

public static void main(String[] args) throws SQLException {
Scanner sc = new Scanner(System.in);
    System.out.println("Enter the user detail in CSV format");
String arr[]=sc.nextLine().split(",");
String name=arr[0];
String contact=arr[1];
String username=arr[2];
        String password=arr[3];
User user = new User(name,contact,username,password);
        UserDAO dao = new UserDAO();
dao.insertDetails(user);

    List<User> userList = new ArrayList<User>();

userList = dao.getAllUser();
        
        System.out.format("%-5s %-10s %-15s %-10s %s\n","Id","Name","Contact Detail","Username","Password");
for (User u: userList) {
System.out.format("%-5s %-10s %-15s %-10s %s\n",u.getId(),u.getName(),u.getContactDetail(),u.getUsername(),u.getPassword());
                    
}
}

}





Comments

Post a Comment

Popular posts from this blog

  Primitive Wrappers | java.lang | java.util CUSTOMER ADDRESS USING STRING BUILDER Sample Input & Output: Enter Address Details : Enter Line 1 : 152, South Block Enter Line 2 : Raisina Hill Enter City : New Delhi Enter Country : India Enter Zip Code : 110011 Address Details : 152, South Block, Raisina Hill, New Delhi - 110011 India CODE: // fill your code here public class Address {      private String line1; private String line2; private String city; private String country; private int zipCode; public String getLine1() { return line1; } public void setLine1(String line1) { this.line1 = line1; } public String getLine2() { return line2; } public void setLine2(String line2) { this.line2 = line2; } public String getCity() { return city; } public void setCity(String city) { this.city = city; } public String getCountry() { return country; } public void setCountry(String country) { this.country = country...
Read more
Collections: ARRAYLIST - INTRODUCTION Sample Input and Output 1: Enter the username 1 John Do you want to continue?(y/n) y Enter the username 2 Joe Do you want to continue?(y/n) n The Names entered are: John Joe CODE: import java.util.ArrayList; import java.util.Scanner; public class Main {     public static void main(String args[]) { String user; Scanner sc = new Scanner(System.in); ArrayList<String> al = new ArrayList<String>(); int i = 1; do { System.out.println("Enter the username "+i); al.add(sc.nextLine()); System.out.println("Do you want to continue?(y/n)"); user = sc.nextLine(); i++; }while(user.equalsIgnoreCase("y")); System.out.println("The Names entered are:"); for(String a:al) { System.out.println(a); } } }
Read more
Collections: TREEMAP To assist Event organizers, you need to develop a console application that shows the number of tickets sold in a particular price category. Sample Input and Output : [All Texts in bold corresponds to the input and rest are output] Enter the number of events: 3 Enter event details in CSV(Customer Name,Ticket Price,No of Seats Booked) Emily ,100,5 Natalie ,200,10 Grace ,100,3 Ticket Price    Tickets Booked 100                 8 200                 10 CODE: //package com.mycom.collections.map; import java.util.Scanner; import java.util.Set; import java.util.TreeMap; public class Main {     public static void main(String[] args) { Scanner sc = new Scanner(System.in); System.out.println("Enter the number of events:"); int num = Integer.parseInt(sc.nextLine()); TreeMap<I...
Read more