基于C#编写的图书管理系统【100010444】

> # ♻️ 资源 > **大小：** 12.7MB > **文档链接：**[**https://www.yuque.com/sxbn/ks/100010444**](https://www.yuque.com/sxbn/ks/100010444) > **➡️ 资源下载：**[**https://download.csdn.net/download/s1t16/87390789**](https://download.csdn.net/download/s1t16/87390789) > **注：更多内容可关注微信公众号【神仙别闹】，如当前文章或代码侵犯了您的权益，请私信作者删除！** >  # **模块及对应代码说明**  模块如下：  **总的有效功能代码量1118，平均每一个模块有效功能代码70行** 部分主要逻辑代码： ```csharp public partial class user_info : Form { public user_info() { InitializeComponent(); } private void user_info_Load(object sender, EventArgs e) { //直接把信息填入到textbox中 string user_name = sign_in.sign_name; string user_pass = sign_in.sign_password; string query_text_find_user = "select * from user_info where username = \'" + user_name + "\'"; NpgsqlConnection conn = new NpgsqlConnection(sign_in.connstr); NpgsqlCommand cmd = new NpgsqlCommand(query_text_find_user, conn); conn.Open(); NpgsqlDataReader reader = cmd.ExecuteReader(); reader.Read(); textBox1.Text = reader.GetString(0); textBox2.Text = reader.GetString(1); try { textBox3.Text = reader.GetString(2); }catch(Exception ex) { textBox3.Text = ""; } try { textBox4.Text = reader.GetString(3); }catch(Exception ex) { textBox4.Text = ""; } try { textBox5.Text = reader.GetString(4); }catch(Exception ex) { textBox5.Text = ""; } if(reader.GetString(5) == "男") { comboBox1.SelectedIndex = comboBox1.Items.IndexOf("男"); }else { comboBox1.SelectedIndex = comboBox1.Items.IndexOf("女"); } try { richTextBox1.Text = reader.GetString(7); }catch(Exception ex) { richTextBox1.Text = ""; } } private void button1_Click(object sender, EventArgs e) { string user_name = sign_in.sign_name; string user_pass = sign_in.sign_password; string query_text_update_user = "update user_info set name = '" + textBox2.Text + "' , mail = '" + textBox3.Text + "' , address = '" + textBox4.Text + "' , occupy = '" + textBox5.Text + "' , sex = '" + comboBox1.SelectedItem.ToString() + "' , self_info = '" + richTextBox1.Text + "' where username = '" + user_name + "'"; } } NpgsqlConnection conn = new NpgsqlConnection(sign_in.connstr); NpgsqlCommand cmd = new NpgsqlCommand(query_text_update_user, conn); conn.Open(); cmd.ExecuteNonQuery(); MessageBox.Show("修改成功", "恭喜", MessageBoxButtons.OK); conn.Close(); //用户信息更新 user_info_Load(null,null); public partial class book_manage : Form { public book_manage() { InitializeComponent(); } private void label2_Click(object sender, EventArgs e) { } private void book_manage_Load(object sender, EventArgs e) { string user_name = sign_in.sign_name; string user_pass = sign_in.sign_password; string query_text_find_books = "select * from book_info"; NpgsqlConnection conn = new NpgsqlConnection(sign_in.connstr); DataSet dataSet = new DataSet(); NpgsqlDataAdapter adapter = new NpgsqlDataAdapter(query_text_find_books, conn); adapter.Fill(dataSet, "图书"); dataGridView1.DataSource = dataSet.Tables["图书"]; dataGridView1.Columns[0].HeaderText = "序号"; dataGridView1.Columns[1].HeaderText = "书名"; dataGridView1.Columns[2].HeaderText = "作者"; dataGridView1.Columns[3].HeaderText = "出版社"; dataGridView1.Columns[4].HeaderText = "简介"; conn.Close(); } private void dataGridView1_CellMouseUp(object sender, DataGridViewCellMouseEventArgs e) { if (e.Button == MouseButtons.Right) { if (e.RowIndex >= 0) { dataGridView1.ClearSelection(); dataGridView1.Rows[e.RowIndex].Selected = true; dataGridView1.CurrentCell = dataGridView1.Rows[e.RowIndex].Cells[e.ColumnIndex]; contextMenuStrip1.Show(MousePosition.X, MousePosition.Y); } } } private void 删除ToolStripMenuItem_Click(object sender, EventArgs e) { //删除选定的图书 string user_name = sign_in.sign_name; string user_pass = sign_in.sign_password; string query_text_delete_book = "delete from book_info where book_id = " + int.Parse(dataGridView1.CurrentRow.Cells[0].Value.ToString()); if(MessageBox.Show("您确定要删除该书吗?","请确 认",MessageBoxButtons.YesNo) == DialogResult.Yes) conn); { NpgsqlConnection conn = new NpgsqlConnection(sign_in.connstr); NpgsqlCommand cmd = new NpgsqlCommand(query_text_delete_book, conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("删除成功", "恭喜", MessageBoxButtons.OK); book_manage_Load(null, null); } else { return; } } private void button1_Click(object sender, EventArgs e) { string user_name = sign_in.sign_name; string user_pass = sign_in.sign_password;