java ÊÂÎñ´¦Àí
Èç¹û¶ÔÊý¾Ý¿â½øÐжà´Î²Ù×÷,ÿһ´ÎµÄÖ´Ðлò²½Öè¶¼ÊÇÒ»¸öÊÂÎñ.Èç¹ûÊý¾Ý¿â²Ù×÷ÔÚijһ²½Ã»ÓÐÖ´Ðлò³öÏÖÒì³£¶øµ¼ÖÂÊÂÎñʧ°Ü,ÕâÑùÓеÄÊÂÎñ±»Ö´ÐÐÓеľÍûÓб»Ö´ÐÐ,´Ó¶ø¾ÍÓÐÁËÊÂÎñµÄ»Ø¹ö,È¡ÏûÏÈǰµÄ²Ù×÷.....
JavaBeanÖÐʹÓÃJDBC·½Ê½½øÐÐÊÂÎñ´¦Àí
public int delete(int sID) {
¡¡ dbc = new DataBaseConnection();
¡¡ Connection con = dbc.getConnection();
¡¡ try {
¡¡¡¡ con.setAutoCommit(false);// ¸ü¸ÄJDBCÊÂÎñµÄĬÈÏÌá½»·½Ê½
¡¡¡¡ dbc.executeUpdate("delete from xiao where ID=" + sID);
¡¡¡¡ dbc.executeUpdate("delete from xiao_content where ID=" + sID);
¡¡¡¡ dbc.executeUpdate("delete from xiao_affix where bylawid=" + sID);
¡¡¡¡ con.commit();//Ìá½»JDBCÊÂÎñ
¡¡¡¡ con.setAutoCommit(true);// »Ö¸´JDBCÊÂÎñµÄĬÈÏÌá½»·½Ê½
¡¡¡¡ dbc.close();
¡¡¡¡ return 1;
¡¡ }
¡¡ catch (Exception exc) {
¡¡¡¡ con.rollBack();//»Ø¹öJDBCÊÂÎñ
¡¡¡¡ exc.printStackTrace();
¡¡¡¡ dbc.close();
¡¡¡¡ return -1;
¡¡ }
}
ÔÚÊý¾Ý¿â²Ù×÷ÖУ¬Ò»ÏîÊÂÎñÊÇÖ¸ÓÉÒ»Ìõ»ò¶àÌõ¶ÔÊý¾Ý¿â¸üеÄsqlÓï¾äËù×é³ÉµÄÒ»¸ö²»¿É·Ö¸îµÄ¹¤×÷µ¥Ôª¡£Ö»Óе±ÊÂÎñÖеÄËùÓвÙ×÷¶¼Õý³£Íê³ÉÁË£¬Õû¸öÊÂÎñ²ÅÄܱ»Ìá½»µ½Êý¾Ý¿â£¬Èç¹ûÓÐÒ»Ïî²Ù×÷ûÓÐÍê³É£¬¾Í±ØÐë³·ÏûÕû¸öÊÂÎñ¡£
ÀýÈçÔÚÒøÐеÄתÕÊÊÂÎñÖУ¬¼Ù¶¨ÕÅÈý´Ó×Ô¼ºµÄÕʺÅÉϰÑ1000Ԫתµ½ÀîËĵÄÕʺÅÉÏ£¬Ïà¹ØµÄsqlÓï¾äÈçÏ£º
update account set monery=monery-1000 where name='zhangsan'
update account set monery=monery+1000 where name='lisi'
Õâ¸öÁ½ÌõÓï¾ä±ØÐë×÷Ϊһ¸öÍê³ÉµÄÊÂÎñÀ´´¦Àí¡£Ö»Óе±Á½Ìõ¶¼³É¹¦Ö´ÐÐÁË£¬²ÅÄÜÌá½»Õâ¸öÊÂÎñ¡£Èç¹ûÓÐÒ»¾äʧ°Ü£¬Õû¸öÊÂÎñ±ØÐë³·Ïû¡£
ÔÚconnectionÀàÖÐÌṩÁË3¸ö¿ØÖÆÊÂÎñµÄ·½·¨£º
£¨1£© setAutoCommit(Boolean autoCommit):ÉèÖÃÊÇ·ñ×Ô¶¯Ìá½»ÊÂÎñ£»
£¨2£© commit();Ìá½»ÊÂÎñ£»
£¨3£© rollback();³·ÏûÊÂÎñ£»
ÔÚjdbc apiÖУ¬Ä¬ÈϵÄÇé¿öΪ×Ô¶¯Ìá½»ÊÂÎñ£¬Ò²¾ÍÊÇ˵£¬Ã¿Ò»Ìõ¶ÔÊý¾Ý¿âµÄ¸üеÄsqlÓï¾ä´ú±íÒ»ÏîÊÂÎñ£¬²Ù×÷³É¹¦ºó£¬ÏµÍ³×Ô¶¯µ÷ÓÃcommit£¨£©À´Ìá½»£¬·ñÔò½«µ÷ÓÃrollback£¨£©À´³·ÏûÊÂÎñ¡£
ÔÚjdbc apiÖУ¬¿ÉÒÔͨ¹ýµ÷ÓÃsetAutoCommit(false) À´½ûÖ¹×Ô¶¯Ìá½»ÊÂÎñ¡£È»ºó¾Í¿ÉÒ԰ѶàÌõ¸üÐÂÊý¾Ý¿âµÄsqlÓï¾ä×öΪһ¸öÊÂÎñ£¬ÔÚËùÓвÙ×÷Íê³ÉÖ®ºó£¬µ÷ÓÃcommit£¨£©À´½øÐÐÕûÌåÌá½»¡£ÌÈÈôÆäÖÐÒ»Ïîsql²Ù×÷ʧ°Ü£¬¾Í²»»áÖ´ÐÐcommit£¨£©·½·¨£¬¶øÊDzúÉúÏàÓ¦µÄsqlexception£¬´Ëʱ¾Í¿É
Ïà¹ØÎĵµ£º
JDK
Sun JDK
http://java.sun.com/javase/downloads/index.jsp
IBM JDK
http://www.ibm.com/developerworks/java/
http://www.ibm.com/developerworks/cn/java/
IDE:
Eclipse
http://www.eclipse.org/
Container:
Apache HTTP server
http://www.apache.org/
Tomcat: JSP,Servlet,JavaBean container.
http:// ......
1¡¢Ê×ÏÈ´ó¼Ò×îºÃÈ¥ÏÂÔØÒ»¸ödesigner µÄeclipse ²å¼þ
2¡¢È»ºó·ÅÈëeclipse °²×°Ä¿Â¼ÏµÄpluginĿ¼ÏÂ
3¡¢ÖØÐÂÆô¶¯eclipse
4 н¨Ò»¸öjava swing project
5, н¨Ò»¸öwindow£¬È»ºóµãÔËÐУ¬¾Í»á³öÏÖÒ»¸ö×î¼òµ¥µÄ´°¿Ú¡£
µ±È»£¬ÄãÒ²¿ÉÒÔн¨Ò»¸öclass Window£¬È»ºóÊäÈëÈçÏ´úÂë
import java.awt.Dimension;
import ......
ʲôÊÇjava EEÁË¡£Ò»°ãÀ´Ëµ£¬Ò»¸ö³ÉÊìµÄjava EE½â¾ö·½°¸£¬°üÀ¨ÒÔϼ¸¸ö²¿·Ö¡£
1¡¢¿ÉÒÔ¶ÔÍâÌṩ»ùÓÚ±ê×¼ÐÒéÈçxmlµÄ·þÎñ
ÈçWeb Service
2¡¢ÄÚ²¿Í¨ÐÅ»ùÓÚÃæÏò¶ÔÏóµÄͨÐÅÐÒé
Èç RMI£¬Corba£¬XML RPC
3¡¢°²È«ÐԸߣ¬È¨ÏÞ¿ØÖÆÑϸñ
Èç MD5£¬SSL£¬AccountDomain
4 &nbs ......
¼ÙÉèÐèÇó(ÈçÓÐÀ×ͬ£¬´¿ÊôÇɺÏ)£º
ÓÐÒ»¸öÈ«¹úÐԵĴóÆóÒµ£¬ÔÚÈ«¹ú¸÷µØÐèÒª²¿ÊðÉÏǧ̨¿Í»§»ú£¬ÕâЩ¿Í»§»úÐèҪʵʱÓë·þÎñÆ÷½»»¥£¬½øÐÐÊý¾Ý´¦Àí¡£ÊµÊ±ÐÔÒªÇó¸ß£¬°²È«ÐԸߣ¬ÒªÇóÖ§³ÖÊÂÎñ£¬ÒÔ¼°²»ÖжϷþÎñ¡£
Ó²¼þ²¿Êð£º
1¡¢ 3000̨¿Í»§»ú
2¡¢ 10̨· ......