资源简介
链接数据库为MySQL
用户名:root
密码:123456
分为管理员页面、老师页面和学生页面
代码片段和文件信息
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using ksxt_database;
using System.Data;
namespace ksxt_bussiness
{
public class brief_an_question
{
private string brief_id;
public string Brief_id
{
get { return brief_id; }
set { brief_id = value; }
}
private string brief_questrion;
public string Brief_questrion
{
get { return brief_questrion; }
set { brief_questrion = value; }
}
private string brief_an_an;
public string Brief_an_an
{
get { return brief_an_an; }
set { brief_an_an = value; }
}
private string tid;
public string Tid
{
get { return tid; }
set { tid = value; }
}
public bool insert() {
string sqlcomm=“insert into brief_an_question(brief_idbrief_questrionbrief_an_antid) values(“;
sqlcomm+=“‘“+Brief_id+“‘‘“+Brief_questrion+“‘‘“+Brief_an_an+“‘‘“+Tid+“‘)“;
if (mysqlhelp.excutesql(sqlcomm))
{
return true;
}
else {
return false;
}
}
public bool del() {
string sqlcomm = “delete from brief_an_question where brief_id=“ + Brief_id;
if (mysqlhelp.excutesql(sqlcomm))
{
return true;
}
else {
return false;
}
}
public DataSet readdata() {
string sqlcomm = “select brief_idbrief_questrionbrief_an_antid from brief_an_question where tid=‘“ + Tid + “‘“;
DataSet ds = mysqlhelp.adapter(sqlcomm);
return ds;
}
public bool update() {
string sqlcomm = “update brief_an_question set brief_questrion=‘“+Brief_questrion + “‘brief_an_an=‘“+Brief_an_an + “‘tid=‘“+Tid + “‘ where brief_id=“ + Brief_id;
if (mysqlhelp.excutesql(sqlcomm))
{
return true;
}
else {
return false;
}
}
}
}
属性 大小 日期 时间 名称
----------- --------- ---------- ----- ----
目录 0 2015-01-16 12:17 ksxt\
文件 5852 2015-01-15 15:05 ksxt\ksxt 20150115 1505.sql
文件 2204 2015-01-16 12:18 ksxt\ksxt.sln
文件 64512 2015-01-16 12:18 ksxt\ksxt.suo
目录 0 2015-01-13 21:58 ksxt\ksxt_bussiness\
目录 0 2015-01-13 21:58 ksxt\ksxt_bussiness\bin\
目录 0 2015-01-15 17:08 ksxt\ksxt_bussiness\bin\Debug\
文件 15872 2015-01-15 17:08 ksxt\ksxt_bussiness\bin\Debug\ksxt_bussiness.dll
文件 48640 2015-01-15 17:08 ksxt\ksxt_bussiness\bin\Debug\ksxt_bussiness.pdb
文件 5632 2015-01-15 17:08 ksxt\ksxt_bussiness\bin\Debug\ksxt_databa
文件 13824 2015-01-15 17:08 ksxt\ksxt_bussiness\bin\Debug\ksxt_databa
文件 1971 2015-01-14 13:52 ksxt\ksxt_bussiness\brief_an_question.cs
文件 4143 2015-01-15 10:20 ksxt\ksxt_bussiness\ch_question.cs
文件 1927 2015-01-14 13:52 ksxt\ksxt_bussiness\full_in_blanks.cs
文件 2756 2015-01-13 21:58 ksxt\ksxt_bussiness\ksxt_bussiness.csproj
目录 0 2015-01-11 18:20 ksxt\ksxt_bussiness\obj\
目录 0 2015-01-16 11:46 ksxt\ksxt_bussiness\obj\Debug\
文件 5720 2015-01-16 12:18 ksxt\ksxt_bussiness\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache
文件 437 2015-01-15 17:08 ksxt\ksxt_bussiness\obj\Debug\ksxt_bussiness.csproj.FileListAbsolute.txt
文件 18066 2015-01-16 11:46 ksxt\ksxt_bussiness\obj\Debug\ksxt_bussiness.csprojResolveAssemblyReference.cache
文件 15872 2015-01-15 17:08 ksxt\ksxt_bussiness\obj\Debug\ksxt_bussiness.dll
文件 48640 2015-01-15 17:08 ksxt\ksxt_bussiness\obj\Debug\ksxt_bussiness.pdb
目录 0 2015-01-11 18:20 ksxt\ksxt_bussiness\obj\Debug\TempPE\
目录 0 2015-01-11 18:20 ksxt\ksxt_bussiness\Properties\
文件 1378 2015-01-11 18:20 ksxt\ksxt_bussiness\Properties\AssemblyInfo.cs
文件 2430 2015-01-12 09:44 ksxt\ksxt_bussiness\students.cs
文件 1467 2015-01-11 18:23 ksxt\ksxt_bussiness\subject.cs
文件 2584 2015-01-15 12:25 ksxt\ksxt_bussiness\teacher.cs
目录 0 2015-01-11 18:22 ksxt\ksxt_databa
目录 0 2015-01-11 18:21 ksxt\ksxt_databa
目录 0 2015-01-15 17:08 ksxt\ksxt_databa
............此处省略204个文件信息
评论
共有 条评论