mysql ²åÈëÊý¾Ý Óï¾äÔõôʹÓã¿
=========================================1.java==============================================================
if(flag.equals("addUser")){
//Íê³ÉÌí¼ÓÓû§
//µÃµ½Óû§ÊäÈëµÄÐÅÏ¢
String name=request.getParameter("useName");
String passwd=request.getParameter("passwd");
String email=request.getParameter("email");
//´´½¨userbeancl
UserBeanCl ubc=new UserBeanCl();
if(ubc.addUser(name, passwd, email)){
//Ìí¼Ó³É¹¦
request.getRequestDispatcher("suc.jsp").forward(request, response);
}else{
//²»³É¹¦
request.getRequestDispatcher("err.jsp").forward(request, response);
}
======================================================2.java===============================================
public boolean addUser(String name,String passwd,String email){
boolean b=false;
try{
//µÃµ½Á´½Ó
conn=new ConnDB().getConn();
st=conn.createStatement();
//Ö´ÐÐ
int a=st.executeUpdate("insert into user(uID,uPS,mail)values('"+name+"','"+passwd+"','"+email+"')");
if(a==1){
//Ìí¼Ó³É¹¦
b=true;
}
======================
Ïà¹ØÎÊ´ð£º
ÔÚ°²×°Java±àÒëÆ÷µÄEclipseµÄʱºò£¬¶Ô»·¾³±äÁ¿½øÐÐÁËÅäÖã¬ÔÚ°²×°MySQlµÄʱºòÒ²Òª¶Ô»·¾³±äÁ¿½øÐÐÅäÖã»ÄÇôºóÃæµÄÅäÖûáÓ°ÏìÇ°ÃæµÄEclipseµÄÅäÖÃÂð£¿
Çë´ó¼Ò¶àÖ¸½Ì~£¡Ð»Ð»£¡
²»»á°Ñ£¬ÎÒÕâ¶¼×°Á赀 ÎÒϵͳÀï »¹×°ÁË ......
ÎÒµÄMysql ʹÓõÄʱºò ÓÃdos½¨Á¢µÄÊý¾Ý±í ÔÚdosÖÐÄÜÏÔʾ³öÖÐÎÄ
µ«ÊÇÔÚ ÆäËûµÄ¿ÉÊÓÒ³Ãæ ºÍÍøÒ³Öж¼ÏÔʾÂÒÂë ÈçºÎ½â¾ö£¿
ÔÚmysql¿ØÖÆÌ¨:show variables like 'char%';Ìù½á¹û³öÀ´¿´¿´¡£
mysqlÃüÁîÐÐģʽÏÂ: ......
ÎÒÊÇÐÂÊÖ£¬³õѧMYSQL£¬Óкܶ಻¶®£¬Íû´Í½Ì£¡£¡
±ÈÈç˵ÎÒн¨Ò»¸öMYSQLÊý¾Ý¿âUSER Êý¾Ý¿âÖÐÓбíLIST
È»ºóÎÒÔÚVCÖÐн¨Ò»¸öMFC¶Ô»°¿ò¹¤³Ì£¬È»ºóÎÒÔõôÑù²ÅÄÜÓÃVC»ñµÃÊý¾Ý¿âÖбíµÄÊý¾Ý£¿
Ï£Íû¸ø³ö¾ßÌåµÄ²Ù×÷² ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......