?? dba.java
字號(hào):
package myBean;
import java.sql.*;
import myBeans.SQLBean;
public class DBA {
private String id;
private String password;
private String name;
private String sex;
private String enrol;
private String dep_id;
private String info;
public String getId() {return id;}
public void setId(String id) {this.id = id;}
public void setDep_id(String s){dep_id=s;}
public String getDep_id(){return dep_id;}
public void setPassword(String s){password=s;}
public String getPassword(){return password;}
public void setEnrol(String year){enrol=year;}
public String getEnrol(){return enrol;}
public void setSex(String sex){this.sex=sex;}
public String getSex(){return sex;}
public void setName(String name){this.name=name;}
public String getName(){return name;}
public void setInfo(String info){this.info = info;}
public String getInfo(){return info;}
public boolean hasLogin(String id){ //檢查該帳號(hào)是否已經(jīng)注冊(cè)
boolean f=true;
String sql="select * from studba where ID ='"+id+"'";
SQLBean db =new SQLBean();
try{
ResultSet rs=db.executeQuery(sql);
if(rs!=null && rs.next()){ f=false;}
else{ f=true;}
}catch(Exception e){ e.getMessage();}
return f;
}
public ResultSet getDBA(String dep){
String sql = "";
if(dep.equals("0000")){
sql="select * from studba ";
}
else{
sql="select * from studba where DEPARTMENT='"+dep+"'";
}
SQLBean db= new SQLBean();
ResultSet rs = db.executeQuery(sql);
return rs;
}
public String updateDBA(){
String sql="update studba "+
" set NAME='"+name+"',"+" SEX='"+sex+"', INFO='"+info+"', PASSWORD='"+password+"' where ID='"+id+"' ";
SQLBean db= new SQLBean();
db.executeInsert(sql);
return sql;
}
public int deleteDBA(String id){
int num=0;
SQLBean db = new SQLBean();
String sql="delete from studba where ID = '"+id+"'";
num=db.executeDelete(sql);
return num;
}
public int addDBA() {
int num = 0;
String sql="insert into studba(ID,NAME,PASSWORD,SEX,ENROLLDAY,DEPARTMENT,INFO) "+
"values('"+id+"','"+name+"','"+password+"','"+sex+"','"+enrol+"','"+dep_id+"','"+info+"') ";
SQLBean db =new SQLBean();
num=db.executeInsert(sql);
return num;
}
}
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -