/**
* 根据书名搜索书籍
*/
private void FillList(string title, string author)
{
MySqlConnection conn = MysqlUtil.createConn();
string sqlcmd = "";
try
{
if (author.Length != 0)
{
sqlcmd = "select * from book where title like '%" + title + "%' and author like '%" + author + "%'";
}
else
{
sqlcmd = "select * from book where title like '%" + title + "%'";
}
//加载图书数据
conn.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(sqlcmd, conn);
DataSet dataset = new DataSet();
//使用SqlDataAdapter对象adapter将查新结果填充到DataSet对象ds中
adapter.Fill(dataset);
//设置DataSource属性
gridBook.DataSource = dataset.Tables[0];
//设置表头
gridBook.Columns[0].HeaderText = "id";
gridBook.Columns[1].HeaderText = "书名";
gridBook.Columns[2].HeaderText = "作者";
gridBook.Columns[3].HeaderText = "出版社";
gridBook.Columns[4].HeaderText = "馆藏";
gridBook.Columns[5].HeaderText = "剩余";
gridBook.Columns[6].HeaderText = "位置";
gridBook.ReadOnly = true;
//不允许添加行
gridBook.AllowUserToAddRows = false;
//背景为白色
gridBook.BackgroundColor = Color.White;
//只允许选中单行
gridBook.MultiSelect = false;
//整行选中
gridBook.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
}
catch (Exception ex)
{
MessageBox.Show("查询错误", "Tip", MessageBoxButtons.OK);
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
}
private void FillList()
{
gridBook.ColumnCount = 6;
gridBook.Columns[0].Name = "id";
gridBook.Columns[1].Name = "借书人";
gridBook.Columns[2].Name = "书名";
gridBook.Columns[3].Name = "借书日期";
gridBook.Columns[4].Name = "应还日期";
gridBook.Columns[5].Name = "还书日期";
gridBook.ReadOnly = true;
//不允许添加行
gridBook.AllowUserToAddRows = false;
//背景为白色
gridBook.BackgroundColor = Color.White;
//只允许选中单行
gridBook.MultiSelect = false;
//整行选中
gridBook.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
MySqlConnection conn = MysqlUtil.createConn();
try
{
//加载图书数据
string sqlcmd = "select * from user_book";
Console.WriteLine(sqlcmd);
conn.Open();
MySqlDataAdapter adapter = new MySqlDataAdapter(sqlcmd, conn);
DataSet dataset = new DataSet("User_Book");
//使用SqlDataAdapter对象adapter将查新结果填充到DataSet对象ds中
adapter.Fill(dataset);
conn.Close();
Console.WriteLine(dataset.Tables[0].Rows.Count);
// 填充表格
foreach (DataRow row in dataset.Tables[0].Rows)
{
string id = row["id"].ToString();
string bookId = row["book_id"].ToString();
string sqlcmd2 = "select title from book where id=" + bookId;
string sqlname = "select name from user where id=" + row["user_id"].ToString();
string book_name = "";
string user_name = "";
MySqlDataReader dr = MysqlUtil.search(sqlcmd2);
Console.WriteLine(row["book_id"].ToString());
if (!dr.Read())
{
MessageBox.Show("未知错误", "error", MessageBoxButtons.OK);
this.Close();
return;
}
else
{
book_name = dr[0].ToString();
Console.WriteLine(book_name);
}
MySqlDataReader namereader = MysqlUtil.search(sqlname);
if (!namereader.Read())
{
MessageBox.Show("未知错误", "error", MessageBoxButtons.OK);
this.Close();
return;
}
else
{
user_name = namereader[0].ToString();
}
string[] item = { id, user_name, book_name, row["borrow_time"].ToString(), row["revert_time"].ToString(), row["give_time"].ToString() };
gridBook.Rows.Add(item);
}
}
catch (Exception ex)
{
MessageBox.Show("查询错误", "Tip", MessageBoxButtons.OK);
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
}
/**
* 测试函数
*/
public static void test()
{
MySqlConnection conn = MysqlUtil.createConn();
Console.WriteLine("连接成功");
}
