c#开发数据库考试题2

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;

namespace WindowsFormsApplication3
{
    class DBHelper
    {
        private string connString = @"Data Source=.;Initial Catalog=assetsDB;Integrated Security=True";

        // 数据库连接 Connection 对象    
        private SqlConnection connection;

        /// <summary>    
        /// Connection对象    
        /// </summary>    
        public SqlConnection Connection
        {
            get
            {
                if (connection == null)
                {
                    connection = new SqlConnection(connString);
                }
                return connection;
            }
        }

        /// <summary>    
        /// 打开数据库连接    
        /// </summary>    
        public void OpenConnection()
        {
            if (Connection.State == ConnectionState.Closed)
            {
                Connection.Open();
            }
            else if (Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
                Connection.Open();
            }
        }

        public void CloseConnection()
        {
            if (Connection.State == ConnectionState.Open || Connection.State == ConnectionState.Broken)
            {
                Connection.Close();
            }
        }    
    }
}




using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace WindowsFormsApplication3
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void 增加固定管理ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            Form2 f = new Form2();
            f.MdiParent = this;
            f.Show();
        }

        private void 查询固定资产ToolStripMenuItem_Click(object sender, EventArgs e)
        {

            Form3 f = new Form3();
            f.MdiParent = this;
            f.Show();
        }

        private void 退出ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.Close();
        }
    }
}



using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication3
{
    public partial class Form2 : Form
    {
        public Form2()
        {
            InitializeComponent();
        }

        DBHelper db = new DBHelper();


        public bool CheckInfo()
        {
            if (this.textBox1.Text.Trim().Equals(string.Empty))
            {
                MessageBox.Show("请完整填写信息","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);
                this.textBox1.Focus();
                return false;
            }
            else  if (this.textBox2.Text.Trim().Equals(string.Empty))
            {
                MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.textBox2.Focus();
                return false;
            }
            else if (this.textBox3.Text.Trim().Equals(string.Empty))
            {
                MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.textBox3.Focus();
                return false;
            }
            else if (this.comboBox1.Text.Trim().Equals("请输入类型"))
            {
                MessageBox.Show("请完整填写信息", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                this.textBox1.Focus();
                return false;
            }
            else
            {
                return true;
            }
        }

        public void insertInfo()
        {
            try
            {
                StringBuilder sql = new StringBuilder();
                sql.AppendLine("INSERT assets (assetId,assetName,assteType,intoDate) ");
                sql.AppendFormat("  VALUES ('{0}','{1}','{2}','{3}')", this.textBox1.Text, this.textBox2.Text, this.comboBox1.Text, this.textBox3.Text);
                SqlCommand comm = new SqlCommand(sql.ToString(), db.Connection);
                db.OpenConnection();
                int result = comm.ExecuteNonQuery();
                if (result == 1)
                {
                    string sqlNo = "SELECT @@IDENTITY FROM Student";
                    comm.CommandText = sqlNo;
                 }   
                   

                  
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            
        }

        private void Form2_Load(object sender, EventArgs e)
        {
           
        }

        private void button1_Click(object sender, EventArgs e)
        {

             if (CheckInfo())
            {
                insertInfo();
                MessageBox.Show("新增成功!", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }
    }
}




using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace WindowsFormsApplication3
{
    public partial class Form3 : Form
    {
        public Form3()
        {
            InitializeComponent();
        }

        DBHelper db = new DBHelper();
        DataSet ds = new DataSet();
        SqlDataAdapter adapter = null;
        public void GetInfo()
        {

            try
            {
                string sql = "SELECT * FROM assets";
                adapter = new SqlDataAdapter(sql, db.Connection);
                adapter.Fill(ds, "assets");
                this.dataGridView1.DataSource = ds.Tables["assets"];

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }

        public void SearchInfo()
        {
            try
            {
                if (ds.Tables["assets"] != null)
                {
                    ds.Tables["assets"].Clear();
                }
                StringBuilder sql = new StringBuilder();
                sql.AppendLine("SELECT * FROM assets");
                sql.AppendFormat("   WHERE assetId='{0}' OR assteType='{1}'", this.textBox1.Text,this.comboBox1.Text);
                adapter = new SqlDataAdapter(sql.ToString(), db.Connection);
                adapter.Fill(ds, "assets");
               

            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
            finally
            {
                db.CloseConnection();
            }

        }

        private void Form3_Load(object sender, EventArgs e)
        {
            GetInfo();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            if (this.dataGridView1.SelectedRows[0].Cells[0].Value.ToString().Equals(null))
            {
                MessageBox.Show("没有查询到结果", "输入提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            else
            {
                SearchInfo();
            }
        }
    }
}