Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String urlValue="";
- Scanner input = new Scanner (System.in);
- System.out.print("Masukkan nama yang mirip = ");
- String nama = input.nextLine();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- urlValue="jdbc:mysql://localhost/pbo?user=root&password=";
- Connection conn=
- DriverManager.getConnection(urlValue);
- Statement st=conn.createStatement();
- ResultSet rs=st.executeQuery("Select count(id) from daftar_pasien WHERE daftar_pasien.nama like '%"+nama+"%'");
- while(rs.next()){
- int numberRow = rs.getInt("count(id)");
- System.out.println("jumlah data yang namanya menyerupai kata "+nama+" yaitu "+numberRow);
- }
- conn.close();
- }
- catch (SQLException e){
- System.out.println("koneksi gagal" + e.toString());
- }
- catch (ClassNotFoundException e){
- System.out.println("jdbc.Driver tidak ditemukan");
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement