public void TestCreateRetrieveAndDeleteRow()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("INSERT INTO test_table (ID, Description) "+
"VALUES (1, 'ettal')");
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
Query q2 = new Query("SELECT Description "+
"FROM test_table "+
"WHERE ID=1");
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.DataRemaining());
result.NextRow();
var strResult = result.ReadString("Description");
Assert.AreEqual("ettal", strResult);
Query q3 = new Query("DELETE FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q3);
Assert.IsNotNull(result);
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.AmountOfRows() == 0);
}
public void TestDateTime()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("INSERT INTO test_table (ID, DateCreated) " +
"VALUES (1, @dateCreated)");
q.addDateTimeParameter("datecreated", DateTime.Today.Date);
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
Query q2 = new Query("SELECT DateCreated " +
"FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.DataRemaining());
result.NextRow();
Assert.AreEqual(DateTime.Today.Date, result.ReadDateTime("DateCreated"));
Query q3 = new Query("DELETE FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q3);
Assert.IsNotNull(result);
}
private void bt_OK_Click(object sender, EventArgs e)
{
DatabaseHelper.DBHelper helper = DatabaseHelper.DBHelper.GetDBHelper();
//if(!helper.ExistTable("用户表"))
//{
// new DatabaseCreater().CreateTableUser(helper.GetConnector());
//}
if (helper.Login(cmb_UserName.Text, tb_Password.Text, ref RealName, ref UserRoler))
{
UserName = cmb_UserName.Text;
UserPassword = tb_Password.Text;
if (cb_Remember.Checked)
{
// 登录时 如果没有Data.bin文件就创建、有就打开
FileStream fs = new FileStream("userData.bin", FileMode.OpenOrCreate);
BinaryFormatter bf = new BinaryFormatter();
// 保存在实体类属性中
if (UserDatas.Any(u => u.Key == cmb_UserName.Text))
{
UserDatas.Remove(cmb_UserName.Text);
}
UserDatas.Add(cmb_UserName.Text, tb_Password.Text);
//写入文件
bf.Serialize(fs, UserDatas);
//关闭
fs.Close();
fs.Dispose();
fs = null;
}
this.DialogResult = System.Windows.Forms.DialogResult.OK;
}
else
{
MessageBox.Show("您输入的用户名或密码不正确，请重新输入！");
UserDatas.Remove(cmb_UserName.Text);
FileStream fs = new FileStream("userData.bin", FileMode.OpenOrCreate);
BinaryFormatter bf = new BinaryFormatter();
//写入文件
bf.Serialize(fs, UserDatas);
//关闭
fs.Close();
fs.Dispose();
fs = null;
cmb_UserName.Text = "";
tb_Password.Text = "";
cmb_UserName.Focus();
cmb_UserName.DataSource = UserDatas.Keys.ToList();
if (cmb_UserName.Items.Count > 0)
{
cmb_UserName.SelectedIndex = 0;
}
}
}
public void TestConnectToDatabase()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("SELECT DB_NAME() AS Name");
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
result.NextRow();
var strResult = result.ReadString("Name");
Assert.AreEqual("testing", strResult);
}
public void TestCreateDBHelper()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
dbHelper = new DBHelper(DatabaseType.Simulation);
}
private static void SetupTestDatabaseForMSSQL(DBHelper dbHelper)
{
string name = "michael";
string password = "******";
string serverurl = "localhost\\SQLEXPRESS";
string databasename = "testing";
dbHelper.SetLoginInformation(name, password, databasename, serverurl);
}
public void TestIntParametrization()
{
DBHelper dbHelper = new DBHelper(DatabaseType.MicrosoftSQLServer);
SetupTestDatabaseForMSSQL(dbHelper);
Query q = new Query("INSERT INTO test_table (ID, Description) " +
"VALUES (@id, 'ettal')");
q.addIntParameter("id", 1);
SqlResult result = dbHelper.executeQuery(q);
Assert.IsNotNull(result);
Query q2 = new Query("SELECT Description " +
"FROM test_table " +
"WHERE ID=@id");
q2.addIntParameter("id", 1);
result = dbHelper.executeQuery(q2);
Assert.IsNotNull(result);
Assert.IsTrue(result.DataRemaining());
result.NextRow();
var strResult = result.ReadString("Description");
Assert.AreEqual("ettal", strResult);
Query q3 = new Query("DELETE FROM test_table " +
"WHERE ID=1");
result = dbHelper.executeQuery(q3);
Assert.IsNotNull(result);
}
/// <summary>
/// Defines a new MicrosoftSqlServerModule.
/// </summary>
/// <param name="dbHelper">The parent.</param>
public MicrosoftSQLServerModule(DBHelper dbHelper)
{
DbHelper = dbHelper;
}
