?package?Dao;

import?java.sql.Connection;
import?java.sql.SQLException;
import?java.sql.Statement;

import?Daoimpl.AddStudent;
import?sun.applet.Main;

public?class?CreateTable?{

	public?CreateTable（）{
		DBconnector?conn=new?DBconnector（）;
		Connection?con=conn.getConnection（）;
		if（con!=null）
		System.out.println（“數據庫連接成功“）;
		try?{
			Statement?stmt=con.createStatement（）;
			String?sql1=“create?table?students“
					+?“（id?int（11）?primary?key“
					+?“password?varchar（10）?default?123456“
					+?“name?varchar（10）“
					+?“sex?varchar（4）“
					+?“birthday?varchar（15）“
					+?“clas?varchar?（15）“
					+?“school?varchar（20））;“;
			String?sql2=“create?table?teacher“
					+?“（name?varchar（10）?primary?key“
					+?“password?varchar（10））;“;
			String?sql=“insert?into?teacher（namepassword）?“
					+?“values（‘teacher‘‘654321‘）“;
			String?sql3=“create?table?grade“
					+?“（sid?int（11）?primary?key“
					+?“name?varchar（10）“
					+?“sex?varchar（4）“
					+?“clas?varchar?（15）“
					+?“math?int（3）“
					+?“chinese?int（3））;“;
			stmt.executeUpdate（sql1）;
			stmt.executeUpdate（sql2）;
			stmt.executeUpdate（sql）;
			stmt.executeUpdate（sql3）;
			
			System.out.println（“表建立完成“）;
			stmt.close（）;
			con.close（）;
			
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
			
		}
		
	}
	public?static?void?main（String[]?args）?{
		new?CreateTable（）;
	}
}

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????389??2018-04-17?16:11??Curriculum?design\.classpath

?????文件????????393??2018-04-17?14:55??Curriculum?design\.project

?????文件????????598??2018-04-17?14:55??Curriculum?design\.settings\org.eclipse.jdt.core.prefs

?????文件???????1823??2018-11-30?13:38??Curriculum?design\bin\Dao\CreateTable.class

?????文件???????1376??2018-11-30?13:38??Curriculum?design\bin\Dao\DBconnector.class

?????文件????????304??2018-11-30?13:38??Curriculum?design\bin\Dao\Jiekou.class

?????文件????????626??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\AddGrade$1.class

?????文件???????5766??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\AddGrade.class

?????文件????????638??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\AddStudent$1.class

?????文件???????5873??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\AddStudent.class

?????文件????????656??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\DeleteStudent$1.class

?????文件???????4264??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\DeleteStudent.class

?????文件????????639??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetGrade$1.class

?????文件???????5206??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetGrade.class

?????文件????????645??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetGrades$1.class

?????文件???????3635??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetGrades.class

?????文件????????651??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetStudent$1.class

?????文件???????5664??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetStudent.class

?????文件????????657??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetStudents$1.class

?????文件???????3482??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\GetStudents.class

?????文件???????1279??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\ImpleDao.class

?????文件????????631??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\Login$1.class

?????文件???????4817??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\Login.class

?????文件????????656??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\StudentManage$1.class

?????文件???????4046??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\StudentManage.class

?????文件????????644??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\UpdateGrade$1.class

?????文件???????4767??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\UpdateGrade.class

?????文件????????656??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\UpdateStudent$1.class

?????文件???????5724??2018-11-30?13:38??Curriculum?design\bin\Daoimpl\UpdateStudent.class

?????文件????????625??2018-11-30?13:38??Curriculum?design\bin\Daoimpl1\Student$1.class

............此處省略47個文件信息