现在有两种数据库,一个是Mysql数据库,另一个是Oracle。请通过程序设计,设计一个可以根据用户输入来自动选择数据库,并执行增删改查操作。
需求:在main里,根据用户输入的编号,系统自动创建一个MysqlDao或者OracleDao,然后执行增删改查操作。
Homework7_IDAO:
public interface Homework7_IDAO {
void connect();
void add();
void del();
void upd();
void sel();
}
Homework7_AbstractDao:
public class Homework7_AbstractDao implements Homework7_IDAO {
@Override
public void connect() {
System.out.println("mysql的链接");
}
@Override
public void add() {
System.out.println("增加");
}
@Override
public void del() {
System.out.println("删除");
}
@Override
public void upd() {
System.out.println("修改");
}
@Override
public void sel() {
System.out.println("查询");
}
}
Homework7_MySqlDao:
public class Homework7_MySqlDao extends Homework7_AbstractDao {
@Override
public void connect() {
System.out.println("mysql的链接");
}
}
Homework7_OracleDao:
public class Homework7_OracleDao extends Homework7_AbstractDao {
@Override
public void connect() {
System.out.println("链接Oracle");
}
}
Homework7_Client:
import java.util.Scanner;
public class Homework7_Client {
public static void main(String[] args) {
System.out.println("请问您要链接的数据库是哪一个(1,Mysql。2,Oracle):");
Scanner scn = new Scanner(System.in);
int n = scn.nextInt();
Homework7_IDAO dao;
if (n == 1) {
dao = new Homework7_MySqlDao();
} else {
dao = new Homework7_OracleDao();
}
dao.connect();
dao.add();
dao.del();
dao.upd();
dao.sel();
}
}