数据库:MySQL
框架:控制台console
语言:c#
前面什么连接参看另一篇
C#:在控制台读取MySQL数据库,查询表中信息
直接上代码
插入
sqlcom.CommandText = "insert into ship_followinfo(Fid, Fusrid, Fshipid, Faddtime) values("+ship.Fid+ ", " + ship.Fusrid + "," + ship.Fshipid + "," + ship.Faddtime + ")";
int add = sqlcom.ExecuteNonQuery();
Console.WriteLine("影响行数:" + add);//查看返回值,为影响到的行数
/// <summary>
/// 执行数据库非查询操作,返回受影响的行数
/// </summary>
/// <param name="connectionString">数据库连接字符串</param>
/// <param name="cmdType">命令的类型</param>
/// <param name="cmdText">SqlServer存储过程名称或PL/SQL命令</param>
/// <param name="cmdParms">命令参数集合</param>
/// <returns>当前操作影响的数据行数</returns>
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] cmdParms)
{
SqlCommand cmd = new SqlCommand();
using (SqlConnection conn = new SqlConnection(connectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, cmdParms);
int val = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
return val;
}
}
这是插入一条船,你需要给它添加形参。
效果图
更新
sqlcom.CommandText = "update radar_shipinfo set FdTargetLon = " + ship.FdTargetLon + " , FdTargetLat = " + ship.FdTargetLat + " , FlastReportTime = " + ship.FlastReportTime + " where Fid = " + ship.Fid + "";
int modify = sqlcom.ExecuteNonQuery();
附加:RandomNumber()是随机数的方法,这里需要参看C#:生成随机数的方法