从浮点数字符串解析整数
本文关键字:整数 字符串 浮点数 | 更新日期: 2023-09-27 18:32:43
我已经设法通过RS232从温度传感器获取值。预期值将添加到数据库中以供进一步操作。这是代码。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using MySql.Data.MySqlClient;
using System.IO.Ports;
namespace SimpleSerial
{
public partial class Form1 : Form
{
// Add this variable
MySqlConnection conn = null;
float tempvalue;
string RxString;
public Form1()
{
InitializeComponent();
}
public void dbconnect()
{
string cs = @"server=xxx.x.x.xx;userid=uuuuuu;password=xxxxx;database=project";
try
{
conn = new MySqlConnection(cs);
conn.Open();
MySqlCommand cmd = new MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO temp(value) VALUES(@value) ";
cmd.Prepare();
cmd.Parameters.AddWithValue("@value", tempvalue);
cmd.ExecuteNonQuery();
//Console.WriteLine("MySQL version : {0}", conn.ServerVersion);
//MessageBox.Show("DB Connected");
}
catch (MySqlException ex)
{
Console.WriteLine("Error: {0}", ex.ToString());
MessageBox.Show("Error: {0}", ex.ToString());
}
finally
{
if (conn != null)
{
conn.Close();
}
}
}
private void buttonStart_Click(object sender, EventArgs e)
{
serialPort1.PortName = "COM2";
serialPort1.BaudRate = 9600;
serialPort1.Open();
if (serialPort1.IsOpen)
{
buttonStart.Enabled = false;
buttonStop.Enabled = true;
textBox1.ReadOnly = false;
}
}
private void buttonStop_Click(object sender, EventArgs e)
{
if (serialPort1.IsOpen)
{
serialPort1.Close();
buttonStart.Enabled = true;
buttonStop.Enabled = false;
textBox1.ReadOnly = true;
}
}
private void Form1_FormClosing(object sender, FormClosingEventArgs e)
{
if (serialPort1.IsOpen) serialPort1.Close();
}
private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
// If the port is closed, don't try to send a character.
if (!serialPort1.IsOpen) return;
// If the port is Open, declare a char[] array with one element.
char[] buff = new char[1];
// Load element 0 with the key character.
buff[0] = e.KeyChar;
// Send the one character buffer.
serialPort1.Write(buff, 0, 1);
// Set the KeyPress event as handled so the character won't
// display locally. If you want it to display, omit the next line.
e.Handled = true;
}
private void DisplayText(object sender, EventArgs e)
{
tempvalue = float.Parse(RxString);
dbconnect();
textBox1.AppendText(RxString);
}
private void serialPort1_DataReceived(object sender, System.IO.Ports.SerialDataReceivedEventArgs e)
{
RxString = serialPort1.ReadExisting();
this.Invoke(new EventHandler(DisplayText));
}
}
}
请注意:
tempvalue = float.Parse(RxString);
dbconnect();
textBox1.AppendText(RxString);
是我想操纵的价值。电流输出类似于 56.1234557.4323253.34221 。感兴趣的值是每个"."后面的两位数字。我想得到这个值有 56 57 53 等。我已经尝试过,它似乎不是这里的最佳选择。由于它来自串行端口,因此读取值的方式使我感到有些困惑。有没有办法将 XX.DDDDD 中的 X 和 D 分开并使用 XX 填充数据库?我试过RxString.Split('.')
.也许我做得不对。有人好心帮忙。谢谢
您可以使用正则表达式提取字符串中有趣的部分
MatchCollection matches =
Regex.Matches("56.1234557.4323253.34221", @"'d'd(?='.)");
foreach (Match match in matches) {
Console.WriteLine(match.Value);
}
我使用了正则表达式模式find(?=suffix)
它匹配后缀之前的位置。 'd'd
匹配两位数,'.
匹配小数点。
string[] values = RxString.Split(new Char[] {','});
foreach(String value in values)
{
string[] parts = value.Split(new char[] {'.'});
if (parts.Length == 2)
{
int v;
if (int.TryParse(parts[0], out v))
{
// do something with v
}
}
}
如果我得到你。