dbcreater.java

一个可以存储和打印成绩单的系统

package org.minjey.cjsjk.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;

import org.minjey.cjsjk.model.Admin;
import org.minjey.cjsjk.model.ExamType;
import org.minjey.cjsjk.model.MajorLength;
import org.minjey.cjsjk.model.MajorRecord;
import org.minjey.cjsjk.model.MajorType;
import org.minjey.cjsjk.model.StudentStatue;
import org.signsmile.view.util.MD5;


public class DBCreater {
	public void createNewDB(String driver, String protocol, String dbname, String username, String password) {
		System.out.println("Attempt To Create New DataBase:" + dbname + ".");
		try {
            Class.forName(driver).newInstance();
            
            Properties props = new Properties();
            props.put("user", username);
            props.put("password", password);
            
            Connection conn = DriverManager.getConnection(protocol + dbname + ";create=true", props);
            Statement s = conn.createStatement();
            
            s.execute(SQLDict.TSTACTION);	//建立station表
            s.execute(SQLDict.TENROLLTIME);	//建立enrolltime表
            s.execute(SQLDict.TMAJORRECORD);	//建立majorrecord表
            s.execute(SQLDict.TMAJORTYPE);	//建立majortype表
            s.execute(SQLDict.TMAJORLENGTH);	//建立majorlength表
            s.execute(SQLDict.TMAJOR);	//建立major表
            s.execute(SQLDict.TEXAMTYPE);	//建立examtype表
            s.execute(SQLDict.TCOURSE);	//建立course表
            s.execute(SQLDict.TSTUDENTSTATUE); //建立studentstatue表
            s.execute(SQLDict.TSTUDENT);	//建立student表
            s.execute(SQLDict.TSTUDENTCOURSE);	//建立studentcourse表
            
            s.execute(SQLDict.TADMIN);	//建立用户表
            s.execute(SQLDict.TCHECK);	//建立版本检测表
			
            s.execute(SQLDict.IMAJORSTATION);	//建立索引
            s.execute(SQLDict.IMAJORINROLLTIME);
            s.execute(SQLDict.IMAJORMAJORRECORD);
            s.execute(SQLDict.IMAJORMAJORTYPE);
            s.execute(SQLDict.ICOURSEMAJOR);
            s.execute(SQLDict.ISTUDENTMAJOR);
            
            
            s.close();
            conn.close();
            
        } catch (ClassNotFoundException cnfe) {
            cnfe.printStackTrace();
        } catch (InstantiationException ie) {
            ie.printStackTrace();
        } catch (IllegalAccessException iae) {
            iae.printStackTrace();
        } catch (SQLException se) {
			se.printStackTrace();
		}
        System.out.println("New DataBase: " + dbname + " Created.");
        
        
	}
	
	public void prepareDefaultData() {
		Dao dao = Dao.getDao();
		
		ExamType et = new ExamType();
		et.setName("考核");
		dao.save(et);
		et.setName("考查");
		dao.save(et);
		
		MajorLength ml = new MajorLength();
		ml.setLength(4);
		dao.save(ml);
		ml.setLength(5);
		dao.save(ml);
		ml.setLength(6);
		dao.save(ml);
		ml.setLength(8);
		dao.save(ml);
		ml.setLength(10);
		dao.save(ml);
		
		MajorRecord mr = new MajorRecord();
		mr.setName("专升本");
		dao.save(mr);
		mr.setName("高起专");
		dao.save(mr);
		mr.setName("高起本");
		dao.save(mr);
		
		MajorType mt = new MajorType();
		mt.setName("函授");
		dao.save(mt);
		mt.setName("业大");
		dao.save(mt);
		mt.setName("脱产");
		dao.save(mt);
		
		StudentStatue ss = new StudentStatue();
		ss.setName("未毕业");
		dao.save(ss);
		ss.setName("已毕业");
		dao.save(ss);
		
		Admin admin = new Admin();
		admin.setUsername("admin");
		MD5 md = new MD5();
		String pwd = md.md5s("123456");
		admin.setPassword(pwd);
		dao.save(admin);
	}
	
	public static void main(String[] args) {
		String driver = "org.apache.derby.jdbc.EmbeddedDriver";
		String protocol = "jdbc:derby:";
		String dbname = "Cjsjk";
		String username = "admin";
		String password = "admin";
		new DBCreater().createNewDB(driver, protocol, dbname, username, password);
	}
}