/这是Dao包/
public class MobileDao {
/*根据品牌名称查询品牌是否存在，存在返回true，否则返回false
@param brand
@return */
public boolean findByBrand(String brand){
boolean b=true;
Connection con=null;
PreparedStatement sta=null;
ResultSet rs=null;
con= DBUtil3.getCon();
String sql="SELECT * FROM mobile WHERE brand=?";
try {
sta=con.prepareStatement(sql);
sta.setString(1,"brand");
rs=sta.executeQuery();
if (rs.next()){
b=true;
}
} catch (SQLException e) {
e.printStackTrace();
}finally {
DBUtil3.closes(rs,sta,con);
}
return b;
}
/*
新增品牌信息，如果成功返回true，否则返回false
@param
@return
*/
public boolean add(Mobile mobile){
boolean b=true;
String sql="insert into mobile values(?,?,?)";
DBUtil3.update(sql,mobile.getBrand(),mobile.getManufacturer(),mobile.getProduce());
return b;
}
}
/这是测试类/
public class MobileTest {
static Scanner sc = new Scanner(System.in);
static MobileDao mobileDao = new MobileDao();
public static void main(String[] args) {
all();
}
private static void all() {
System.out.println("**********手机品牌管理**********");
System.out.println("品牌名称:");
String brand = sc.nextLine();
while (brand.equals("")){
System.out.println("品牌名称必须输入:");
brand = sc.nextLine();
}
System.out.println("广商名称:");
String manufacturer=sc.nextLine();
while (manufacturer.equals("")){
System.out.println("厂商名称必须输入:");
manufacturer=sc.nextLine();
}
System.out.println("产地:");
String produce = sc.nextLine();
while (produce.equals("")){
System.out.println("产地必须输入");
produce=sc.nextLine();
}
boolean b=mobileDao.findByBrand(brand);
if (!b){
Mobile mobile=new Mobile(brand,manufacturer,produce);
mobileDao.add(mobile);
System.out.println("添加成功");
}else{
System.out.println("该手机品牌已存在,不能添加");
}
}
}
