*/
public String[] crsSearch(String num){ } /**
* 根据课程名称，搜索课程号 */
public String[] crsNameSear(String name){
Database DB = new Database(); String[] s = new String[6]; this.cName = name; DB.toGBK(cName);
sql = \try{
DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.next()){
s[0] = rs.getString(\
Database DB = new Database(); this.cNum = num;
String[] s = new String[5];
sql = \try{ }
catch(Exception e){ }
finally { }
return s;
DB.closeStmt(); DB.closeConn(); DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.next()){ } else
s = null;
s[0] = rs.getString(\s[1] = rs.getString(\s[2] = rs.getString(\s[3] = rs.getString(\s[4] = rs.getString(\
}
}
}
s[1] = rs.getString(\s[2] = rs.getString(\s[3] = rs.getString(\s[4] = rs.getString(\s[5] = rs.getString(\
else
s = null;
catch(Exception e){ }
finally { }
return s;
DB.closeStmt(); DB.closeConn();
System.out.println(e);
/**
* 根据课程名称与选课人，搜索课程相关信息 */
public String[] crsNameSearch(String name,String snum){
Database DB = new Database(); this.cName = name; this.sNum = snum;
String[] s = new String[6];
sql = \* from course,sc where cname = '\and sc.snum try{
DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.next()){ }
s[0] = rs.getString(\s[1] = rs.getString(\s[2] = rs.getString(\s[3] = rs.getString(\s[4] = rs.getString(\s[5] = rs.getString(\
= '\
else
s = null;
}
catch(Exception e){ System.out.println(e);
}
finally { DB.closeStmt(); DB.closeConn();
}
return s;
}
/**
* 课程信息综合查询 */
public String[][] crsAllSearch(String colname,String colvalue){ this.colName = colname; this.colValue = colvalue;
Database DB = new Database(); String[][] cn = null; int row = 0; int i = 0;
if(colValue == null||colValue.equals(\ sql = \
} else{ sql = \* from course where \'\
} try{ DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.last()){ row = rs.getRow();
}
if(row == 0){ cn = null;
}
else{
=
}
}
}
cn = new String[row][6]; rs.first(); rs.previous(); while(rs.next()){ }
cn[i][0] = rs.getString(\cn[i][1] = rs.getString(\cn[i][2] = rs.getString(\cn[i][3] = rs.getString(\cn[i][4] = rs.getString(\cn[i][5] = rs.getString(\i++;
catch(Exception e){ }
finally { }
return cn;
DB.closeStmt(); DB.closeConn();
System.out.println(e);
/**
* 获得新的课程号 */
/*public int getCrsId(){
Database DB = new Database();
sql = \try{ }
catch(Exception e){ }
System.out.println(e); DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.next()){ } else
crsId = 1;
crsId = rs.getInt(1) + 1;
finally { }
return crsId;
DB.closeStmt(); DB.closeConn();
}*/ /**
* 获得course表中的所有课程号cnum */
public String[] getAllId(){
String[] s = null; int row = 0; int i = 0;
Database DB = new Database(); sql = \try{ }
catch(Exception e){ }
finally { }
DB.closeStmt(); DB.closeConn();
System.out.println(e); DB.OpenConn();
rs = DB.executeQuery(sql); if(rs.last()){ }
if(row == 0){ } else{ }
s = new String[row]; rs.first(); rs.previous(); while(rs.next()){ }
s[i] = rs.getString(1); i++; s = null;
row = rs.getRow();