工資管理Java實現(xiàn)代碼.doc

實現(xiàn)在管理系統(tǒng)中，數(shù)據(jù)庫的連接顯得尤為重要，決定了用戶能否對數(shù)據(jù)庫進行操作，其中數(shù)據(jù)庫連接的類(Base.cs)的實現(xiàn)代碼：public class Base#region OleDbConnection conn;static string str = Provider=Microsoft.Jet.OLEDB.4.0;Data Source= + Directory.GetCurrentDirectory() + manange.mdb;public Base() conn = new OleDbConnection(str);conn.Open();#endregion #region public int ExeSQL(string sql) OleDbCommand cmd = new OleDbCommand(sql,this.conn);try cmd.ExecuteNonQuery();return 0;catch(System.Data.OleDb.OleDbException ex) throw new Exception(ex.ToString();finally cmd.Dispose();this.conn.Close();#endregion對工資管理系統(tǒng)(WagesInfoForm.cs和WagesRecord.cs)的增加刪除的代碼:WagesInfoForm.cs的刪除操作該模塊是工資管理系統(tǒng)的主要功能模塊，當用戶是管理員時，點擊刪除信息時會刪除選中的工資記錄，或者右擊選中信息也可以刪除信息。刪除成功后，刷新列表。該模塊的刪除功能的主要代碼為：private void delete(object sender, System.EventArgs e)DialogResult result = MessageBox.Show(是否刪除此記錄,提示?!,MessageBoxButtons.YesNo,MessageBoxIcon.Question);if(result = DialogResult.Yes)string str = delete from WagesInfo where wwwaId= + int.Parse(this.dataGrid1this.dataGrid1.CurrentCell.RowNumber,0.ToString();Base bb = new Base();bb.ExeSQL(str);this.DBDataGrid();MessageBox.Show(刪除成功!);if(result = DialogResult.No)return;WagesRecord.cs的確定操作，對工資管理進行修改和增加該模塊是工資管理系統(tǒng)的主要功能模塊，當用戶是管理員時，點擊增加或修改信息時會修改或增加選中的工資記錄，或者右擊選中信息也可以修改或增加信息。修改增加成功后，刷新列表。該模塊的增加或修改功能的主要代碼為：private void button1_Click(object sender, System.EventArgs e)if(WagesInfoForm.wwID = insert) string s = insert into WagesInfo (waId,Id,enDate,enMonney,enMonney1,enMonney2,enMonney3,enMonney4,enMonney5) values (;s += int.Parse(this.No_cb.Text.Trim() + , + int.Parse(this.WagesId_txt.Text.Trim() + , + this.Time_dtp.Value.ToShortDateString();s += , + Convert.ToDecimal(this.Exp_txt.Text.Trim() + , + Convert.ToDecimal(this.Exp1_txt.Text.Trim() + , + Convert.ToDecimal(this.Exp2_txt.Text.Trim();s += , + Convert.ToDecimal(this.Exp3_txt.Text.Trim() + , + Convert.ToDecimal(this.Exp4_txt.Text.Trim() + , + Convert.ToDecimal(this.Exp5_txt.Text.Trim() +);Base b = new Base();b.ExeSQL(s);MessageBox.Show(添?加成功|!);if(WagesInfoForm.wwID = update) string s = update WagesInfo set Id= + int.Parse(this.WagesId_txt.Text.Trim() + ,enDate= + this.Time_dtp.Value.ToShortDateString() + ,enMonney=;s += Convert.ToDecimal(this.Exp_txt.Text.Trim() + ,enMonney1= + Convert.ToDecimal(this.Exp1_txt.Text.Trim() + ,enMonney2=;s += Convert.ToDecimal(this.Exp2_txt.Text.Trim() + ,enMonney3= + Convert.ToDecimal(this.Exp3_txt.Text.Trim();s += ,enMonney4= + Convert.ToDecimal(this.Exp4_txt.Text.Trim() + ,enMonney5= + Convert.ToDecimal(this.Exp