DROP TABLE employee ;
CREATE TABLE employee(
id INT AUTO_INCREMENT PRIMARY KEY ,
name VARCHAR(30) NOT NULL ,
age INT NOT NULL ,
sex VARCHAR(2) DEFAULT '男' ,
birthday DATE
) ;
public class InsertDemo extends JFrame implements ActionListener {
Statement sm = null;
Connection ct = null;
ResultSet rs = null;
public static final String DBDRIVER="org.gjt.mm.mysql.Driver";
public static final String DBURL="jdbc:mysql://localhost:3306/mldn";
public static final String DBUSER="root";
public static fina
数据库脚本:DROP TABLE employee ;CREATE TABLE employee( id INT AUTO_INCREMENT PRIMARY KEY , name VARCHAR(30) NOT NULL , age INT NOT NULL , sex VARCHAR(2) DEFAULT '男' , birthday DATE ) ;