private void toolStripButton1_Click(object sender, EventArgs e)
{
Form2 form2 = new Form2();
form2.StartPosition = FormStartPosition.CenterScreen;
if (form2.ShowDialog() != DialogResult.OK)
{
return;
}
conStr = form2.ConStr;
LoadDb();
}
public static string GetSql(DbConStrInfo conStr, int type, string table_name = "")
{
if (type == 1)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(string.Format("select * from information_schema.tables where table_schema='{0}'", conStr.Database));
}
if (conStr.ProviderType == ProviderType.SqlServer)
{
return(string.Format("select name as table_name from sys.objects where type='U' order by name"));
}
if (conStr.ProviderType == ProviderType.Oracle)
{
return("select table_name from user_tables");
}
}
if (type == 2)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(string.Format("select * from information_schema.views where table_schema='{0}'", conStr.Database));
}
if (conStr.ProviderType == ProviderType.SqlServer)
{
return(string.Format("select name as table_name from sys.objects where type='V' order by name"));
}
if (conStr.ProviderType == ProviderType.Oracle)
{
return("select * from user_views");
}
}
if (type == 3)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(string.Format("select * from information_schema.columns where table_schema='{0}' and table_name='{1}'",
conStr.Database, table_name));
}
if (conStr.ProviderType == ProviderType.SqlServer)
{
return(string.Format("SELECT * FROM sys.columns WHERE OBJECT_ID = (SELECT id FROM sys.sysobjects WHERE type IN ('U','V') AND name='{0}')", table_name));
}
if (conStr.ProviderType == ProviderType.Oracle)
{
return(string.Format("select * from USER_TAB_COLUMNS where table_name='{0}'", table_name));
}
}
return("");
}
public static int ExecuteNonQuery(DbConStrInfo conStr, string sql)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(MySqlConnector.ExecuteNonQuery(conStr.ConStr, sql));
}
else if (conStr.ProviderType == ProviderType.Oracle)
{
return(OracleConnector.ExecuteNonQuery(conStr.ConStr, sql));
}
else
{
return(SqlConnector.ExecuteNonQuery(conStr.ConStr, sql));
}
}
public static DataTable GetData(DbConStrInfo conStr, string sql)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(MySqlConnector.GetData(conStr.ConStr, sql));
}
else if (conStr.ProviderType == ProviderType.Oracle)
{
return(OracleConnector.GetData(conStr.ConStr, sql));
}
else
{
return(SqlConnector.GetData(conStr.ConStr, sql));
}
}
public static bool TestConnect(DbConStrInfo conStr)
{
if (conStr.ProviderType == ProviderType.MySql)
{
return(MySqlConnector.TestConnect(conStr.ConStr));
}
else if (conStr.ProviderType == ProviderType.Oracle)
{
return(OracleConnector.TestConnect(conStr.ConStr));
}
else
{
return(SqlConnector.TestConnect(conStr.ConStr));
}
}
private void button3_Click(object sender, EventArgs e)
{
ConStr = new DbConStrInfo
{
Server = tb_server.Text,
Port = tb_port.Text,
LogId = tb_logid.Text,
LogPass = tb_logpass.Text,
Database = cbb_db.Text,
Provider = cbb_provider.Text
};
if (AppFunc.TestConnect(ConStr))
{
MessageBox.Show("连接数据库成功！", "提示信息");
}
ConStr = null;
}
private void button1_Click(object sender, EventArgs e)
{
ConStr = new DbConStrInfo
{
Server = tb_server.Text,
Port = tb_port.Text,
LogId = tb_logid.Text,
LogPass = tb_logpass.Text,
Database = cbb_db.Text,
Provider = cbb_provider.Text
};
if (!AppFunc.TestConnect(ConStr))
{
ConStr = null;
return;
}
SaveXml("db_config.xml");
this.DialogResult = DialogResult.OK;
}
private void button2_Click(object sender, EventArgs e)
{
ConStr = null;
this.DialogResult = DialogResult.Cancel;
}
public Form3(string table, DbConStrInfo conStr)
{
InitializeComponent();
this.table = table;
this.conStr = conStr;
}
