Tugas Java V (Database MySQL 2)

PersonManager.java

package db.app;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.Statement;

import java.util.ArrayList;

import java.util.List;

/**

 *

 * @author p2ns3rnprettty

 */

public class PersonManager {

Connection con = null;

Statement st = null;

String url = "jdbc:mysql://localhost:3306/dbapp_11092094";

String user = "root";

String pass = "password";

public PersonManager(){

try{

Class.forName("com.mysql.jdbc.Driver").newInstance();

con = DriverManager.getConnection(url,user,pass);

st = con.createStatement();

    }catch(Exception ex){

        ex.printStackTrace();

    }

}

public List

getperson(){

 ResultSet rs = null;

 List

 persons = new ArrayList();

 try{

rs = st.executeQuery("SELECT id,nama,alamat,telp FROM tperson");

while(rs.next()){

person p = new person();

p.setid(rs.getInt(1));

p.setnama(rs.getString(2));

p.setalamat(rs.getString(3));

p.settelp(rs.getString(4));

persons.add(p);

     }

    }catch(Exception ex){

        ex.printStackTrace();

    }

 return persons;

    }

public int insert(person p){

int result = 0;

try{

result = st.executeUpdate("INSERT INTO tperson(id,nama,alamat,telp)"+

"VALUES("+p.getid()+","+p.getnama()+","+p.getalamat()+","+p.gettelp()+")");

}catch(Exception ex){

    ex.printStackTrace();

}

return result;

    }

public int delete(person p){

    int result = 0;

    try{

result = st.executeUpdate("DELETE FROM tperson WHERE ID="+p.getid()+"");

    }catch(Exception ex){

    ex.printStackTrace();

    }

 return result;

 }

}

Diposting oleh alex_tomasoa di 02.35