adduser.java

利用JAVA和Access做成一个学生信息管理系统

//新建用户以及用户的密码
package com.yanjun;
import java.net.URL.*;
import java.sql.*;
import javax.swing.*; 

public class adduser {
	public static boolean add1(String name,String pass)//加入新的学生用户
	 {
	       String URL="jdbc:odbc:yanjun";
	       try{
	       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	       Connection con=DriverManager.getConnection(URL);
	       DatabaseMetaData dma=con.getMetaData();
	       Statement stmt=con.createStatement();
	       if(link.check1(name,pass))return false;//检查是否有此用户
	       String sql="insert into student(ID,password)"+"values("
	       +"'"+name+"'"+","+"'"+pass+"'"+")";
	       stmt.executeUpdate(sql);
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
	public static boolean add2(String name,String pass)//加入新的教师用户
	 {
	       String URL="jdbc:odbc:yanjun";
	       try{
	       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
	       Connection con=DriverManager.getConnection(URL);
	       DatabaseMetaData dma=con.getMetaData();
	       Statement stmt=con.createStatement();
	       if(link.check2(name,pass))return false;//检查是否有此用户
	       String sql="insert into teacher(ID,password)"+"values("
	       +"'"+name+"'"+","+"'"+pass+"'"+")";
	       stmt.executeUpdate(sql);
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
}