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 no. CM = ");
- String no_cm = input.nextLine();
- System.out.print("Masukkan nama = ");
- String nama = input.nextLine();
- System.out.print("Masukkan Tanggal Lahir(yyyy-mm-dd) = ");
- String tgllahir = input.nextLine();
- System.out.print("Masukkan umur = ");
- String umur = input.nextLine();
- // System.out.print("Masukkan satuan = ");
- // String sat = input.nextLine();
- // System.out.print("Masukkan kk = ");
- // String kk = input.nextLine();
- System.out.print("Masukkan alamat = ");
- String alamat = 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();
- 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+"')");
- 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