用代码的方式创建教师表和学生表

      之前的管理系统都是先在数据库上建好相应的列表后再进行操作的，现在用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>

  

 

      至于后面的添加、删除、查询等操作就如学生管理系统操作一样。