eclipse已经连接好了数据库,但是插入不了数据 eclipse显示数据库连接成功 程序添加资料添加不了
\u4e3a\u4ec0\u4e48eclipse\u8fde\u63a5\u6570\u636e\u5e93\u603b\u8fde\u63a5\u4e0d\u6210\u529feclipse\u8fde\u63a5\u4e0d\u4e0aMySQL\u6570\u636e\u5e93\u53ef\u80fd\u662fjar\u5305\u6ca1\u5bfc\u5165\uff0c\u6570\u636e\u5e93\u9519\u8bef\u7b49\u591a\u65b9\u9762\u539f\u56e0\u5bfc\u81f4\u7684\u3002
\u5de5\u5177\uff1a
eclipse
\u65b9\u6cd5\uff1a
1\u3001\u521b\u5efa\u4e00\u4e2a\u6570\u636e\uff1a
mysql>CREATE DATABASE test; //\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93
mysql>use test; //\u6307\u5b9atest\u4e3a\u5f53\u524d\u8981\u64cd\u4f5c\u7684\u6570\u636e\u5e93
mysql>CREATE TABLE user (name VARCHAR(20),password VARCHAR(20)); //\u521b\u5efa\u4e00\u4e2a\u8868user\uff0c\u8bbe\u7f6e\u4e24\u4e2a\u5b57\u6bb5\u3002
mysql>INSERT INTO user VALUES('huzhiheng','123456'); //\u63d2\u5165\u4e00\u6761\u6570\u636e\u5230\u8868\u4e2d
2\u3001\u6253\u5f00Eclipse\uff0c\u53f3\u952e\u70b9\u51fbmy--->build Path--->add external Archiver...\u9009\u62e9jdbc\u9a71\u52a8\uff0c\u70b9\u51fb\u786e\u5b9a\u3002
3\u3001\u9a71\u52a8\u5df2\u7ecf\u5bfc\u5165\uff0c\u5199\u8fde\u63a5\u6570\u636e\u5e93\u4ee3\u7801
4\u3001\u70b9\u51fb\u8fd0\u884c\u7a0b\u5e8f\uff0c\u5982\u679c\u51fa\u73b0\u4ee3\u7801\u4e2d\u8981\u663e\u793a\u7684\u5185\u5bb9\u8bf4\u660e\u8fde\u63a5\u4e0a\u4e86\u3002
\u4ece\u4f60\u622a\u56fe\u7684\u4ee3\u7801\u4e0a\u9762\u6765\u770b\uff0c\u4f60\u53ea\u662f\u624b\u52a8\u6253\u4e86\u4e00\u4e2a\u8bed\u53e5\u8bf4\u6dfb\u52a0\u6210\u529f\u4e86\uff0c\u4f46\u662f\u5b9e\u9645\u4e0a\u4f60\u53ea\u662f\u628a\u6570\u636e\u5e93\u8fde\u4e0a\u4e86\uff0c\u4f46\u662f\u6ca1\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u4efb\u4f55\u64cd\u4f5c\uff0c\u6ca1\u6709\u63d2\u5165\u8bb0\u5f55\uff0c\u6240\u4ee5\uff0c\u4f60\u5e94\u8be5\u662f\u5728\u6570\u636e\u5e93\u91cc\u67e5\u4e0d\u5230\u8bb0\u5f55\u7684\u3002
插入语句INSERT INTO table_name (列1, 列2,...) VALUES (值1, 值2,....)
insert into table teacher values('1','张三','12345','河南省洛阳市嵩县德亭镇','01234567890','女','22'"
多了个 table 把它去掉试试
绛旓細鍙冲嚮涓涓〃锛岄夋嫨Generate/Select Statement锛屽湪鍙宠竟鎵撳紑sql鎿嶄綔绐楀彛 鎵撳紑鐨剆ql鎿嶄綔绐楀彛閲岃嚜鍔ㄤ骇鐢熸煡璇㈣鍙ワ紝鐐瑰嚮涓婇潰鐨勭孩鑹蹭笁瑙掑舰鍗冲彲鎵цsql銆備綘鍙互璇曡瘯
绛旓細eclipse杩炴帴鏁版嵁搴撴垚鍔熶絾娌℃湁鏁版嵁鍙兘鐨勫師鍥狅細銆浠ｇ爜璺熸姤閿欒创鍑烘潵銆傚彲鑳借繑鍥炲兼垨鑰卻ql鍐欓敊浜銆
绛旓細INSERT INTO table_name (鍒1, 鍒2,...) VALUES (鍊1, 鍊2,...)insert into table teacher values('1','寮犱笁','12345','娌冲崡鐪佹礇闃冲競宓╁幙寰蜂涵闀','01234567890','濂','22'"澶氫簡涓 table 鎶婂畠鍘绘帀璇曡瘯
绛旓細private final static String url = "jdbc:sqlserver://localhost:1433;DataBaseName=Meeting"; //杩炴帴瀛楃涓 private final static String user = "sa"; //鏁版嵁搴撶敤鎴峰悕 private final static String pwd = ""; //鏁版嵁搴撳瘑鐮 /** * 杩炴帴鏁版嵁搴 * @return * @throws ClassNotFoundException * @throws S...
绛旓細1銆侀鍏堟垜浠墦寮SQL Server鏁版嵁搴擄紝鏂板缓涓涓祴璇曟暟鎹簱锛屽涓嬪浘鎵绀 2銆佹帴涓嬫潵闇瑕佷笅杞絊QL Server鐨凧DBC椹卞姩绋嬪簭锛屽涓嬪浘鎵绀猴紝椹卞姩绋嬪簭鏄竴涓狫ar鍖呮枃浠 3銆佺劧鍚庢垜浠墦寮Eclipse杞欢锛屽彸閿夋嫨New涓嬮潰鐨凧ava Project閫夐」锛屽涓嬪浘鎵绀 4銆佸湪寮瑰嚭鐨勬柊寤篔ava Project鐣岄潰涓垜浠粰椤圭洰璧蜂竴涓悕瀛楋紝鐒跺悗閫夋嫨鍚堥...
绛旓細jar鍖呭叧鑱斻傜幇鍦ㄦ偍鍙互浣跨敤鐩稿叧鐨勭被鍜屾柟娉曘8銆佸湪椤圭洰涓垱寤轰竴涓柊鐨凧dbcTest1.java绫汇9銆佷箣鍚庨夋嫨閿洏鏁插嚮杈撳叆浠ヤ笅浠ｇ爜锛屽涓嬪浘鐨勪唬鐮併10銆佷唬鐮佽鏄庯細Driver鏄竴涓敱鐗瑰畾鏁版嵁搴撲緵搴斿晢瀹炵幇鐨勫疄鐜扮被銆傚畠鐨刢onnect鏂规硶鍙互鑾峰緱鏁版嵁搴杩炴帴銆傚弬鏁板涓婃墍绀恒傝繍琛屽悗锛岃緭鍑哄涓嬶紝璇佹槑鏁版嵁搴撹繛鎺ユ垚鍔熴
绛旓細鐪嬩慨鏀规帴鍙ｆ槸鍚︽纭紝鏂板鎴愬姛琛ㄧず鏂板鐨勪笟鍔′唬鐮佹病鏈夐棶棰橈紝浣犺繖涓渶瑕佺湅鐪嬩綘鐨剈pdate璇彞鏄惁姝ｇ‘锛屽墠鍚庣浼犲弬鏄惁姝ｇ‘銆
绛旓細eclipse鍙互閫氳繃JDBC閾炬帴mysql鏁版嵁搴 宸ュ叿锛歫dbc myeclipse mysql 鏂规硶濡備笅锛氫笅鍥句腑鐨勪唬鐮佷负eclipse閫氳繃jdbc杩炴帴mydql鐨勪唬鐮侊紝url锛岀敤鎴峰悕銆佸瘑鐮併佺鍙ｅ彿杩欎簺璁剧疆涓鸿嚜宸辩殑缂栬瘧鐜灏卞彲浠 褰撹繍琛岀殑鏃跺欙紝灏变細鍑虹幇涓嬪浘绀轰緥鐨勫浘鐗囷紝閫氳繃杩炴帴鍙互鎶婃暟鎹簱鐨勬暟鎹鍙栧嚭鏉ュ苟鏄剧ず 鍓嶆彁鏄鏋杩炴帴鏁版嵁搴撶殑鐢ㄦ埛鍚嶅拰瀵嗙爜...
绛旓細姝ラ 1.鍦ㄦ柊寤虹殑Project涓彸閿柊寤篎loder 2.鍒涘缓鍚嶄负lib鐨勫寘 3.鍒涘缓瀹屾瘯涔嬪悗鐨勫伐绋嬬洰褰 4.鎺ヤ笅鏉ヨВ鍘嬩綘涓嬭浇鐨刴ysql鐨刯ar鍖咃紝鎷疯礉鍏朵腑鐨.jar鏂囦欢 5.鍦ㄥ伐绋媗ib鍖呬笅閭欢 閫夋嫨paste鍗崇矘璐达紝鎶妋ysql鐨刯ar鍖呮嫹璐濊繘鏉 6.鎷疯礉瀹屾瘯濡傚浘锛7.鍦╩ysql鐨刯ar鍖呬笂鍙抽敭閫夋嫨 build path - add to build path 8....
绛旓細1銆Eclipse瀹炵幇涓鏁版嵁搴撶殑杩炴帴锛岄渶瑕佹坊鍔犵浉搴旂殑jar鍖呫傛墦寮Eclipse,鍦ㄨ涓庢暟鎹簱杩炴帴鐨勯」鐩腑閫夋嫨New-->Folder,濡傚浘鎵绀猴細2銆佽緭鍏ユ壙杞絡ar鍖呯殑鏂囦欢澶瑰悕绉發ib,濡傚浘鎵绀猴細3銆佸皢MySQL鏁版嵁搴撹繛鎺ョ殑jar鍖呭鍒跺埌lib 鏂囦欢澶逛腑锛岀劧鍚庨夋嫨璇ar鍖咃紝鍙冲嚮銆锛岄夋嫨Build Path-->Add to build path,濡傚浘鎵绀猴細4銆佹帴...
