Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- String urlValue="";
- 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 pasien_rawat.*, daftar_pasien.*, poli.* from pasien_rawat, daftar_pasien,poli WHERE pasien_rawat.no_cm=daftar_pasien.no_cm AND pasien_rawat.poli=poli.kode");
- System.out.println("NO. \tNo.cm \tNama \tPoli ");
- int no = 0;
- while(rs.next()){
- no++;
- System.out.print(no+"\t");
- System.out.print(rs.getString("no_cm")+"\t");
- System.out.print(rs.getString("nama")+"\t");
- System.out.println(rs.getString("poli.poli")+"\t");
- }
- /* Statement st=conn.createStatement();
- boolean rs=st.execute("INSERT INTO daftar_pasien(no_cm, nama,tgllahir ,umur, sat, kk, alamat)"
- +"VALUES(no_cm, 'Tambahan','0000-00-00', 23, 'thn', 'hai', 'jeporo')");
- */
- 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