資源簡介
學生時代用C#+Oracle做的管理系統,希望對學生有用

代碼片段和文件信息
using?System;
using?System.Collections.Generic;
using?System.ComponentModel;
using?System.Data;
using?System.Drawing;
using?System.Text;
using?System.Windows.Forms;
using?System.Data.OracleClient;
using?System.Data.Sql;
using?WindowsApplication1.model.command;
namespace?WindowsApplication1
{
????public?partial?class?Form1?:?Form
????{
????????public?Form1()
????????{
????????????InitializeComponent();
????????}
????????private?void?Form1_Load(object?sender?EventArgs?e)
????????{
????????}
????????private?void?button1_Click(object?sender?EventArgs?e)
????????{
???????????/*?int?i;
????????????string?s;
????????????string?sql?=?“select?empnoename?from?emp?where?empno=7369“;
????????????OracleCommand?cmd?=?new?OracleCommand(sql?database.GetOpen());
????????????OracleDataReader?reader?=?cmd.ExecuteReader();
????????????while?(reader.Read())
????????????{
????????????????i?=?reader.GetInt32(0);
????????????????s?=?reader.GetString(1);
????????????????textBox1.Text?=?Convert.ToString(i);
????????????????textBox2.Text?=?s;
????????????}
????????????database.GetClose();*/
????????????string?sql?=?“denglu“;
????????????OracleCommand?cmd?=?new?OracleCommand(sql?database.GetOpen());
????????????OracleParameter?opid?=?cmd.Parameters.Add(“flag“?OracleType.Number);
????????????opid.Direction?=?ParameterDirection.Output;
????????????cmd.Parameters.Add(“username“?OracleType.VarChar).Value?=?textBox1.Text;
????????????cmd.Parameters.Add(“upwd“?OracleType.Number).Value?=?textBox2.Text;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
????????????cmd.ExecuteNonQuery();
????????????int?i=?Convert.ToInt32(opid.Value.ToString());
????????????if?(i?==?0)
????????????{
????????????????MessageBox.Show(“用戶名或密碼錯誤“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Stop);
????????????}
????????????else?if?(i?==?1)
????????????{
????????????????MessageBox.Show(“密碼不正確“?“提示“?MessageBoxButtons.OK?MessageBoxIcon.Stop);
????????????}
????????????else?if?(i?==?2)
????????????{
????????????????WindowsApplication1.concole.主頁面?zym?=?new?WindowsApplication1.concole.主頁面();
????????????????zym.Show();
????????????????this.Hide();
????????????}
???????????//?textBox3.Text?=?Convert.ToString(i);
???????????//?int?i;
??????????//??if()
??????????/*??string?sql?=?“denglu“;
????????????OracleCommand?cmd?=?new?OracleCommand(sql?database.GetOpen());
???????????//?OracleParameter?opid?=?cmd.Parameters.Add(“flag“?OracleType.Number);
????????????//opid.Direction?=?ParameterDirection.Output;
????????????cmd.Parameters.Add(“ename“?OracleType.VarChar).Value?=?textBox1.Text;
????????????cmd.Parameters.Add(“empno“?OracleType.Number).Value?=?textBox2.Text;
????????????OracleParameter?opid?=?cmd.Parameters.Add(“flag“?OracleType.Number);
????????????opid.Direction?=?ParameterDirection.Output;
????????????cmd.CommandType?=?CommandType.StoredProcedure;
?????????//???int?pop?=?Convert.ToInt32(cmd.ExecuteReade
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-09-26?17:07??圖書管理系統\
?????文件??????342528??2012-09-26?17:07??圖書管理系統\123課程設計報告.doc
?????文件????33562624??2012-09-23?13:11??圖書管理系統\TUSHU.DBF
?????目錄???????????0??2012-09-26?17:02??圖書管理系統\WindowsApplication1\
?????目錄???????????0??2012-09-26?17:02??圖書管理系統\WindowsApplication1\WindowsApplication1\
?????文件?????????200??2012-09-20?23:35??圖書管理系統\WindowsApplication1\WindowsApplication1\App.config
?????文件????????4763??2012-09-20?22:40??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.Designer.cs
?????文件????????3676??2012-09-20?23:42??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.cs
?????文件????????5814??2012-09-20?22:40??圖書管理系統\WindowsApplication1\WindowsApplication1\Form1.resx
?????文件?????????478??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Program.cs
?????目錄???????????0??2012-09-26?17:02??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\
?????文件????????1186??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\AssemblyInfo.cs
?????文件????????2892??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\Resources.Designer.cs
?????文件????????5612??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\Resources.resx
?????文件????????1102??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\Settings.Designer.cs
?????文件?????????249??2012-09-16?00:32??圖書管理系統\WindowsApplication1\WindowsApplication1\Properties\Settings.settings
?????文件????????5715??2012-09-19?00:28??圖書管理系統\WindowsApplication1\WindowsApplication1\WindowsApplication1.csproj
?????目錄???????????0??2012-09-23?13:16??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\
?????目錄???????????0??2012-09-26?17:02??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\
?????文件???????57344??2012-09-22?20:34??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.exe
?????文件?????????200??2012-09-20?23:35??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.exe.config
?????文件???????91648??2012-09-22?20:34??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.pdb
?????文件????????5632??2005-11-11?22:25??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.vshost.exe
?????文件?????????200??2012-09-20?23:35??圖書管理系統\WindowsApplication1\WindowsApplication1\bin\Debug\WindowsApplication1.vshost.exe.config
?????目錄???????????0??2012-09-26?17:02??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\
?????文件????????6800??2012-09-19?00:17??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\主頁面.Designer.cs
?????文件????????1263??2012-09-19?00:17??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\主頁面.cs
?????文件????????6012??2012-09-19?00:17??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\主頁面.resx
?????文件????????9422??2012-09-19?00:34??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\入庫.Designer.cs
?????文件????????3083??2012-09-20?22:25??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\入庫.cs
?????文件????????5814??2012-09-19?00:34??圖書管理系統\WindowsApplication1\WindowsApplication1\concole\入庫.resx
............此處省略37個文件信息
- 上一篇:c# 簡單網頁程序
- 下一篇:c#(winform)調用VBS腳本
評論
共有 條評論