|
System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SQLite;
using System.Data.Common;
namespace WM
{
class SQLHelper
{
//建库
public DbConnection getCon()
{
DbConnection con =
new SQLiteConnection();
con.ConnectionString =
"Data Source=WebMan.db";
return con;
}
//建表
public
void CreateWebTable(DbConnection con)
{
con.Open();
try
{
using (DbCommand com = con.CreateCommand())
{
com.CommandText =
"create table webtable( id integer primary key,username varchar(20),qiyename varchar(50),webname varchar(50),tel varchar(20),lianxiren varchar(20),fufeidate varchar(10),daoqidate varchar(10),price varchar(10),status varchar(10),yewuyuan varchar(15),mark varchar(50))";
com.ExecuteNonQuery();
com.CommandText =
"create table yewutable( id integer primary key,num varchar(20),workername varchar(20),gender varchar(5),age varchar(5),bear varchar(10),fromwhere varchar(60),mark varchar(50))";
com.ExecuteNonQuery();
com.CommandText =
"create table usertable( id integer primary key,pwd varchar(20))";
com.ExecuteNonQuery();
}
}
catch (Exception)
{
}
}
//查询
public DataSet Query(DbConnection con,string sql)
{
DataSet ds =
new DataSet();
DbDataAdapter da =
new SQLiteDataAdapter(sql,(SQLiteConnection)con);
da.Fill(ds);
return ds;
}
//其它操作
public
int Control(DbConnection con,string sql)
{
int i = 0;
using (DbCommand com = con.CreateCommand())
{
com.CommandText = sql;
i = com.ExecuteNonQuery();
}
return i;
}
}
}
（编辑：李大同）
【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
|
