protected void Button1_Click(object sender, EventArgs e)
{
MyDataBase studentsDB = new MyDataBase("studentDB");
Label1.Text = "";
studentsDB.sqlCommand.CommandText="Insert into studentInfo(stu_id,stu_name,stu_sex,address,photo) values(@id,@name,@sex,@address,@photo)";
studentsDB.sqlCommand.Parameters.AddWithValue("@id", TextBox_id.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@name", TextBox_name.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@sex", TextBox_sex.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@address", TextBox_address.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@photo", FileUpload_photo.FileBytes);
try
{
studentsDB.openConnection();
studentsDB.sqlCommand.ExecuteNonQuery();
Label1.Text = "插入成功";
}
catch (Exception ex)
{
Label1.Text = "插入失败";
}
finally
{
studentsDB.closeConnection();
clear();
}
}
// Возварщает текущий уровень
public int GetCurrentLevel()
{
string curLevel = MyDataBase.ExecuteQueryWithAnswer($"SELECT last_level FROM Setting WHERE id_setting = {user}");
if (curLevel == "")
{
return(-1);
}
return(Convert.ToInt32(curLevel));
}
public static async System.Threading.Tasks.Task SetGroup(string command)
{
if (command.Split(' ').Length != 2)
{
throw new Exception("You must specify your group number using \"/setgroup\"");
}
string group = command.Split(' ')[1];
await MyDataBase.SQLWriter(group);
Console.WriteLine("Group set successfully");
}
private void Start()
{
// Получаем отсортированную таблицу лидеров
DataTable scoreboard = MyDataBase.GetTable("SELECT * FROM Scores ORDER BY score DESC;");
// Получаем id лучшего игрока
int idBestPlayer = int.Parse(scoreboard.Rows[0][1].ToString());
// Получаем ник лучшего игрока
string nickname = MyDataBase.ExecuteQueryWithAnswer($"SELECT nickname FROM Player WHERE id_player = {idBestPlayer};");
Debug.Log($"Лучший игрок {nickname} набрал {scoreboard.Rows[0][2].ToString()} очков.");
}
static void OnRemove(object sender, EventArgs e)
{
if (QuickGTK.Confirm($"Are you sure you want to remove {sc_rec}?"))
{
MyDataBase.RemoveRec(sc_rec);
Pages.Sensitive = false;
ButRemove.Sensitive = false;
ButForceMod.Sensitive = false;
sc_rec = "";
//QuickGTK.Info("KILL AND DESTROY!!"); // debug
}
}
protected void Page_Load(object sender, EventArgs e)
{
string us = Request.Form["username"];
string pass = Request.Form["password"];
string email = Request.Form["email"];
string firstname = Request.Form["firstname"];
string lastname = Request.Form["lastname"];
string city = Request.Form["city"];
string strSQL = "UPDATE table1 SET pass_d='" + pass + "' , email_d='" + email + "' , city_d='" + city + "' , fn_d='" + firstname + "' , ln_d='" + lastname + "' where user_d='" + us + "'";
MyDataBase.ExecuteNonQuery(strSQL);
}
// Загрузка сохраненных нод
private void LoadBlueprint()
{
currentLevel = MainMenu.instance.GetCurrentLevel();
DataTable idBlueprint = MyDataBase.GetTable("SELECT id_conroller FROM level_controller " +
$"WHERE id_level = {currentLevel}");
foreach (DataRow row in idBlueprint.Rows)
{
FormBlueprint.instance.AppendBlueprint(complineCharBlpr[row[0].ToString()]);
}
}
private void mainwindow_Closing(object sender, System.ComponentModel.CancelEventArgs e)
{
if (Evennote.OfflineMode)
{
return;
}
if (Evennote.user != null && Evennote.user.online == true)
{
MyDataBase.ConnectToDB();
MyDataBase.SetOfflineUser(Evennote.user.id);
MyDataBase.CloseConnectToDB();
}
}
public void LevelBttns(int level)
{
int price = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT Coins FROM Level WHERE Id_lvl=" + level + ";"));
if (nickname == null || nickname == "")
{
; //добавить действие, если ник не введен, а пользователь нажимает начать игру
}
else
{
if (MyDataBase.GetTable("SELECT * FROM Player WHERE nickname = \"" + nickname + "\";").Rows.Count == 0)
{//если пользователь не зареган. регаем
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO Player(nickname) VALUES(\"" + nickname + "\");");
}
int id_player = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_player FROM Player WHERE nickname = \"" + nickname + "\";"));
int current_bayed_lvl = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_lvl FROM Player WHERE id_player = \"" + id_player + "\";"));
if (level <= current_bayed_lvl)
{
SceneManager.LoadScene(level + 1);
return;
}
else if (level != 1 + current_bayed_lvl)
//пытается купить через уровень
{
return;
}
int how_much_coins_of_player = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT coins FROM Player WHERE id_player = " + id_player + ";"));
if (how_much_coins_of_player <= price)
//если у игрока до этго не было койнов или не достаточно
{
//добавить действие, если он бомж, и у него нет денег на уровень
}
else
{
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Player SET coins=coins-" + price + " WHERE id_player=" + id_player + ";");
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Player SET id_lvl=" + level + " WHERE id_player=" + id_player + ";");
SceneManager.LoadScene(level + 1);
}
}
}
public bool CheckUserData(string account, string password)
{
/*
* try
* {
* string sql = "SELECT 1 FROM user WHERE account = @account AND password = @password;";
* MySqlCommand cmd = db.MySqlCommand(sql);
* cmd.Parameters.Add("@account", MySqlDbType.VarChar).Value = account;
* cmd.Parameters.Add("@password", MySqlDbType.VarChar).Value = password;
*
* db.Connect();
*
* using (MySqlDataReader reader = cmd.ExecuteReader())
* {
* if (reader.Read())
* return true;
* }
* return false;
* }
* catch (Exception ex)
* {
* string error = ex.ToString();
* return false;
* }
* finally
* {
* db.Disconnect();
* }
* */
string sql = "SELECT 1 FROM user WHERE account = @account AND password = @password;";
using (MyDataBase db = new MyDataBase())
{
MySqlCommand cmd = db.MySqlCommand(sql);
cmd.Parameters.Add("@account", MySqlDbType.VarChar).Value = account;
cmd.Parameters.Add("@password", MySqlDbType.VarChar).Value = password;
db.Connect();
using (MySqlDataReader dr = cmd.ExecuteReader())
{
if (dr.Read())
{
return(true);
}
}
return(false);
}
}
void Awake()
{
if (myData == null)
{
myData = Resources.Load <MyDataBase>("MyDataBase");
}
if (PlayerTalkPanel == null)
{
PlayerTalkPanel = GameObject.Find("PlayerTalkPanel").GetComponent <TalkPanel>();
}
if (Selection == null)
{
Selection = GameObject.Find("Selection").GetComponent <TalkPanel>();
}
}
// Update is called once per frame
void Update()
{
if (Service.text != "")
{
if (!MyDataBase.Search_For_Service(Service.text, All_Services.Services_Names))
{
Old_Login.text = "";
Old_Password.text = "";
}
}
else
{
Old_Login.text = "";
Old_Password.text = "";
}
}
void Start()
{
string nick = NewBehaviourScript.nickname;
int id_player = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_player FROM Player WHERE nickname = \"" + nick + "\";"));
if (MyDataBase.GetTable("SELECT * FROM Skins WHERE skin_id = " + id_player + ";").Rows.Count == 0)
//если не установлен скин
{
birds[0].SetActive(true);
}
else
{
int skin_id = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT skin_id FROM Player WHERE id_player = \"" + id_player + "\";"));
birds[skin_id].SetActive(true);
}
}
private void button1_Click(object sender, EventArgs e)
{
User myuser = new User();
myuser.Username = textBox1.Text;
myuser.Password = textBox2.Text;
if (MyDataBase.Finduser(myuser))
{
AddBook add = new AddBook();
add.ShowDialog();
}
else
{
MessageBox.Show("Invalid");
}
}
// Use this for initialization
void Start()
{
// Получаем отсортированную таблицу лидеров
DataTable scoreboard = MyDataBase.GetTable("SELECT * FROM Scores ORDER BY score DESC LIMIT 10;");
/*// Получаем id лучшего игрока
* int idBestPlayer = int.Parse(scoreboard.Rows[0][1].ToString());
* // Получаем ник лучшего игрока
* string nickname = MyDataBase.ExecuteQueryWithAnswer("SELECT nickname FROM Player WHERE id_player = "+idBestPlayer+";");
* raitingText.text = "Лучший игрок " +nickname+" набрал "+scoreboard.Rows[0][2].ToString()+" очков.";
*/
raitingText.text = "ТОП 10 ИГРОКОВ\n";
for (int i = 0; i < scoreboard.Rows.Count; i++)
{
raitingText.text += (i + 1) + " место: " + MyDataBase.ExecuteQueryWithAnswer("SELECT nickname FROM Player WHERE id_player = " + scoreboard.Rows[i][1].ToString() + ";") + " " + scoreboard.Rows[i][2].ToString() + " очков\n";
}
}
// Update is called once per frame
void Update()
{
string nick = NewBehaviourScript.nickname;
int id_player = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_player FROM Player WHERE nickname = \"" + nick + "\";"));
if (MyDataBase.GetTable("SELECT sc_die FROM Person_kab WHERE player_id = " + id_player + ";").Rows.Count == 0)
//если у игрока до этго не было коинов
{
Diedscore.text = "0";
nametext.text = MyDataBase.ExecuteQueryWithAnswer("SELECT nickname FROM PLayer WHERE nickname = \"" + nick + "\";");
}
else
{
count.text = MyDataBase.ExecuteQueryWithAnswer("SELECT coins FROM Player WHERE id_player=\"" + id_player + "\";");
Diedscore.text = MyDataBase.ExecuteQueryWithAnswer("SELECT sc_die FROM Person_kab WHERE player_id = \"" + id_player + "\";");
nametext.text = MyDataBase.ExecuteQueryWithAnswer("SELECT nickname FROM PLayer WHERE nickname = \"" + nick + "\";");
}
if (Input.GetKeyDown(KeyCode.Escape))
{
SceneManager.LoadScene(0);
}
/*if (MyDataBase.GetTable("SELECT * FROM Player WHERE id_lvl = " + id_player + ";").Rows.Count == 0)
* //
* {
* lvlup.text ="0";
* }
* else*/
{
string levels = "";
int id_lvl = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_lvl FROM Player WHERE id_player = \"" + id_player + "\";"));
for (int lvl = 1; lvl <= id_lvl;)
{
levels += lvl;
if (++lvl <= id_lvl)
{
levels += " - ";
}
}
lvlup.text = levels;
// int lvlup = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_lvl FROM Player WHERE id_player = \"" + id_player + "\";"));
}
}
// Сохраняет шаблон текущего уровня
private void SaveBlueprint()
{
List <string> saveChar = new List <string>();
foreach (BlueprintBase blueprint in FormBlueprint.instance.blueprintBases)
{
saveChar.Add(complineCharBlpr.FirstOrDefault(x => x.Value == blueprint.typeBlueprint).Key);
}
MyDataBase.ExecuteQueryWithoutAnswer($"DELETE FROM level_controller WHERE id_level = {currentLevel}");
foreach (string s in saveChar)
{
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO level_controller (id_conroller, id_level)" +
$" VALUES ({s}, {currentLevel})");
}
}
public void StartGame()
{
if (nickname == null || nickname == "")
{
SceneManager.LoadScene(5);
}//добавить действие, если ник не введен, а пользователь нажимает начать игру
else
{
if (MyDataBase.GetTable("SELECT * FROM Player WHERE nickname = \"" + nickname + "\";").Rows.Count == 0)
{//если пользователь не зареган. регаем
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO Player(nickname) VALUES(\"" + nickname + "\");");
}
levelChanger.SetActive(true);
}
}
public ActionResult Village(string id = "") //Day23 AJAX用
{
MyDataBase db = new MyDataBase();
List <Village> list = db.GetVillageList();
string result = "";
if (list == null)
{
//資料庫聯線錯誤
return(Json(result));
}
else
{
result = JsonConvert.SerializeObject(list);
return(Json(result));
}
}
public bool ContainCreatedTableName(string createdTableName)
{
bool result = true;
if (!createdTableNames.Contains(createdTableName))
{
try
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer($"SELECT * FROM {createdTableName}");
}
catch
{
result = false;
}
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
// switch (Request.Form["submitBtn"].ToString())
//{
// case "חפש לפי שם " :
// {
// SerchByName();
// PrintTable();
// }
// break;
//
// case "חפש לפי שם משפחה":
// {
// SerchByLastName();
// PrintTable();
// }
// break;
// }
// }
// private void SerchByName()
// {
// string fName = Request.Form["user"];
// if (fName.Equals("") == false)
// {
// whereStr += "Name'" + fName + "' ";
// }
// Session["WhereStr"] = whereStr;
// }
// private void SerchByLastName()
// {
// string lname = Request.Form["lastname"];
// if(lname.Equals("") == false)
// whereStr += " LastName='" + lname + "'";
// }
DataTable dt = MyDataBase.GetFullTable("table1", Condition);
if (dt.Rows.Count == 0)
{
PrintTable();
}
}
public static bool Authorization(string username, string password)
{
//Подключение к своей базе данных
MyDataBase.ConnectToDB();
//Проверяем совпадают ли имя и пароли
MyDataBase.ExecuteCommand("SELECT * FROM users WHERE users.username = '******' AND users.userpass = '******'");
//Проверка, нашли ли мы вообще такого пользователя в БД
if (MyDataBase.rdr.HasRows == false)
{
//Надо сделать throwException //ай, потом..
MyDataBase.rdr.Close();
MyDataBase.CloseConnectToDB();
return(false);
}
//Читаем данные
while (MyDataBase.rdr.Read())
{
MySql.Data.Types.MySqlDateTime x = (MySql.Data.Types.MySqlDateTime)MyDataBase.rdr[5];
DateTime tempDate = new DateTime(x.Year, x.Month, x.Day);
//Сохраняем данные о себе
user = new User(Convert.ToInt32(MyDataBase.rdr[0].ToString()),
MyDataBase.rdr[1].ToString(),
MyDataBase.rdr[3].ToString(),
MyDataBase.rdr[4] as byte[],
tempDate);
}
contextUser = user;
MyDataBase.rdr.Close();
//Пишем что мы онлайн в БД
MyDataBase.SetOnlineUser(user.id);
//Отключаемся от БД
MyDataBase.CloseConnectToDB();
return(true);
}
protected void Page_Load(object sender, EventArgs e)
{
string user = Request.Form["user"];
Condition += "user_d='" + user + "'";
DataTable dt = MyDataBase.GetFullTable("table1", Condition);
if (dt.Rows.Count == 0)
{
Session["Search"] = "false";
}
else
{
Session["Search"] = "true";
}
}
private void logout_btn_Click(object sender, RoutedEventArgs e)
{
Notebook.notebook.RemoveRange(0, Notebook.notebook.Count);
if (Evennote.OfflineMode)
{
(Application.Current.MainWindow as MainWindow).ChangePage("pages/login_page.xaml");
System.IO.File.Delete(Evennote.ConfigFile);
Evennote.OfflineMode = false;
return;
}
Evennote.user.online = false;
(Application.Current.MainWindow as MainWindow).ChangePage("pages/login_page.xaml");
Evennote.AutoLogin = false;
System.IO.File.Delete(Evennote.ConfigFile);
MyDataBase.ConnectToDB();
MyDataBase.ChangeOnlineStatus(Evennote.user.id);
MyDataBase.CloseConnectToDB();
Evennote.user = null;
}
private void PrintTable()
{
DataTable dt = MyDataBase.GetFullTable("table1", ConditionA);
string str = "";
Response.Write("<table>");
foreach (DataRow dr in dt.Rows)
{
Response.Write("<tr>");
Response.Write("<td>" + dr["user_d"] + "</td>");
Response.Write("<td>" + dr["fn_d"] + "</td>");
Response.Write("<td>" + dr["ln_d"] + "</td>");
Response.Write("<td>" + dr["email_d"] + "</td>");
Response.Write("<td>" + dr["pass_d"] + "</td>");
Response.Write("<td>" + dr["city_d"] + "</td>");
Response.Write("<td>" + dr["gender_d"] + "</td>");
Response.Write("<tr>");
}
Response.Write("</table>");
}
public string Execute(string[] args)
{
string result = "Unknown error!";
string path = $"{Configuration.GetVariable("UpdateFolder")}/{args[1]}.sql".Replace("//", "/");
if (args.Length > 1 && File.Exists(path))
{
try
{
MyDataBase.GetDB().ExecuteQueries(File.ReadAllLines(path));
result = "OK!";
}
catch { result = "E: Can't access file or file is corupted!"; }
}
else
{
result = "Incorrect path!";
}
return(result);
}
void OnTriggerEnter2D(Collider2D trigger)
{
if (trigger.gameObject.tag == "Finish")
{
Fp.SetActive(true);
Time.timeScale = 0;
isPaused = true;
string nick = NewBehaviourScript.nickname;
int id_player = int.Parse(MyDataBase.ExecuteQueryWithAnswer("SELECT id_player FROM Player WHERE nickname = \"" + nick + "\";"));
if (MyDataBase.GetTable("SELECT * FROM Scores WHERE id_player = " + id_player + ";").Rows.Count == 0)
//если у игрока до этго не было очков
{
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO Scores(id_player, score) VALUES(" + id_player + "," + score + ");");
if (MyDataBase.GetTable("SELECT coins FROM Player WHERE id_player = " + id_player + ";").Rows.Count == 0)
//если у игрока до этго не было койнов
{
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO Player(id_player, coins) VALUES(" + id_player + "," + score + ");");
}
else
{
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Player SET coins=coins+" + score + " WHERE id_player=" + id_player + ";");
}
}
else
{
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Scores SET score=" + score + " WHERE id_player=" + id_player + ";");
if (MyDataBase.GetTable("SELECT coins FROM Player WHERE id_player = " + id_player + ";").Rows.Count == 0)
//если у игрока до этго не было койнов
{
MyDataBase.ExecuteQueryWithoutAnswer("INSERT INTO Player(id_player, coins) VALUES(" + id_player + "," + score + ");");
}
else
{
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Player SET coins=coins+" + score + " WHERE id_player=" + id_player + ";");
}
}
MyDataBase.ExecuteQueryWithoutAnswer("UPDATE Person_kab SET sc_die=sc_die+" + 1 + " WHERE player_id=" + id_player + ";");
}
}
protected void Button2_Click(object sender, EventArgs e)
{
MyDataBase studentsDB = new MyDataBase("studentDB");
Label1.Text = "";
if(RadioButtonById.Checked)
{
studentsDB.sqlCommand.CommandText="Select * from studentInfo where stu_id=@id";
studentsDB.sqlCommand.Parameters.AddWithValue("@id",TextBox_id.Text);
}
else if(RadioButtonByName.Checked)
{
studentsDB.sqlCommand.CommandText="Select * from studentInfo where stu_name=@name";
studentsDB.sqlCommand.Parameters.AddWithValue("@name",TextBox_name.Text);
}
else
{
studentsDB.sqlCommand.CommandText="Select * from studentInfo where stu_sex=@sex";
studentsDB.sqlCommand.Parameters.AddWithValue("@sex", TextBox_sex.Text);
}
try
{
studentsDB.openConnection();
SqlDataReader sqlDRder=studentsDB.sqlCommand.ExecuteReader();
while (sqlDRder.Read())
{
Label1.Text += sqlDRder.GetString(0)+ " ";
Label1.Text += sqlDRder.GetString(1) + " ";
Label1.Text += sqlDRder.GetString(2) + " ";
Label1.Text += sqlDRder.GetString(3) + " "+"</br>";
}
}
catch (Exception ex)
{
Label1.Text = "查询失败";
}
finally
{
studentsDB.closeConnection();
clear();
}
}
public override string Execute()
{
string result = "OK!";
try
{
string[] tempArr = Query.Split(' ');
string tableName = tempArr.Length > 2 ? tempArr[2].ToUpper() : null;
// Create table
MyDataBase.GetDB().ExecuteQueryWithoutAnswer(Query);
// After executing query, add data to the desired lists.
queryExecutor.AddCreatedTableNames(tableName);
}
catch (Exception ex)
{
result = $"E: {ex.Message}";
}
return(result);
}
protected void Page_Load(object sender, EventArgs e)
{
string user = Request.Form["user"];
Condition += "user_d='" + user + "'";
DataTable dt = MyDataBase.GetFullTable("table1", Condition);
if (dt.Rows.Count == 0)
{
Response.Write(ShowTableHeaders());
Response.Write(ShowFullTable1());
}
else
{
Response.Write(ShowTableHeaders());
Response.Write(ShowTable());
}
}
protected void Button3_Click(object sender, EventArgs e)
{
MyDataBase studentsDB = new MyDataBase("studentDB");
Label1.Text = "";
studentsDB.sqlCommand.CommandText = "delete from studentInfo where stu_id=@id";
studentsDB.sqlCommand.Parameters.AddWithValue("@id", TextBox_id.Text);
try
{
studentsDB.openConnection();
if(studentsDB.sqlCommand.ExecuteNonQuery()>0)
Label1.Text = "删除成功";
}
catch (Exception ex)
{
Label1.Text = "删除失败";
}
finally
{
studentsDB.closeConnection();
}
}
private void button1_Click(object sender, EventArgs e)
{
User newuser = new User();
newuser.Name = textBox1.Text;
newuser.Surname = textBox2.Text;
newuser.Email = textBox3.Text;
newuser.Username = textBox4.Text;
newuser.Password = textBox5.Text;
if (MyDataBase.Finduser(newuser))
{
MessageBox.Show("Account exists");
}
else
{
MyDataBase.Users.Add(newuser);
AddBook add = new AddBook();
add.ShowDialog();
}
}
public override string Execute()
{
string result = "OK!";
try
{
string[] tempArr = Query.Split(' ');
string tableName = tempArr.Length > 2 ? tempArr[2].ToUpper() : null;
// Contains true if the table was created in this sql script
bool isTableCreated = queryExecutor.ContainCreatedTableName(tableName);
// Make a temporary table if it was not created.
if (!isTableCreated && !MyDataBase.GetDB().IsExistringTable("temp_" + tableName))
{
MyDataBase.GetDB().ExecuteQueryWithoutAnswer($"CREATE TABLE {"temp_" + tableName} AS SELECT * FROM {tableName}");
}
// Delete data from existing table
MyDataBase.GetDB().ExecuteQueryWithoutAnswer(Query);
// After executing query, add data to the desired lists.
if (!isTableCreated)
{
if (!queryExecutor.ContainTableName(tableName))
{
queryExecutor.AddTableNames(tableName);
}
string undoQuery = $"DROP TABLE {tableName}";
if (!queryExecutor.ContainUndoQuery(undoQuery))
{
queryExecutor.AddUndoQueries(undoQuery);
}
}
}
catch (Exception ex)
{
result = $"E: {ex.Message}";
}
return(result);
}
protected void Button5_Click(object sender, EventArgs e)
{
MyDataBase studentsDB = new MyDataBase("studentDB");
studentsDB.sqlCommand.CommandText = "select *from users where name=@name";
studentsDB.sqlCommand.Parameters.AddWithValue("@name", TextBox_name.Text);
try
{
studentsDB.openConnection();
SqlDataReader sqlDRed = studentsDB.sqlCommand.ExecuteReader();
sqlDRed.Read();
if (!sqlDRed.HasRows)
{
Label1.Text="用户不存在";
}
else if (sqlDRed.GetString(1).Equals( TextBox_password.Text))
{
Session["result"] = "欢迎您" + sqlDRed.GetString(0);
Server.Transfer("~/logResult.aspx");
}
else
{
Label1.Text = "密码错误";
}
}
catch (Exception ex)
{
Label1.Text = "错误:"+ex.Message;
}
finally
{
studentsDB.closeConnection();
}
}
protected void Button4_Click(object sender, EventArgs e)
{
MyDataBase studentsDB = new MyDataBase("studentDB");
Label1.Text = "";
studentsDB.sqlCommand.CommandText = "update studentInfo set stu_name=@name,stu_sex=@sex,address=@address where stu_id=@id";
studentsDB.sqlCommand.Parameters.AddWithValue("@id", TextBox_id.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@name", TextBox_name.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@sex", TextBox_sex.Text);
studentsDB.sqlCommand.Parameters.AddWithValue("@address", TextBox_address.Text);
try
{
studentsDB.openConnection();
if (studentsDB.sqlCommand.ExecuteNonQuery() > 0)
Label1.Text = "更新成功";
}
catch (Exception ex)
{
Label1.Text = "更新失败";
}
finally
{
studentsDB.closeConnection();
clear();
}
}
