deluser.java

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

package com.yanjun;
import java.net.URL.*;
import java.sql.*;

import javax.swing.*; 

public class deluser {
	public static boolean del1(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();
               stmt.executeUpdate("delete from SC where" +"(sname='"+name+"')");
	       stmt.executeUpdate("delete from student where" +"(ID='"+name+"')");
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
	public static boolean del2(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();
               stmt.executeUpdate("delete from class where" +"(teacher='"+name+"')");
	       stmt.executeUpdate("delete from teacher where" +"(ID='"+name+"')");
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
}