pycharm增删改查
时间: 2023-12-21 16:31:33 浏览: 30
以下是在PyCharm中进行增删改查的示例代码:
1. 连接数据库:
```python
import pymysql
# 连接数据库
db = pymysql.Connect(host='10.36.151.86', user='root', password='123456', database='test1db')
```
2. 查询数据:
```python
# 创建一个游标
cursor = db.cursor()
# SQL语句
sql = "SELECT * FROM person"
try:
# 执行SQL语句
cursor.execute(sql)
# 获取所有结果
results = cursor.fetchall()
# 打印结果
for row in results:
print(row)
except pymysql.Error as e:
print(e)
# 关闭游标和数据库连接
cursor.close()
db.close()
```
3. 插入数据:
```python
# 创建一个游标
cursor = db.cursor()
# SQL语句
sql = "INSERT INTO person(name, age, info) VALUES('二哈', 18, '我家有只小二哈')"
try:
# 执行SQL语句
cursor.execute(sql)
# 提交事务
db.commit()
except pymysql.Error as e:
print(e)
# 若出现错误,则回滚
db.rollback()
# 关闭游标和数据库连接
cursor.close()
db.close()
```
4. 更新数据:
```python
# 创建一个游标
cursor = db.cursor()
# SQL语句
sql = "UPDATE person SET age = 20 WHERE id = 1"
try:
# 执行SQL语句
cursor.execute(sql)
# 提交事务
db.commit()
except pymysql.Error as e:
print(e)
# 若出现错误,则回滚
db.rollback()
# 关闭游标和数据库连接
cursor.close()
db.close()
```
5. 删除数据:
```python
# 创建一个游标
cursor = db.cursor()
# SQL语句
sql = "DELETE FROM person WHERE id = 1"
try:
# 执行SQL语句
count = cursor.execute(sql)
# 打印受影响行数
print(count)
# 提交事务
db.commit()
except pymysql.Error as e:
print(e)
# 若出现错误,回滚
db.rollback()
# 关闭游标和数据库连接
cursor.close()
db.close()
```