连接数据库
import pymysql
conn = pymysql.connect(hostm'localhost ' ,user m "root" , passwd = "123456" ,db = "Test")
cursor=conn.cursor()
print(cursor)
cursor.execute( " drop table if exists user ")
sql=”""CREATE TABLE IF NOT EXISTS "user'(
`id` int(11)NOT NULL AUTO_INCREMENT,name’varchar(255) NOT NULL,
'age int(11] NOT NULL,
PRINMARY KEY ('id`)
ENGINE=InnoDB DEFAULT CHARSET=utf8 AUT0_INCRENENT=0""
cursor.executeisal)
gpio
#include <linux/gpio.h>
#include <linux/init.h>
#include <linux/interrupt.h>
#include <linux/module.h>
#define BUTTON_PIN 12 /* GPIO 12 */
#define LED_PIN 21 /* GPIO 21 */
int flag = 0;
static irqreturn_t irq_handler(int irq, void *dev)
{
int curr_val;
printk("%s()\n", __FUNCTION__);
curr_val = gpio_get_value(LED_PIN);
gpio_set_value(LED_PIN, !curr_val);
return IRQ_HANDLED;
}
static int led_init(void)
{
int err;
int irq;
printk("%s()\n", __FUNCTION__);
err = gpio_request_one(BUTTON_PIN, GPIOF_IN, "Button");
if (err)