java基础GUI+JDBC学生管理系统

解压后复制到编译器直接运行，通过登录login进行系统 基本涵盖GUI所有知识。仅能用于个人学习

 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个文件信息