student.java

来自「《JSP程序设计实用教程》-梁建武-源代码（补充）-4567.rar」· Java 代码 · 共 26 行

package stu; 
import java.sql.*;

public class student {
  private String id,password,dep,name,sex,jiguan;                                                                    
  public String getId() {
    return id;
  }
  public void setId(String id) {
    this.id = id;
  }
  	                       
  public ResultSet  getStudent(){
		String sql="select * from student   ";
		sqlBean db= new sqlBean();
		ResultSet rs = db.executeQuery(sql);
		 return rs;
		                         } 	                         	                         		                                                 	                       	                       
 
   public void deleteStudent(){
    	
    	String sql="delete  from student where id ='"+id+"' ";
    	sqlBean db= new sqlBean();
    	db.executeDelete(sql);
    	}                                              	
}