之前的管理系统都是先在数据库上建好相应的列表后再进行操作的,现在用Java程序来创建列表,其代码如下:
<span style="font-size:18px;">import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import com.mysql.jdbc.Statement;
public class Stud {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/manager?characterEncoding=UTF-8";
//?characterEncoding=UTF-8 作用是讲数据库编码转换成制定的编码,此处是转换成UTF-8
String user = "root";
String password = "a123";
try {
Class.forName(driver);
Connection con = DriverManager.getConnection(url, user, password);
Statement s = (Statement) con.createStatement();
// 创建数据库
String str0 = "create database stumanager CHARSET=utf8";
s.execute(str0);
// 连接数据库
String setDate = "use stumanager";
s.execute(setDate);
// 添加学生数据表
String str = "CREATE TABLE student ( "
+ "id int(2) NOT NULL AUTO_INCREMENT, "
+ "number int(2) DEFAULT NULL, "
+ "name varchar(20) DEFAULT NULL, "
+ "sex char(2) DEFAULT NULL, "
+ "age int(3) DEFAULT NULL, PRIMARY KEY (id)"
+ ") ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8";
s.execute(str);
// 添加教师数据表
String tch = "CREATE TABLE teacher( "
+ "id int(2) NOT NULL AUTO_INCREMENT, "
+ "number int(2) DEFAULT NULL,"
+ "password varchar(10) DEFAULT NULL,PRIMARY KEY (id)"
+ ") ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8";
s.execute(tch);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
</span>
至于后面的添加、删除、查询等操作就如学生管理系统操作一样。