java+mysql学生信息管理系统课程设计报告 - 图文(8)

*/

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();

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库java+mysql学生信息管理系统课程设计报告 - 图文(8)在线全文阅读。