C#自动测试的一个模板

来源：互联网发布：儿童编程课程编辑：程序博客网时间：2024/05/21 22:49

一、表结构

mysql> select * from users;
+-----+--------+--------+
| id | name | passwd |
+-----+--------+--------+
| 001 | bzcyer | 123456 |
| 002 | Jerry | 111111 |
+-----+--------+--------+
2 rows in set (0.03 sec)

二、测试代码

三、代码

1、将测试案例写到TestCase.txt中。

如：

001:bzcyer:123456
002:Jerry:123456
003:Jerry:111111

2、从TestCase.txt中读取测试数据和预期结果，从数据库中读取真实结果，做比对。测试结果写入文件TestResult.txt

using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using MySql.Data.MySqlClient;using System.Collections;using System.IO;using System.Globalization;namespace ADOTest{ public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { FileStream fs = new FileStream("testCase.txt",FileMode.Open); StreamReader sr = new StreamReader(fs); string line,caseID,name,password,expected; string [] tokens,tempInput; DateTime dt = DateTime.Now; string str1 = "TestResult" + dt.ToString("s"); string fileName = str1.Replace(':','-')+".txt"; FileStream ofs = new FileStream(fileName, FileMode.Create); StreamWriter sw = new StreamWriter(ofs); while((line=sr.ReadLine())!=null) { tokens = line.Split(':'); caseID = tokens[0]; name = tokens[1]; expected = tokens[2]; if (expected == getPassword(name)) { listBox1.Items.Add("Case " + caseID + ":" + " Pass."); sw.WriteLine("Case " + caseID + ":" + " Pass."); } else { listBox1.Items.Add("Case " + caseID + ":" + " Failed."); sw.WriteLine("Case " + caseID + ":" + " Failed."); } } sr.Close(); fs.Close(); sw.Close(); ofs.Close(); } //从数据库中读取密码 private string getPassword(string user) { string connStr = "Database=lrtest;Data Source=localhost;"+ "User Id=root;Password=111111"; string searchStr = "select passwd from users where name ='" + user + "'"; MySqlConnection conn = new MySqlConnection(connStr); conn.Open(); MySqlCommand cmd = new MySqlCommand(searchStr,conn); MySqlDataReader reader = cmd.ExecuteReader(); reader.Read(); return reader.GetString(0); conn.Close(); } }}