infomodeldb.java

学生信息管理系统 java + access

/**
the class for save date
**/

package com.javaseries.java.component;
import java.io.*;
import java.util.*;
import java.sql.*;
import java.text.*;
import com.javaseries.java.component.AccessDB_Bean;
//import AccessDB_Bean;

public class InfoModelDB
{
	AccessDB_Bean myData;
	String sno,name,sex,birthday,mophone,phone,department,address;
	
	public InfoModelDB()
		throws SQLException,ClassNotFoundException
		{
			this.myData=new AccessDB_Bean();
		}
	

		public InfoModelDB(String sno,String name,String sex,String birthday,String mophone,String phone,String department,String address)
		throws SQLException,ClassNotFoundException
		{
			this.sno=sno;
			this.name=name;
			this.sex=sex;
			this.birthday=birthday;
                        this.mophone=mophone;
                        this.phone=phone;
                        this.department=department;
                        this.address=address;
			
			this.myData=new AccessDB_Bean();
		}
		
		public void Insert() throws SQLException//插入一条新的学生记录（GUI版）
		{
			String sqlst="insert into students(sno,name,sex,birthday,mophone,phone,department,address) values('"+sno+"','"+name+"','"+sex+"','"+birthday+"','"+mophone+"','"+phone+"','"+department+"','"+address+"')";
			myData.executeDML(sqlst);
		}
		/*******************************/
		
	
	

	
			
		public void Load(File file)
			throws IOException,SQLException,FileNotFoundException
			{
				String sno=null;
				String name=null;
				String sex=null;
				String birthday=null;
				String department=null;
				String in;

				BufferedReader readStream=new BufferedReader(new FileReader(file));
				while((in=readStream.readLine())!=null)
				{//建立一行数据处理，建立词法分析流，分隔符使用"|"
					StringTokenizer st=new StringTokenizer(in,"|");
					sno=st.nextToken();
					name=st.nextToken();
					sex=st.nextToken();
					birthday=st.nextToken();
					department=st.nextToken();
					//形成sql语句
					String sqlst ="insert into students(sno,name,sex,birthday,department) values('"+sno+"','"+name+"','"+sex+"','"+birthday+"','"+department+"')";
					myData.executeDML(sqlst);
				}
			}
		
		public void SaveTo()
			throws IOException,SQLException,FileNotFoundException
			{
				String filename=null;
				BufferedReader readfilename=new BufferedReader(new InputStreamReader(System.in));
				System.out.println("请输入文件名:");
				filename=readfilename.readLine();
				
				BufferedWriter writeStream=new BufferedWriter(new FileWriter(filename));
				String sqlst="select * from students";
				ResultSet rc=myData.executeSelect(sqlst);
				
				while(rc.next())
				{
					writeStream.write(rc.getString("sno"));
					writeStream.write("|");
					writeStream.write(rc.getString("name"));
					writeStream.write("|");
					writeStream.write(rc.getString("sex"));
					writeStream.write("|");
					
					SimpleDateFormat fmt= new SimpleDateFormat("yyyy-MM-dd");
					String myDate=fmt.format(rc.getDate("birthday"));
					writeStream.write(myDate);
					writeStream.write("|");
					writeStream.write(rc.getString("department"));
					writeStream.newLine();
				}
				
				writeStream.close();
			}
			
			public ResultSet executeSelect(String sqlst)
			     throws SQLException
			     {
			     	return myData.executeSelect(sqlst);
			     }
			     
			 public void Delete() throws SQLException
			 {
			 	String sqlst="delete from students where sno='"+sno+"'";
			 	myData.executeDML(sqlst);
			 }
            public void Update() throws SQLException
			 {
			 
			 	String sqlst="update students set name='"+name+"',sex='"+sex+"',birthday='"+birthday+"',mophone='"+mophone+"',phone='"+phone+"',address='"+address+"',department='"+department+"'"+"where sno='"+sno+"'";
     	
     	
			 	myData.executeDML(sqlst);
			 }


}