.net插入可以用对象吗 什么才能实现和java一样 本帖最后由 liangchengfck1 于 2012-11-01 13:41:23 编辑 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 mvc模式刚看 没怎么深入 .net MVC模式保存数据和java样save(对象吗)就好了吗求个mvc模式怎么保存数据的demo案例 搜索一下 SqlParameter 的用法 你就明白了先从最基础的 ADO.NET 学起吧然后可以 学一下 ORM 如Entity Framework 或者 NHibernate 大哥你说的是这个吗 就是因为用MySqlParameter才感觉代码多 public static bool RegisterUser(user model){ string sql = "insert into user(username,userpwd,sex,picture,IM,information,others,ifisuser) values (@username,@userpwd,@sex,@picture,@IM,@information,@others,@ifisuser)"; MySqlParameter[] parameters = { new MySqlParameter("@username", model.username), new MySqlParameter("@userpwd", model.userpwd), new MySqlParameter("@sex", model.sex), new MySqlParameter("@picture", model.picture), new MySqlParameter("@IM", model.IM), new MySqlParameter("@information", model.information), new MySqlParameter("@others", model.others), new MySqlParameter("@ifisuser", model.ifisuser) }; return MySqlHelper.ExecuteNonQuery(DBHelper.con, sql, parameters) > 0; } 上面的代码是用 ‘懒人专用’写的贴子 叫什么 用mysql的同学有福了什么什么的 用了下感觉还行 原本代码是这样的 MySqlParameter[] parameters = { new MySqlParameter("@username", MySqlDbType.VarChar,255), new MySqlParameter("@userpwd", MySqlDbType.VarChar,255), new MySqlParameter("@sex", MySqlDbType.VarChar,255), new MySqlParameter("@picture", MySqlDbType.VarChar,255), new MySqlParameter("@IM", MySqlDbType.VarChar,255), new MySqlParameter("@information", MySqlDbType.VarChar,255), new MySqlParameter("@others", MySqlDbType.VarChar,255), new MySqlParameter("@ifisuser", MySqlDbType.VarChar,255) }; parameters[0].Value = model.username; parameters[1].Value = model.userpwd; parameters[2].Value = model.sex; parameters[3].Value = model.picture; parameters[4].Value = model.IM; parameters[5].Value = model.information; parameters[6].Value = model.others; parameters[7].Value = model.ifisuser;现在改成 MySqlParameter[] parameters = { new MySqlParameter("@username", model.username), new MySqlParameter("@userpwd", model.userpwd), new MySqlParameter("@sex", model.sex), new MySqlParameter("@picture", model.picture), new MySqlParameter("@IM", model.IM), new MySqlParameter("@information", model.information), new MySqlParameter("@others", model.others), new MySqlParameter("@ifisuser", model.ifisuser)能简单就简单嘛 上面的代码是用 ‘懒人专用’写的贴子 叫什么 用mysql的同学有福了什么什么的 用了下感觉还行 原本代码是这样的 MySqlParameter[] parameters = {new MySqlParameter("@username", MySqlDbType.VarChar,255),new MySqlParameter("@userpwd", MySqlDbType.VarChar,255),new MySqlParameter("@sex", MySqlDbType.VarChar,255),new MySqlParameter("@picture", MySqlDbType.VarChar,255),new MySqlParameter("@IM", MySqlDbType.VarChar,255),new MySqlParameter("@information", MySqlDbType.VarChar,255),new MySqlParameter("@others", MySqlDbType.VarChar,255),new MySqlParameter("@ifisuser", MySqlDbType.VarChar,255)}; parameters[0].Value = model.username; parameters[1].Value = model.userpwd; parameters[2].Value = model.sex; parameters[3].Value = model.picture; parameters[4].Value = model.IM; parameters[5].Value = model.information; parameters[6].Value = model.others; parameters[7].Value = model.ifisuser;现在改成 MySqlParameter[] parameters = { new MySqlParameter("@username", model.username), new MySqlParameter("@userpwd", model.userpwd), new MySqlParameter("@sex", model.sex), new MySqlParameter("@picture", model.picture), new MySqlParameter("@IM", model.IM), new MySqlParameter("@information", model.information), new MySqlParameter("@others", model.others), new MySqlParameter("@ifisuser", model.ifisuser)能简单就简单嘛 html img怎么运行后台程序 .net怎么从string中提取中文 这个,有点意思,无聊的时候可以看看 谁有手机号码段归属地数据库??发给我一份 马上给分! asp.net输入长长的JAVASCRIPT 请教几个正则表达式!! ASP.NET图片上传并显示问题 问高手一个问题 新手问题--(因为它受保护级别限制) 为什么我的。Net Framework安装不上去? 提交以后,public变量的值怎么会不在了呢? 如何使用XML数据库
求个mvc模式怎么保存数据的demo案例
先从最基础的 ADO.NET 学起吧
然后可以 学一下 ORM 如Entity Framework 或者 NHibernate
public static bool RegisterUser(user model){ string sql = "insert into user(username,userpwd,sex,picture,IM,information,others,ifisuser) values (@username,@userpwd,@sex,@picture,@IM,@information,@others,@ifisuser)";
MySqlParameter[] parameters = {
new MySqlParameter("@username", model.username),
new MySqlParameter("@userpwd", model.userpwd),
new MySqlParameter("@sex", model.sex),
new MySqlParameter("@picture", model.picture),
new MySqlParameter("@IM", model.IM),
new MySqlParameter("@information", model.information),
new MySqlParameter("@others", model.others),
new MySqlParameter("@ifisuser", model.ifisuser)
};
return MySqlHelper.ExecuteNonQuery(DBHelper.con, sql, parameters) > 0; }
原本代码是这样的
MySqlParameter[] parameters = {
new MySqlParameter("@username", MySqlDbType.VarChar,255),
new MySqlParameter("@userpwd", MySqlDbType.VarChar,255),
new MySqlParameter("@sex", MySqlDbType.VarChar,255),
new MySqlParameter("@picture", MySqlDbType.VarChar,255),
new MySqlParameter("@IM", MySqlDbType.VarChar,255),
new MySqlParameter("@information", MySqlDbType.VarChar,255),
new MySqlParameter("@others", MySqlDbType.VarChar,255),
new MySqlParameter("@ifisuser", MySqlDbType.VarChar,255)
};
parameters[0].Value = model.username;
parameters[1].Value = model.userpwd;
parameters[2].Value = model.sex;
parameters[3].Value = model.picture;
parameters[4].Value = model.IM;
parameters[5].Value = model.information;
parameters[6].Value = model.others;
parameters[7].Value = model.ifisuser;
现在改成
MySqlParameter[] parameters = {
new MySqlParameter("@username", model.username),
new MySqlParameter("@userpwd", model.userpwd),
new MySqlParameter("@sex", model.sex),
new MySqlParameter("@picture", model.picture),
new MySqlParameter("@IM", model.IM),
new MySqlParameter("@information", model.information),
new MySqlParameter("@others", model.others),
new MySqlParameter("@ifisuser", model.ifisuser)
能简单就简单嘛
原本代码是这样的
MySqlParameter[] parameters = {
new MySqlParameter("@username", MySqlDbType.VarChar,255),
new MySqlParameter("@userpwd", MySqlDbType.VarChar,255),
new MySqlParameter("@sex", MySqlDbType.VarChar,255),
new MySqlParameter("@picture", MySqlDbType.VarChar,255),
new MySqlParameter("@IM", MySqlDbType.VarChar,255),
new MySqlParameter("@information", MySqlDbType.VarChar,255),
new MySqlParameter("@others", MySqlDbType.VarChar,255),
new MySqlParameter("@ifisuser", MySqlDbType.VarChar,255)
};
parameters[0].Value = model.username;
parameters[1].Value = model.userpwd;
parameters[2].Value = model.sex;
parameters[3].Value = model.picture;
parameters[4].Value = model.IM;
parameters[5].Value = model.information;
parameters[6].Value = model.others;
parameters[7].Value = model.ifisuser;
现在改成
MySqlParameter[] parameters = {
new MySqlParameter("@username", model.username),
new MySqlParameter("@userpwd", model.userpwd),
new MySqlParameter("@sex", model.sex),
new MySqlParameter("@picture", model.picture),
new MySqlParameter("@IM", model.IM),
new MySqlParameter("@information", model.information),
new MySqlParameter("@others", model.others),
new MySqlParameter("@ifisuser", model.ifisuser)
能简单就简单嘛