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£¬´Ëʱ¾Í¿É
Ïà¹ØÎĵµ£º
¡¡ÔÚJavaÓïÑÔÖУ¬ abstract class ºÍinterface ÊÇÖ§³Ö³éÏóÀඨÒåµÄÁ½ÖÖ»úÖÆ¡£ÕýÊÇÓÉÓÚÕâÁ½ÖÖ»úÖÆµÄ´æÔÚ£¬²Å¸³ÓèÁËJavaÇ¿´óµÄ ÃæÏò¶ÔÏóÄÜÁ¦¡£abstract classºÍinterfaceÖ®¼äÔÚ¶ÔÓÚ³éÏóÀඨÒåµÄÖ§³Ö·½Ãæ¾ßÓкܴóµÄÏàËÆÐÔ£¬ÉõÖÁ¿ÉÒÔÏà»¥Ìæ»»£¬Òò´ËºÜ¶à¿ª·¢ÕßÔÚ½ø ÐгéÏóÀඨÒåʱ¶ÔÓÚabstract classºÍinterfaceµÄÑ¡ÔñÏԵñȽÏËæ ......
ÏßÐÔ±í£¬Á´±í£¬¹þÏ£±íÊdz£ÓõÄÊý¾Ý½á¹¹£¬ÔÚ½øÐÐJava¿ª·¢Ê±£¬JDKÒѾΪÎÒÃÇÌṩÁËһϵÁÐÏàÓ¦µÄÀàÀ´ÊµÏÖ»ù±¾µÄÊý¾Ý½á¹¹¡£ÕâЩÀà¾ùÔÚjava.util°üÖС£±¾ÎÄÊÔͼͨ¹ý¼òµ¥µÄÃèÊö£¬Ïò¶ÁÕß²ûÊö¸÷¸öÀàµÄ×÷ÓÃÒÔ¼°ÈçºÎÕýȷʹÓÃÕâЩÀà¡£
Collection
©ÀList& ......
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¡¢ 3000̨¿Í»§»ú
2¡¢ 10̨· ......
public class TestEnum {
/*×îÆÕͨµÄö¾Ù*/
public enum ColorSelect {
red, green, yellow, blue;
}
  ......