changecode.java

来自「利用JAVA和Access做成一个学生信息管理系统」· Java 代码 · 共 45 行

//修改用户的密码
package com.yanjun;
import java.net.URL.*;
import java.sql.*;

import javax.swing.*; 
public class changecode {
	public static boolean change1(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();
	       String sql="UPDATE student SET  password='" + pass
			+"'"+ " WHERE ( ID= '" + name+"')";
	       stmt.executeUpdate(sql);
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
	public static boolean change2(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();
	       String sql="UPDATE teacher SET  password='" + pass
			+"'"+ " WHERE ( ID= '" + name+"')";
	       stmt.executeUpdate(sql);
	       stmt.close();
	       con.close();
	       return true;
	       }
	       catch(SQLException ex){return false;}
	       catch(java.lang.Exception ex){return false;}
	  }
}