數(shù)據(jù)庫(kù)系統(tǒng)原理

1、精選優(yōu)質(zhì)文檔-傾情為你奉上精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)專心-專注-專業(yè)精選優(yōu)質(zhì)文檔-傾情為你奉上專心-專注-專業(yè)學(xué)年論文（數(shù)據(jù)庫(kù)系統(tǒng)原理與應(yīng)用）題目： 鄉(xiāng)村農(nóng)民財(cái)產(chǎn)管理系統(tǒng) 作者： 所在學(xué)院： 信息學(xué)院計(jì)算機(jī)系 專業(yè)年級(jí)： 計(jì)算機(jī)09-4 指導(dǎo)教師： 職稱： 副教授 2012年06月06日二、大作業(yè)目的：1進(jìn)一步掌握Microsoft Visual Studio 2005(c#)的編程能力。2進(jìn)一步理解和使用Microsoft Visual Studio 2005(c#)和microsoft sql server 2005的基礎(chǔ)知識(shí)并且深刻的了解界面和數(shù)據(jù)庫(kù)中的聯(lián)合處理數(shù)據(jù)等知識(shí)

2、。3熟練掌握Microsoft Visual Studio 2005(c#)的基本知識(shí)和技能。4能夠利用所學(xué)的基本知識(shí)和技能，解決簡(jiǎn)單的程序設(shè)計(jì)問(wèn)題。5更深刻的了解和使用sql server的連接，視圖，查詢，更新等一些功能。三、要求： 1要求利用Microsoft Visual Studio 2005(c#)面向?qū)ο笳Z(yǔ)言和編程思想來(lái)完成設(shè)計(jì)。2要求突出Microsoft Visual Studio 2005(c#)的函數(shù)特征，界面美化，使用方便，以多個(gè)函數(shù)來(lái)實(shí)現(xiàn)每個(gè)功能。3進(jìn)行簡(jiǎn)學(xué)界面設(shè)計(jì)，能夠?qū)崿F(xiàn)有好的交互。4掌握并熟練運(yùn)用Microsoft Visual Studio 2005(c#)總

3、的和數(shù)據(jù)庫(kù)之間的連接處理數(shù)據(jù)功能。四、大作業(yè)內(nèi)容及代碼、運(yùn)行結(jié)果1 內(nèi)容： 農(nóng)民家庭基本信息模塊能添加、刪除、修改和查詢農(nóng)民個(gè)人基本信息。農(nóng)民主要以家庭成員基本信息為主，如：農(nóng)民戶口號(hào)，姓名，身份證號(hào)，年齡，性別，民族，住址，是否家長(zhǎng)，是否已婚等家庭成員的基本信息處理，這些操作跟microsoft sql server 2005 連接完成的。農(nóng)民財(cái)產(chǎn)信息模塊能添加、刪除、修改和查詢農(nóng)民財(cái)產(chǎn)信息,這個(gè)模塊兒我們能中我們能在動(dòng)物選項(xiàng)和機(jī)械工具處理操作，能加，刪除，修改 動(dòng)物名和機(jī)械工具名，如 我們能添加，刪除，修改,牛、羊、雞農(nóng)業(yè)機(jī)械工具2程序算法： 1）系統(tǒng)功能結(jié)構(gòu)圖：注意：由于程序內(nèi)容較多，流

4、程圖按模塊畫的。開(kāi)始開(kāi)始農(nóng)民家庭基本信息處理農(nóng)民家庭財(cái)產(chǎn)信息處理添加修改刪除添加修改刪除查詢查詢按姓名查詢按身份證查詢按戶口號(hào)查詢按姓名查詢系統(tǒng)運(yùn)行流程圖開(kāi)始開(kāi)始農(nóng)民家庭基本信息處理農(nóng)民家庭財(cái)產(chǎn)信息處理家庭信息管理模塊民族信息管理模塊財(cái)產(chǎn)信息管理模塊動(dòng)物信息管理模塊機(jī)械工具管理模塊退出系統(tǒng)退出2）代碼：連接數(shù)據(jù)庫(kù)的代碼如下:Using System;using System.Collections.Generic;using System.Text;using System.Data;using System.Data.Sql;using System.Windows.Forms;using

5、System.Data.SqlClient;namespace 鄉(xiāng)村農(nóng)民財(cái)產(chǎn)信息管理系統(tǒng) class CData public CData() public string conn_sql = Data Source=WIN-KMFBGMGGB45SQLEXPRESS;Initial Catalog=nc_info;Integrated Security=True; public int RUN_SQL(string sql) try SqlConnection conn = new SqlConnection(conn_sql); SqlCommand comm = new SqlComma

6、nd(sql, conn); if (conn.State = ConnectionState.Closed) conn.Open(); int i = comm.ExecuteNonQuery(); conn.Close(); return i; catch (Exception ex) MessageBox.Show(ex.Message); return -1; public DataTable get_data(string sql) try SqlConnection conn = new SqlConnection(conn_sql); SqlDataAdapter da = ne

7、w SqlDataAdapter(sql, conn); DataTable dt = new DataTable(); da.Fill(dt); return dt; catch(Exception ex) MessageBox.Show(ex.Message); return null; 農(nóng)民家庭基本信息代碼:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.IO;using System.

8、Text;using System.Windows.Forms;namespace 鄉(xiāng)村農(nóng)民財(cái)產(chǎn)信息管理系統(tǒng) public partial class family : Form public family() InitializeComponent(); CData data = new CData(); string images_path = iam.jpg; public int bianliang() string sign_no = , sex = , hk_nom = , name = , adress = ; int age = 0, mz_id = 0; try hk_nom

9、 = txthukouhao.Text.Trim(); sign_no = txtshenfenzheng.Text.Trim(); name = txtxingming.Text.Trim(); adress = txtzhuzhi.Text.Trim(); age = Convert.ToInt32(combonianling.SelectedItem); sex = comboxingbie.SelectedItem.ToString(); mz_id = Convert.ToInt32(combominzu.SelectedValue); if (hk_nom.Length = 0 |

10、 hk_nom.Length != 6) MessageBox.Show(戶口號(hào)必須是6位數(shù)字！); txthukouhao.Focus(); return -1; else if (name.Length = 0) MessageBox.Show(姓名不能空！); txtxingming.Focus(); return -1; else if (sign_no.Length = 0 & sign_no.Length != 18) MessageBox.Show(身份證號(hào)必須是18位數(shù)字); txtshenfenzheng.Focus(); return -1; else if (adress

11、.Length = 0) MessageBox.Show(住址不能空。); txtzhuzhi.Focus(); return -1; else return 1; catch (Exception ex) MessageBox.Show(ex.Message); return -1; public void qingkong() txthukouhao.Clear(); txtshenfenzheng.Clear(); txtxingming.Clear(); txtzhuzhi.Clear(); checkhunyin.Checked = false; checkjiazhang.Chec

12、ked = false; private void chushihua() string sql = select mz_id,mz_name from minzu; DataTable dt = data.get_data(sql); combominzu.DataSource = dt; combominzu.DisplayMember = mz_name.Trim(); combominzu.ValueMember = mz_id.Trim(); for (int i = 1; i -1) int i = data.RUN_SQL(sql); if (i 0) MessageBox.Sh

13、ow(成功!); qingkong(); else MessageBox.Show(失敗!); catch (Exception ex) MessageBox.Show(此人信息已存在，不能重復(fù)添加！); public int shanchu(string s_no) try DialogResult dr = MessageBox.Show(你真的要永久刪除身份證號(hào)為 + s_no + 的信息嗎？, 你好。, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr = DialogResult.Yes) string sql = d

14、elete from main_info where sign_num= + s_no + ; int i = data.RUN_SQL(sql); return i; return -1; catch (Exception ex) MessageBox.Show(ex.Message); return -1; public DataTable GetAll() string sql = select * from view_family; DataTable dt = new DataTable(); dt = data.get_data(sql); return dt; private v

15、oid Fjibenxinxi_Load(object sender, EventArgs e) dGView1.DataSource = GetAll(); chushihua() private void bttianjia_Click(object sender, EventArgs e) tianjia(); dGView1.DataSource = GetAll(); private void bttuichu_Click(object sender, EventArgs e) this.Close(); private void dGView1_CellMouseClick(obj

16、ect sender, DataGridViewCellMouseEventArgs e) try if (e.RowIndex -1) string jiazhang = 否; string hunyin = 未婚; txthukouhao.Text = (dGView1.Rowse.RowIndex.Cells戶口號(hào).Value.ToString(); txtshenfenzheng.Text = (dGView1.Rowse.RowIndex.Cells身份證號(hào).Value).ToString().Trim(); txtxingming.Text = (dGView1.Rowse.Row

17、Index.Cells姓名.Value).ToString().Trim(); txtzhuzhi.Text = (dGView1.Rowse.RowIndex.Cells住址.Value).ToString().Trim(); combominzu.Text = (dGView1.Rowse.RowIndex.Cells民族.Value).ToString().Trim(); combonianling.Text = (dGView1.Rowse.RowIndex.Cells年齡.Value).ToString().Trim(); comboxingbie.Text = (dGView1.R

18、owse.RowIndex.Cells性別.Value).ToString().Trim(); hunyin = (dGView1.Rowse.RowIndex.Cells是否已婚.Value).ToString().Trim(); if (hunyin = 已婚) checkhunyin.Checked = true; else checkhunyin.Checked = false; jiazhang = dGView1.Rowse.RowIndex.Cells是否家長(zhǎng).Value.ToString().Trim(); if (jiazhang = 是) checkjiazhang.Che

19、cked = true; else checkjiazhang.Checked = false; string image1 = dGView1.Rowse.RowIndex.Cells圖片.Value.ToString(); pictureBox1.Image = Image.FromFile(Application.StartupPath + img + image1); catch (Exception ex) MessageBox.Show(+ex.Message ); private void btshanchu_Click(object sender, EventArgs e) s

20、tring sfz = txtshenfenzheng.Text.Trim(); / MessageBox.Show(身份證=+sfz); if (sfz.Length != 0 | sfz.Length = 18) int i = shanchu(sfz); if (i 0) dGView1.DataSource = GetAll(); qingkong(); chushihua(); else MessageBox.Show(請(qǐng)正確輸入你要?jiǎng)h除的人的身份證號(hào)。); txtshenfenzheng.Focus(); private void btixiugai_Click(object se

21、nder, EventArgs e) string jiazhang = ; string hunyin = ; string hk_nom = txthukouhao.Text.Trim(); string sign_no = txtshenfenzheng.Text.Trim(); string name = txtxingming.Text.Trim(); string adress = txtzhuzhi.Text.Trim(); int age = Convert.ToInt32(combonianling.SelectedItem); string sex = comboxingb

22、ie.SelectedItem.ToString(); int mz_id = Convert.ToInt32(combominzu.SelectedValue); if (checkjiazhang.Checked = true) jiazhang = 是; else jiazhang = 否; if (checkhunyin.Checked = true) hunyin = 已婚; else hunyin = 未婚; if (bianliang() 0) string sql = update main_info set hk_id=+hk_nom+, nm_name=+name+, se

23、x=+sex+,jiazhang=+jiazhang+,hunyin=+hunyin+,age=+age+,mz_id=+mz_id+,address=+adress+,picture=+images_path + where sign_num=+sign_no+; int i=data.RUN_SQL(sql); if (i 0) MessageBox.Show(修改成功！); dGView1.DataSource = GetAll(); else MessageBox.Show(修改失敗，請(qǐng)你檢查信息再試。); private void btchaxun_Click(object send

24、er, EventArgs e) string name = txtxingming.Text.Trim (); string sfz_no=txtshenfenzheng.Text.Trim (); string hk_no=txthukouhao.Text .Trim (); string sql_chaxun = select * from view_family; if (name.Length != 0|sfz_no.Length !=0|hk_no.Length !=0 ) MessageBox.Show(name+sfz_no+hk_no ); sql_chaxun = sql_

25、chaxun + where (姓名 like % + name + % or 身份證號(hào) like % + sfz_no + %) and 戶口號(hào) like % + hk_no + %; dGView1.DataSource = data .get_data(sql_chaxun); else MessageBox.Show(不能空或有誤。); txthukouhao.Focus(); private void bttupian_Click(object sender, EventArgs e) OpenFileDialog fp = new OpenFileDialog(); DialogR

26、esult dr = fp.ShowDialog(); if (dr = DialogResult.OK) FileInfo info = new FileInfo(fp.FileName); images_path = info.Name; pictureBox1.Image = Image.FromFile(fp.FileName); private void 民族ToolStripMenuItem1_Click(object sender, EventArgs e) Fminzu minzu = new Fminzu(); minzu.Show(); private void 退出Too

27、lStripMenuItem2_Click(object sender, EventArgs e) this.Close(); 機(jī)械工具表的代碼:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;namespace 鄉(xiāng)村農(nóng)民財(cái)產(chǎn)信息管理系統(tǒng) public partial class Fjixie : Form public Fjix

28、ie() InitializeComponent(); int id = 0; CData data = new CData(); public DataTable get_all() string sql = select *from jixie; DataTable dt = new DataTable(); dt = data.get_data(sql ); return dt; private void Fjixie_Load(object sender, EventArgs e) dGViewjixies.DataSource = get_all(); private void dG

29、Viewjixies_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) if (e.RowIndex -1) txtjixie.Text =(dGViewjixies .Rows e.RowIndex .Cells jx_name.Value ).ToString (); id = Convert.ToInt32(dGViewjixies.Rowse.RowIndex.Cellsjx_id.Value); private void bttianjia_Click(object sender, EventArgs e)

30、 string name = txtjixie.Text.Trim(); if (name.Length != 0) string sql = insert into jixie(jx_name)values ( + name + ); int i = data.RUN_SQL(sql); if (i 0) MessageBox.Show(修改成功！); dGViewjixies.DataSource = get_all(); txtjixie.Clear(); else MessageBox.Show(修改失??！); private void btxiugai_Click(object sender, EventArgs e) string name = txtjixie.Text.Trim(); if (name.Length != 0) string sql = update jixie set jx_name=+name + where jx_id=+id; int i = data.RUN_SQL(sql); if (i 0) MessageBox.Show(修改成功！); dGViewjixies.DataSource = get_al