Advertisement
akhisyabab

create data

Nov 9th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.59 KB | None | 0 0
  1. String urlValue="";
  2.        
  3.         Scanner input = new Scanner (System.in);
  4.         System.out.print("Masukkan no. CM = ");
  5.         String no_cm = input.nextLine();
  6.        
  7.         System.out.print("Masukkan nama = ");
  8.         String nama = input.nextLine();
  9.        
  10.         System.out.print("Masukkan Tanggal Lahir(yyyy-mm-dd) = ");
  11.         String tgllahir = input.nextLine();
  12.        
  13.         System.out.print("Masukkan umur = ");
  14.         String umur = input.nextLine();
  15.        
  16.     //    System.out.print("Masukkan satuan = ");
  17.     //    String sat = input.nextLine();
  18.        
  19.     //    System.out.print("Masukkan kk = ");
  20.     //    String kk = input.nextLine();
  21.      
  22.         System.out.print("Masukkan alamat = ");
  23.         String alamat = input.nextLine();
  24.        
  25.        
  26.         try {
  27.             Class.forName("com.mysql.jdbc.Driver");
  28.             urlValue="jdbc:mysql://localhost/pbo?user=root&password=";
  29.             Connection conn=
  30.                     DriverManager.getConnection(urlValue);
  31.            
  32.             Statement st=conn.createStatement();
  33.             boolean rs=st.execute("INSERT INTO daftar_pasien(no_cm, nama,tgllahir ,umur, sat, kk, alamat) VALUES('"+no_cm+"', '"+nama+"','"+tgllahir+"', '"+umur+"', 'thn', 'kk', '"+alamat+"')");
  34.              
  35.             conn.close();
  36.            
  37.         }
  38.            
  39.        
  40.         catch (SQLException e){
  41.             System.out.println("koneksi gagal" + e.toString());
  42.         }
  43.        
  44.         catch (ClassNotFoundException e){
  45.             System.out.println("jdbc.Driver tidak ditemukan");
  46.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement