学点儿c#语言wpf开发

最新推荐文章于 2024-01-24 12:46:01 发布

weixin_34007906

最新推荐文章于 2024-01-24 12:46:01 发布

阅读量114

点赞数

文章标签：数据库 json python

原文链接：https://my.oschina.net/u/866216/blog/524068

版权

为什么80%的码农都做不了架构师？>>>

首发：个人博客，更新&纠错&回复

visual studio 2015，界面越来越漂亮了。

比起swift和python啥的，还是c#外观上更像java，windows的界面编程，wpf的方式跟android等编程也蛮像，声明式的界面定义，界面和controller类当然绑定，总之玩着很爽就是了。

现在在想的问题是想个啥主题做着……

下面的代码是学习关键点时练的，老规矩，界面交互+web请求+数据库访问——

using MySql.Data.MySqlClient;
using qdf_test_wpf_1;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;

namespace WpfApplication2
{
/// <summary>
/// MainWindow.xaml 的交互逻辑
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
}

private void button_Click(object sender, RoutedEventArgs e)
{

//进行web请求
HttpWebRequest httpRequest = (HttpWebRequest)WebRequest.Create("http://427studio.net/api/blog");
httpRequest.Timeout = 2000;
httpRequest.Method = "GET";
HttpWebResponse httpResponse = (HttpWebResponse)httpRequest.GetResponse();
StreamReader sr = new StreamReader(httpResponse.GetResponseStream(), System.Text.Encoding.GetEncoding("utf-8"));
string result = sr.ReadToEnd();
result = result.Replace("\r", "").Replace("\n", "").Replace("\t", "");
int status = (int)httpResponse.StatusCode;
sr.Close();

//解析json
List<Person> ps = JSON.parse<List<Person>>(result);
foreach (Person p in ps)
{
Console.WriteLine(p.title);
}
jsonCount.Content = "js数组长度：" + ps.Count();

//数据库连接
string str = "Server=那啥;User ID=那啥;Password=那啥;Database=那啥;CharSet=那啥;";
MySqlConnection conn = new MySqlConnection(str);//实例化链接
conn.Open();//开启连接
string strcmd = "select id, name from admin_user";
MySqlCommand cmd = new MySqlCommand(strcmd, conn);
MySqlDataReader reader = cmd.ExecuteReader();
int rowCount = 0;
while (reader.Read())
{
String title = reader.GetString("name");
//Console.WriteLine(title);

rowCount++;
}
dbCount.Content = "数据库记录行数：" + rowCount;
reader.Close();
conn.Close();

//文件系统
FileStream fs = new FileStream("test.txt", FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(fs);
sw.Write("由wpf程序写入！");
sw.Close();
}
}
}