ʹÓÃJAVAÁ¬½ÓMYSQL²åÈëÊý¾ÝÂÒÂëÎÊÌâ - Java / Java SE
ÎÒʹÓÃNavicat Lite8½øÐÐMYSQLÊý¾Ý¿âºÍ±íµÄ½¨Á¢,È»ºóÓÃJAVA½øÐÐÊý¾ÝµÄÌí¼Ó
µ±Êý¾ÝÌí¼Ó½øÈëÊý¾Ý¿âºó,Ó¢ÎĺÍÊý×Ö¶¼¿ÉÒÔÏÔʾ,µ«ÊÇÖÐÎľͻá±ä³É??
ÎҸоõÊÇ×Ö·û¼¯ÓõIJ»¶Ô
ÔÚʹÓÃNavicat Lite8½øÐÐÊý¾Ý¿âµÄ´´½¨Ê±,»áÓÐÁ½¸öÑ¡Ïî,·Ö±ðÊÇCharacter setºÍCollation
ǰÕßÎÒÊÔ¹ýÁËBIG5,gb2312,gbk,utf8,µ±Ñ¡ÓÃutf8ʱ,CollationµÄÑ¡Ïî·Ç³£¶à,ÎÒ¾ÍËæ±ãÑ¡Á˼¸ÖÖ·Ö±ðÊÔÁË,µ«ÊǶ¼ÊDz»ÐÐ,ÖÐÎÄÒ»Ö±ÊÇÏÔʾ??
¶øÓ¢ÎĺÍÊý×Ö¶¼ÊÇÕý³£
»¹ÓÐÒ»µãºÜÆæ¹Ö,ÎÒÖ±½ÓÓÃNavicat Lite8Ìí¼ÓÖÐÎÄÊý¾Ý,select³öÀ´µÄÖÐÎľͿÉÒÔÏÔʾ
ÇëÎÊÏÂ,Õâ¸öÎÊÌâÈçºÎ½â¾ö,Ï£ÍûÄܽ²µÄÏêϸµã,ÎÒÊÇÐÂÊÖ,×îºÃ±ðÌ«Éî°Â
Êý¾Ý¿â±àÂëÉèÖúÃÁË£¬²åÈë·½·¨Ò²ÒªÏàÓ¦µÄÉèÖÃһϱàÂ룬²»ÄܲåÈëµÄÊÇÂÒÂë
Êý¾ÝµÄ²åÈ룬ÎÒÊÇÖ±½ÓÔÚJAVAÀï×öµÄ£¬ÏÂÃæÊÇÏà¹Ø´úÂë
Java code:
String sql = "insert into guest values(?,?,?,?,?,?,?,?)";
PreparedStatement ps = con.prepareStatement(sql);
ps.setInt(1, id);
ps.setString(2, fname.getText().trim());
ps.setString(3, faddress.getText().trim());
ps.setString(4, fkind.getText().trim());
ps.setString(5, ftrade.getText().trim());
ps.setString(6, fnumber.getText().trim());
ps.setString(7, femail.getText().trim());
ps.setString(8, fbusiness.getText().trim());
int r = ps.executeUpdate();
if(r > 0)
{
//µ¯³öÒ»¸ö¶Ô»°¿ò
Ïà¹ØÎÊ´ð£º
org.apache.jasper.JasperException: Unable to compile class for JSP:
An error occurred at line: 52 in the jsp file: /vip_info.jsp
ÕË cannot be resolved
49: <table border="1& ......
ÎÒÊǸöÐÂÊÖ£¬Íû¸ßÊÖ½â´ð
ÎÒÏÖÔÚÒѾ°²×°ÁËmysql£¬Ò²ÓÐmysqlµÄjdbc¡£µ«ÎÒÔõôÅäÖú󣬲ÅÄÜÔÚMyEclipseÀï²Ù×÷mysqlÄØ£¿Çë¸ßÊÖ˵Ïêϸµã
´ò¿ªMyeclipse----window---open perspective---MyEclipse database explorer-- ......
ʹÓÃjavaÔÚwindows7 32λÏÂÁ¬½ÓMSSQL¡£
Á½Ì¨»úÆ÷£¬windows7 32룬ÔÚ¿ØÖÆÃæ°åÀïÃæÈ«²¿ÉèÖÃÓïÑÔºÍÇøÓòÑ¡Ïî¶¼english-unitedstates
Î¨Ò»Çø±ðÖ»ÓÐÔÚ°²×°SQL server 2008µÄʱºò Ñ¡ÔñµÄ×Ö·û¼¯²»Ò»Ñù£¬
exec sp_helpsor ......
ÔھƵê¹ÜÀíϵͳÖÐ,ÓÐÒ»¸ö¶ÔÄÚµÄϵͳ,¹©Ç°Ì¨·þÎñÔ±ºÍ¾ÀíʹÓÃ
»¹ÓÐÒ»¸ö¾ÍÊǶÔÍâ,Èÿͻ§¿ÉÒÔÔÚÍøÉÏÔ¤¶©·¿¼ä,
ËüÃÇÖ®¼äÊÇÔõôͨѶµÄ.?µ±ÎÒÌá½»Ô¤¶©·¿¼äÐÅÏ¢µÄʱºò,
ÔÚ¶ÔÄÚµÄϵͳÖÐ,ÈçºÎÖªµÀÎÒÒѾÌá½»ÁËÐÅÏ¢¹ýÈ¥.Ê¹Ç ......
sp ³ÌÐò
delimiter //
create procedure ma()
begin
declare i int default 0;
while i<11 do
set i=i+1;
select i;
end while;
end //
delimiter ;
1+2+...+9+10
ΪʲôÕâ¸ö³ÌÐòÎÞ·¨ÊµÏÖÀÛ¼ÓЧ¹û
/ ......