public static void create_db_tab()
{
MyDatabase domain = new MyDatabase();
domain.DbName = "管理";
domain.TableName = "admin";
Dictionary <string, string> columns = new Dictionary <string, string>();
columns.Add("username", "varchar(50)");
columns.Add("upass", "varchar(50)");
columns.Add("级别", "int");
domain.Columns = columns;
AccessOp.CreateAccessDb(domain.DbName);
AccessOp.CreateAccessTab(domain);
}
public static void test_4()
{
OleDbConnection con = AccessOp.getCon(null);
OleDbCommand cmd = con.CreateCommand();
cmd.CommandText = "select * from admin";
cmd.Connection = con;
OleDbDataAdapter db = new OleDbDataAdapter();
OleDbDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.WriteLine("{0} {1} {2}", reader.GetString(1), reader.GetString(2), reader.GetInt32(3));
}
AccessOp.closeAll(con, cmd, reader);
Console.Read();
}
public static void test()
{
string file = "G:\\createAccess\\admin.accdb";
AccessOp.CreateAccessDb(file);
}
private static void test_2()
{
OleDbConnection con = AccessOp.getCon(null);
}
public static void create_totalTable()
{
AccessOp.CreateDeptTotalTab("manager");
}
public static void createPurviewTab()
{
AccessOp.CreatePurviewTab("manager");
}
