定义一个操作数据库的库,支持Mysql, Mssql
// 定义一个操作数据库的库,支持Mysql, Mssql
interface DBI<T> {
add(info: T): boolean;
update(info: T): boolean;
delete(info: T): boolean;
get(id:number): any[];
}
// 定义一个操作Mysql数据库的类
class MysqlDbI<T> implements DBI<T>{
add(info: T): boolean {
console.log(info);
return true;
}
update(info: T): boolean {
console.log(info);
return true;
}
delete(info: T): boolean {
throw new Error("Method not implemented.");
}
get(id: number): any[] {
throw new Error("Method not implemented.");
}
}
// 定义一个操作Mssql数据库的类
class MssqlDbI<T> implements DBI<T>{
add(info: T): boolean {
console.log(info);
return true;
}
update(info: T): boolean {
console.log(info);
return true;
}
delete(info: T): boolean {
console.log(info);
return true;
}
get(id: number): any[] {
var list = [{id:1,title:"标题1",desc:"内容1"} ,
{ id: 2, title: "标题2", desc: "内容2" }]
return list;
}
}
// 操作用户表; 定义一个用户表和数据表做映射
class UserInfo {
name: string | undefined;
pwd: string | undefined;
constructor(name: string, pwd: string) {
this.name = name;
this.pwd = pwd;
}
}
var ui = new UserInfo("威龙","123");
var mydb = new MysqlDbI<UserInfo>();
mydb.add(ui);
var msdb = new MssqlDbI<UserInfo>();
console.log(msdb.get(123));