4¡¢ÓÃÀýͼ£º
ϵͳ¹ÜÀíÔ±
Ôö¼ÓѧÉúÐÅÏ¢ ÐÞ¸ÄѧÉúÐÅÏ¢ ÁгöÈ«²¿Ñ§ÉúÐÅÏ¢ ²éѯѧÉúÐÅÏ¢ ѧÉúÐÅÏ¢¹ÜÀíϵͳ ɾ³ýѧÉúÐÅÏ¢
5
ÀàÓëÀàÖ®¼ä¹ØÏµÍ¼£º
6
5¡¢Ê¹Óõ½µÄ֪ʶ£º
Java»ù´¡ÖªÊ¶£¨·ÖÖ§Ñ¡Ôñ¡¢Ñ»·µÈ£©£¬JavaÃæÏò¶ÔÏ󣬳éÏóÀ࣬½Ó¿Ú£¬Òì³££¬I/O²Ù×÷(ÐòÁл¯ºÍ·´ÐòÁл¯µÈ)£¬JDBC²Ù×÷MySQLÊý¾Ý¿â£¬À༯£¨Collection(Set TreeSet) ¡¢IteratorµÈ£©£¬ÕýÔò±í´ïʽ£¬javaÀà¿âÖÐһЩ³£ÓÃÀà¡£
6¡¢³ÌÐò²âÊÔ
³ÌÐò×öÍêÖ®ºóÎÒ×¼±¸ÁËһЩÊý¾Ý¶Ô×öºÃµÄ³ÌÐò½øÐвâÊÔ£¬²âÊÔÊý¾ÝÔÚÎÄ
¼þÖеÄjava¿Î³ÌÉè¼Æ²âÊÔÊý¾ÝÀï¡£²âÊÔÊý¾Ý·ÖΪÕýÈ·ºÍ²»ÕýÈ·Êý¾Ý£¬ËùνÕýÈ·Óë²»ÕýÈ·ÊÇÏà¶Ô¿Í¹Û´æÔÚµÄÊÂÎï½øÐжԱȵ쬱ÈÈç˵È˵ÄÄêÁä²»¿ÉÄÜСÓÚ0£¬Ñ§ÉúµÄ³É¼¨²»¿ÉÄÜСÓÚ0µÈ¡£
ÔÚ²âÊÔʱ³öÏÖÁËÒÔÏÂÎÊÌ⣺һ¸öÈ˵ÄÃû×Ö²»¿ÉÄÜÊÇÊý×Ö£¨ÔÚÕâ¸ö³ÌÐòÖÐ
Ö»¿¼ÂÇÊý×Ö¡¢×ÖĸºÍºº×Ö£¬ÆäËûÌØÊâ·ûºÅ²»¿¼ÂÇ£©£¬µ«ÄÜÕýÈ·µÄÔö¼Ó£»Ò»¸öÈ˵ÄÄêÁä²»¿ÉÄÜСÓÚ0£¬Ñ§Éú³É¼¨²»¿ÉÄÜСÓÚ0£»
¶ÔÒÔÉϵÄÎÊÌ⣬¿ÉÒÔÓÃÕýÔò±í´ïʽÀ´½â¾ö£¬ÕýÔò±í´ïʽÔÚ³ÌÐòÖгýÁËÒÔ
ÉÏ×÷ÓÃÒÔÍ⣬»¹ÓÐÒ»¸ö×÷ÓþÍÊǼìÑéÊäÈëµÄÄÚÈÝÊÇ·ñΪÊý×Ö¡£ 1¡¢
import java.io.BufferedReader;
import java.io.IOException; import java.io.InputStreamReader; import java.sql.Connection;
import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement;
//Õâ¸öÀàÓÃÓÚÌí¼Ó¡¢Ð޸ġ¢ËÑË÷ºÍɾ³ý¼Ç¼¡£ class StudentDetails {
/** ÉùÃ÷Ò»¸öStatement¶ÔÏó¡£ */ PreparedStatement stmtObj = null; /** ÉùÃ÷Ò»¸öString±äÁ¿¡£ */
7
String strSql = null;
/** ÉùÃ÷Ò»Connection¸ö¶ÔÏó¡£ */ Connection con = null;
/** ÉùÃ÷Ò»¸öBufferedReader¶ÔÏó */ BufferedReader bufferObj = null; //´´½¨Ò»¸öÊý¾Ý¿âÁ¬½Ó¶ÔÏó
private DataBaseConnection dbc = null; /**
* ÕâÊǹ¹Ôì·½·¨¡£ */
public StudentDetails() {
bufferObj = new BufferedReader(new InputStreamReader(System.in)); dbc = new DataBaseConnection(); } /**
* ¸Ã·½·¨ÓÃÓÚ½«¼Ç¼Ìí¼Óµ½Êý¾Ý¿âÖС£ */
void addRecord() {
try { System.out.print(\ÇëÊäÈëѧºÅ: \
int roll = Integer.parseInt(bufferObj.readLine()); System.out.print(\ÇëÊäÈëѧÉúµÄÐÕÃû£º \String name = bufferObj.readLine();
System.out.print(\ÇëÊäÈë¿Î³ÌÃû³Æ£º \String course = bufferObj.readLine();
//strSql = \
//strSql = strSql + \strSql = \into student
values('\
stmtObj = this.dbc.getConnection().prepareStatement(strSql);
stmtObj.executeUpdate(); stmtObj.close();
System.out.print(\¼Ç¼Òѳɹ¦Ìí¼Ó£¡\\n\
System.out.println(\******************************\\n\
} catch (SQLException ioe) { System.out.println(\´íÎó 2 \
8
Ïà¹ØÍÆ¼ö£º