数据库系统原理Word文档下载推荐.docx
《数据库系统原理Word文档下载推荐.docx》由会员分享,可在线阅读,更多相关《数据库系统原理Word文档下载推荐.docx(23页珍藏版)》请在冰豆网上搜索。
农民户口号,姓名,身份证号,年龄,性别,民族,住址,是否家长,是否已婚等家庭成员的基本信息处理,这些操作跟microsoftsqlserver2005连接完成的。
农民财产信息模块能添加、删除、修改和查询农民财产信息,这个模块儿我们能中我们能在动物选项和机械工具处理操作,能加,删除,修改动物名和机械工具名,如我们能添加,删除,修改,牛、羊、鸡…农业机械工具…
2.程序算法:
1)系统功能结构图:
注意:
由于程序内容较多,流程图按模块画的。
系统运行流程图
2)代码:
连接数据库的代码如下:
UsingSystem;
usingSystem.Collections.Generic;
usingSystem.Text;
usingSystem.Data;
usingSystem.Data.Sql;
usingSystem.Windows.Forms;
usingSystem.Data.SqlClient;
namespace乡村农民财产信息管理系统
{
classCData
{
publicCData()
}
publicstringconn_sql=@"
DataSource=WIN-KMFBGMGGB45\SQLEXPRESS;
InitialCatalog=nc_info;
IntegratedSecurity=True"
;
publicintRUN_SQL(stringsql)
try
SqlConnectionconn=newSqlConnection(conn_sql);
SqlCommandcomm=newSqlCommand(sql,conn);
if(conn.State==ConnectionState.Closed)
conn.Open();
inti=comm.ExecuteNonQuery();
conn.Close();
returni;
catch(Exceptionex)
MessageBox.Show(ex.Message);
return-1;
publicDataTableget_data(stringsql)
SqlDataAdapterda=newSqlDataAdapter(sql,conn);
DataTabledt=newDataTable();
da.Fill(dt);
returndt;
catch(Exceptionex)
returnnull;
}
农民家庭基本信息代码:
usingSystem;
usingSystem.ComponentModel;
usingSystem.Drawing;
usingSystem.IO;
publicpartialclassfamily:
Form
publicfamily()
InitializeComponent();
CDatadata=newCData();
stringimages_path="
iam.jpg"
publicintbianliang()
stringsign_no="
"
sex="
hk_nom="
name="
adress="
intage=0,mz_id=0;
hk_nom=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||hk_nom.Length!
=6)
MessageBox.Show("
户口号必须是6位数字!
);
txthukouhao.Focus();
elseif(name.Length==0)
姓名不能空!
txtxingming.Focus();
elseif(sign_no.Length==0&
&
sign_no.Length!
=18)
身份证号必须是18位数字"
txtshenfenzheng.Focus();
elseif(adress.Length==0)
住址不能空。
txtzhuzhi.Focus();
else
return1;
publicvoidqingkong()
txthukouhao.Clear();
txtshenfenzheng.Clear();
txtxingming.Clear();
txtzhuzhi.Clear();
checkhunyin.Checked=false;
checkjiazhang.Checked=false;
privatevoidchushihua()
stringsql="
selectmz_id,mz_namefromminzu"
DataTabledt=data.get_data(sql);
combominzu.DataSource=dt;
combominzu.DisplayMember="
mz_name"
.Trim();
combominzu.ValueMember="
mz_id"
for(inti=1;
i<
=120;
i++)
combonianling.Items.Add(i);
comboxingbie.Items.Add("
男"
女"
comboxingbie.SelectedIndex=0;
combominzu.SelectedIndex=0;
combonianling.SelectedIndex=19;
publicvoidtianjia()
stringjiazhang="
否"
stringhunyin="
未婚"
stringhk_nom=txthukouhao.Text.Trim();
stringsign_no=txtshenfenzheng.Text.Trim();
stringname=txtxingming.Text.Trim();
stringadress=txtzhuzhi.Text.Trim();
intage=Convert.ToInt32(combonianling.SelectedItem);
stringsex=comboxingbie.SelectedItem.ToString();
intmz_id=Convert.ToInt32(combominzu.SelectedValue);
if(checkjiazhang.Checked==true)
jiazhang="
是"
if(checkhunyin.Checked==true)
hunyin="
已婚"
insertintomain_info(hk_id,nm_name,sign_num,sex,jiazhang,hunyin,age,mz_id,address,picture)values('
+hk_nom+"
'
'
+name+"
+sign_no+"
+sex+"
+jiazhang+"
+hunyin+"
+age+"
+mz_id+"
+adress+"
+images_path+"
)"
if(bianliang()>
-1)
inti=data.RUN_SQL(sql);
if(i>
0)
成功!
qingkong();
失败!
{
此人信息已存在,不能重复添加!
publicintshanchu(strings_no)
DialogResultdr=MessageBox.Show("
你真的要永久删除身份证号为"
+s_no+"
的信息吗?
"
你好。
MessageBoxButtons.YesNo,MessageBoxIcon.Question);
if(dr==DialogResult.Yes)
deletefrommain_infowheresign_num='
publicDataTableGetAll()
select*fromview_family"
dt=data.get_data(sql);
privatevoidFjibenxinxi_Load(objectsender,EventArgse)
dGView1.DataSource=GetAll();
chushihua()
privatevoidbttianjia_Click(objectsender,EventArgse)
tianjia();
privatevoidbttuichu_Click(objectsender,EventArgse)
this.Close();
privatevoiddGView1_CellMouseClick(objectsender,DataGridViewCellMouseEventArgse)
if(e.RowIndex>
txthukouhao.Text=(dGView1.Rows[e.RowIndex].Cells["
户口号"
].Value.ToString());
txtshenfenzheng.Text=(dGView1.Rows[e.RowIndex].Cells["
身份证号"
].Value).ToString().Trim();
txtxingming.Text=(dGView1.Rows[e.RowIndex].Cells["
姓名"
txtzhuzhi.Text=(dGView1.Rows[e.RowIndex].Cells["
住址"
combominzu.Text=(dGView1.Rows[e.RowIndex].Cells["
民族"
combonianling.Text=(dGView1.Rows[e.RowIndex].Cells["
年龄"
comboxingbie.Text=(dGView1.Rows[e.RowIndex].Cells["
性别"
hunyin=(dGView1.Rows[e.RowIndex].Cells["
是否已婚"
if(hunyin=="
)
{checkhunyin.Checked=true;
{checkhunyin.Checked=false;
jiazhang=dGView1.Rows[e.RowIndex].Cells["
是否家长"
].Value.ToString().Trim();
if(jiazhang=="
{checkjiazhang.Checked=true;
else{checkjiazhang.Checked=false;
stringimage1=dGView1.Rows[e.RowIndex].Cells["
图片"
].Value.ToString();
pictureBox1.Image=Image.FromFile(Application.StartupPath+"
\\img\\"
+image1);
+ex.Message);
privatevoidbtshanchu_Click(objectsender,EventArgse)
stringsfz=txtshenfenzheng.Text.Trim();
//MessageBox.Show("
身份证="
+sfz);
if(sfz.Length!
=0||sfz.Length==18)
inti=shanchu(sfz);
chushihua();
请正确输入你要删除的人的身份证号。
privatevoidbtixiugai_Click(objectsender,EventArgse)
updatemain_infosethk_id='
+hk_nom+"
nm_name='
+name+"
sex='
+sex+"
jiazhang='
+jiazhang+"
hunyin='
+hunyin+"
age='
+age+"
mz_id='
+mz_id+"
address='
+adress+"
picture='
+images_path+"
wheresign_num='
+sign_no+"
inti=data.RUN_SQL(sql);
修改成功!
elseMessageBox.Show("
修改失败,请你检查信息再试。
privatevoidbtchaxun_Click(objectsender,EventArgse)
stringname=txtxingming.Text.Trim();
stringsfz_no=txtshenfenzheng.Text.Trim();
stringhk_no=txthukouhao.Text.Trim();
stringsql_chaxun="
if(name.Length!
=0||sfz_no.Length!
=0||hk_no.Length!
=0)
MessageBox.Show(name+sfz_no+hk_no);
sql_chaxun=sql_chaxun+"
where(姓名like'
%"
%'
or身份证号like'
+sfz_no+"
)and户口号like'
+hk_no+"
dGView1.DataSource=data.get_data(sql_chaxun);
不能空或有误。
privatevoidbttupian_Click(objectsender,EventArgse)
OpenFileDialogfp=newOpenFileDialog();
DialogResultdr=fp.ShowDialog();
if(dr==DialogResult.OK)
FileInfoinfo=newFileInfo(fp.FileName);
images_path=info.Name;
pictureBox1.Image=Image.FromFile(fp.FileName);
privatevoid民族ToolStripMenuItem1_Click(objectsender,EventArgse)
Fminzuminzu=newFminzu();
minzu.Show();
privatevoid退出ToolStripMenuItem2_Click(objectsender,EventArgse)
机械工具表的代码:
usi