this.textBox1.Text = "中山"; this.bSetCity2.Text = "查询中..."; callWeatherService(); showTodayWeather(); getFromSer();
this.bSetCity2.Text = "中山";
this.button1.Enabled = true; this.button2.Enabled = true; this.button3.Enabled = true; //this.bReadDB.Enabled = true; }
private void bReadDB_Click(object sender, EventArgs e) {
readDB();
this.button1.Enabled = true; this.button2.Enabled = true; this.button3.Enabled = true; }
WinCE下的数据源操作以及天气软件的制作
//---------------------数据库部分
//创建本地数据库
private void setData(string[] hello) {
if (System.IO.File.Exists(dbPath)) System.IO.File.Delete(@dbPath);//删除原文件 if (!System.IO.File.Exists(dbPath)) {
System.Data.SQLite.SQLiteConnection.CreateFile(dbPath);//创建数据库文件
//连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
conn.ConnectionString = "data source=" + dbPath; conn.Open();
//创建表
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); string sql = "CREATE TABLE weather(province varchar(20),city varchar(20),date1 varchar(20),tem1 varchar(20),wind1 varchar(20),pic1 varchar(20),date2 varchar(20),tem2 varchar(20),wind2 varchar(20),pic2 varchar(20),date3 varchar(20),tem3 varchar(20),wind3 varchar(20),pic3 varchar(20))"; mandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery();
//插入数据
sql = "INSERT INTO weather VALUES('" + hello[0] + "','" + hello[1] + "','" + hello[2] + "','" + hello[3] + "','" + hello[4] + "','" + hello[5] + "','" + hello[6] + "','" + hello[7] + "','" + hello[8] + "','" + hello[9] + "','" + hello[10] + "','" + hello[11] + "','" + hello[12] + "','" + hello[13] + "');";
mandText = sql; cmd.ExecuteNonQuery();
MessageBox.Show("创建本地数据库:" + dbPath); conn.Close();
System.Data.SQLite.SQLiteConnection.ClearAllPools();
} }
WinCE下的数据源操作以及天气软件的制作
//服务器的数据信息存到数组中 private void getFromSer() {
string[] hello = new string[15]; hello[0] = array[0]; hello[1] = array[1]; hello[2] = array[6]; hello[3] = array[5]; hello[4] = array[7]; hello[5] = array[8]; hello[6] = array[13]; hello[7] = array[12]; hello[8] = array[14]; hello[9] = array[15]; hello[10] = array[18]; hello[11] = array[17]; hello[12] = array[19]; hello[13] = array[20]; setData(hello); }
private void readDB()//读取本地数据库 {
if (System.IO.File.Exists(dbPath)) {
this.bReadDB.Text= "读取ing"; //连接数据库
System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
conn.ConnectionString = "data source=" + dbPath; conn.Open();
System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand(); cmd.Connection = conn;
//取出数据
string sql = "SELECT * FROM weather"; mandText = sql;
System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader(); StringBuilder sb = new StringBuilder(); while (reader.Read()) {
sb.Append(reader.GetString(0)).Append(":")
WinCE下的数据源操作以及天气软件的制作
.Append(reader.GetString(1)).Append(":") .Append(reader.GetString(2)).Append(":") .Append(reader.GetString(3)).Append(":") .Append(reader.GetString(4)).Append(":") .Append(reader.GetString(5)).Append(":") .Append(reader.GetString(6)).Append(":") .Append(reader.GetString(7)).Append(":") .Append(reader.GetString(8)).Append(":") .Append(reader.GetString(9)).Append(":") .Append(reader.GetString(10)).Append(":") .Append(reader.GetString(11)).Append(":") .Append(reader.GetString(12)).Append(":") .Append(reader.GetString(13)).Append(":"); }
string[] hello = sb.ToString().Split(':');
array[0] = hello[0]; array[1] = hello[1];
array[6] = hello[2]; array[5] = hello[3]; array[7] = hello[4]; array[8] = hello[5];