c# mysql增删改查
来源:互联网 发布:sky 知乎日报 编辑:程序博客网 时间:2024/05/16 02:42
ExecuteNonQuery 不返回任何行,但映射到参数的任何输出参数或返回值都会用数据进行填充。
对于 UPDATE、INSERT 和 DELETE 语句,返回值为该命令所影响的行数。
对于所有其他类型的语句,返回值为 -1。
如果发生回滚,返回值也为 -1
String mysqlStr = "Database=test;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306";
// String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;
MySqlConnection mysql = new MySqlConnection ( mysqlStr );
MySqlCommand mySqlCommand = new MySqlCommand ( sql, mysql );
mySqlCommand.ExecuteNonQuery();
String sqlSearch = "select * from student";
//插入sql
String sqlInsert = "insert into student values (12,'张三',25,'大专')";
//修改sql
String sqlUpdate = "update student set name='李四' where id= 3";
//删除sql
String sqlDel = "delete from student where id = 12";
MySqlCommand mySqlCommand = new MySqlCommand ( sql, mysql );
public static void getResultset ( MySqlCommand mySqlCommand )
{
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while ( reader.Read() )
{
if ( reader.HasRows )
{
Console.WriteLine ( "编号:" + reader.GetInt32 ( 0 ) + "|姓名:" + reader.GetString ( 1 ) + "|年龄:" + reader.GetInt32 ( 2 ) + "|学历:" + reader.GetString ( 3 ) );
}
}
}
catch ( Exception )
{
Console.WriteLine ( "查询失败了!" );
}
finally
{
reader.Close();
}
}
对于 UPDATE、INSERT 和 DELETE 语句,返回值为该命令所影响的行数。
对于所有其他类型的语句,返回值为 -1。
如果发生回滚,返回值也为 -1
String mysqlStr = "Database=test;Data Source=127.0.0.1;User Id=root;Password=root;pooling=false;CharSet=utf8;port=3306";
// String mySqlCon = ConfigurationManager.ConnectionStrings["MySqlCon"].ConnectionString;
MySqlConnection mysql = new MySqlConnection ( mysqlStr );
MySqlCommand mySqlCommand = new MySqlCommand ( sql, mysql );
mySqlCommand.ExecuteNonQuery();
String sqlSearch = "select * from student";
//插入sql
String sqlInsert = "insert into student values (12,'张三',25,'大专')";
//修改sql
String sqlUpdate = "update student set name='李四' where id= 3";
//删除sql
String sqlDel = "delete from student where id = 12";
MySqlCommand mySqlCommand = new MySqlCommand ( sql, mysql );
public static void getResultset ( MySqlCommand mySqlCommand )
{
MySqlDataReader reader = mySqlCommand.ExecuteReader();
try
{
while ( reader.Read() )
{
if ( reader.HasRows )
{
Console.WriteLine ( "编号:" + reader.GetInt32 ( 0 ) + "|姓名:" + reader.GetString ( 1 ) + "|年龄:" + reader.GetInt32 ( 2 ) + "|学历:" + reader.GetString ( 3 ) );
}
}
}
catch ( Exception )
{
Console.WriteLine ( "查询失败了!" );
}
finally
{
reader.Close();
}
}
0 0
- c# mysql增删改查
- c# 连接mysql 增删改查操作
- C# Mysql 增删改查示例
- mysql增删改查
- MySQL增删改查
- MYSQL增删改查
- MySQL增删改查
- mysql增删改查
- MySQL---增删改查
- MySQL增删改查
- mysql 增删改查
- mysql 增删改查
- mysql增删改查
- mysql增删查改
- Mysql增删改查
- mysql增删改查
- MySQL 增删改查
- mysql增删改查
- codeforces 680C Bear and Prime 100
- android --pull解析
- gnu C语言__attribute__作用
- python challenge 学习
- ATOM基础教程一ATOM插件(3)
- c# mysql增删改查
- HTML5+规范:gallery(管理系统相册)
- 树莓派使用小结
- Mybatis的注解应用之映射声明
- python切片的使用
- Android中编辑打电话
- php 部署到heroku上
- Jsoup
- redis列表操作