package telbook;

import java.sql.*;
import java.sql.PreparedStatement;

public class ShiTi {
    private int uid;
    private String uname;
    private String utel;
    public ShiTi() {
    }

    public void setUid(int uid) {
        this.uid = uid;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public void setUtel(String utel) {
        this.utel = utel;
    }

    public int getUid() {
        return uid;
    }

    public String getUname() {
        return uname;
    }

    public String getUtel() {
        return utel;
    }
    /*刪除電話號碼*/
 public static boolean deletetel(int a){
     boolean ok=false;
     try {
         Class.forName("sun.jdbc.odbc.jdbcOdbcDriver");
         Connetion conn=DriverManager.getConnection("jdbc:ocbc:accp");
//            Statement sta=conn.createStatement();
         PreparedStatement pre=conn.prepareStatement("delete from TelBook where uid=?");
         pre.setInt(1,a);
         //
         int c=pre.executeUpdate();
         if (c>0) {
             ok=true;
         }
     } catch (Exception dx) {
         System.out.println(""+dx);
     }
     return ok;
 }


}