課程回mysql默認(rèn)值：default默認(rèn)值 notnull唯一：primarykey（非空+唯一）自增長：auto_increment外鍵：foreign 交叉連接（產(chǎn)生笛卡爾積：原因：連接條件不足夠）表數(shù)量-inner[]null。rightouternull。--創(chuàng)建過程語delimetercreateprocedure名稱(IN/OUT/INOUT 參數(shù)名稱參數(shù)類型)sqlend--調(diào)用過CALL過程名稱(實(shí)際參數(shù));今天的目標(biāo)：jdbc基礎(chǔ)jdbc之前操作數(shù)通過mysql的客戶端工具，登錄數(shù)據(jù)庫服務(wù)器（mysql-uroot-psql什么是java代碼（程序）sql語句的技術(shù)，就是jdbc使用jdbc發(fā)送sql前IP地址@authorpublicclassDemo1privateStringurl= privateStringuser"root";//privateStringpassword=*法*@throwspublicvoidtest1()throwsDriverdrivernewcom.mysql.jdbc.Driver(//Driverdriverneworg.gjt.mm.mysql.Driver(Propertiesprops=newProperties();props.setProperty("user",user);props.setProperty("password",password);Connectionconn=driver.connect(url,} @throwspublicvoidtest2()throwsDriverdriver=new//Driverdriver2=new Connectionconn=DriverManager.getConnection(url,user,password);}推薦使用加載驅(qū)動(dòng)程序類 @throwspublicvoidtest3()throws//Driverdriver=new //Driverdriver2=new Connectionconn=DriverManager.getConnection(url,user,password);}}JDBC接口的 和|Driverjava|connect(url, url:URLjdbc協(xié)議:數(shù)據(jù)庫子協(xié)議://主機(jī):端口/userpassword|-DriverManager類：驅(qū)動(dòng)管理器類，用于管理所有的驅(qū)動(dòng)程 :驅(qū)動(dòng)類對(duì)|-Connection |Connectionjava|StatementcreateStatement()Statement- |CallableStatementprepareCall(Stringsql)CallableStatement|Statementsql|intexecuteUpdate(String sql語句- sql語句|intexecuteUpdate()sql語句|-ResultSet sql語句|-CallableStatement接口：用于執(zhí)行過程的sql語句（call|-ResultSet ：調(diào)用過程的方|ResultSet|booleannext()|-getXX():Statementsql語執(zhí)行DDL語*執(zhí)行DDL語句(創(chuàng)建表publicvoidtest1(){Statementstmt=null;Connectionconn=null;try{ 程conn=DriverManager.getConnection(url,user,stmt=Stringsql="CREATETABLEstudent(idINTPRIMARYKEYAUTO_INCREMENT,NAMEVARCHAR(20),genderVARCHAR(2))";intcount=}catch(Exceptione){thrownew}try{}catch(SQLExceptione){thrownew}try{}catch(SQLExceptione){thrownew}}}執(zhí)行DML語@authorpublicclassDemo2privateStringurl=privateStringuser=privateStringpassword=*publicvoidtestInsert(){Connectionconn=null;Statementstmt=null;try{conn=stmt=Stringsql"INSERTINTOstudent(NAME,genderVALUES('李四','女intcount=}catch(Exceptione){thrownew}try{}catch(SQLExceptione){thrownew}try{}catch(SQLExceptione){thrownewJdbcUtil.close(conn,stmt);}}*publicvoidtestUpdate(){Connectionconn=null;Statementstmt=null;Stringname陳六intid=try conn=DriverManager.getConnection(url,user,conn=stmt=Stringsql="UPDATEstudentSETNAME='"+name+"'WHEREid="+id+"";intcount=}catch(Exceptione){thrownew}try{}catch(SQLExceptione){thrownew}try{}catch(SQLExceptione){thrownewJdbcUtil.close(conn,stmt);}}*publicvoidtestDelete(){Connectionconn=null;Statementstmt=null;intid=try conn=DriverManager.getConnection(url,user,conn=stmt=Stringsql="DELETEFROMstudentWHEREid="+id+"";intcount=}catch(Exceptione){thrownew}try{}catch(SQLExceptione){thrownew}try{}catch(SQLExceptione){thrownewJdbcUtil.close(conn,stmt);}}}執(zhí)行DQL語@authorpublicclassDemo3publicvoidtest1(){Connectionconn=null;Statementstmt=null;conn=stmt=Stringsql="SELECT*FROMResultSetrs=/*booleanflag=flag=rs.next();flag=rs.next();intid=Stringname=rs.getString(2);Stringgender=rs.getString(3);

intid=Stringname=rs.getString("name");Stringgender=rs.getString("gender");intid=Stringname=rs.getString("name");Stringgender=rs.getString("gender");}}catch(Exceptione){thrownewJdbcUtil.close(conn,}}}PreparedStatementsql語publicclassDemo1*publicvoidtestInsert(){Connectionconn=null;PreparedStatementstmt=null;try{conn=

Stringsql"INSERTINTOstudent(NAME,genderVALUES(stmt=*從1stmt.setString(1李四stmt.setString(2男intcount=}catch(Exceptione){thrownew}finallyJdbcUtil.close(conn,}}*publicvoidtestUpdate(){Connectionconn=null;PreparedStatementstmt=null;try{conn=Stringsql"UPDATEstudentSETNAME=WHEREid=?符stmt=*從1stmt.setString(1王五");stmt.setInt(2,9);intcount=}catch(Exceptione){thrownew}finallyJdbcUtil.close(conn,}}*publicvoidtestDelete(){Connectionconn=null;PreparedStatementstmt=null;try{conn=Stringsql"DELETEFROMstudentWHEREidstmt=*從1stmt.setInt(1,intcount=}catch(Exceptione){thrownew}finallyJdbcUtil.close(conn,}}*publicvoidtestQuery(){Connectionconn=null;PreparedStatementstmt=null;ResultSetrs=null;tryconn=Stringsql="SELECT*FROMstmt=rs=intid=Stringname=rs.getString("name");Stringgender=rs.getString("gender");}}catch(Exceptione){thrownew}finally}}}1）語法不同：PreparedStatementsqlStatmentsql2）效率不同：PreparedStatement可以使用sql緩存區(qū)，效率比Statment高3）PreparedStatementsqlStatmentsql注入。CallableStatement執(zhí)行過@authorpublicclassDemo1**CALLpublicvoidtest1(){Connectionconn=null;CallableStatementstmt=ResultSetrs=null;try{conn=Stringsql"CALLpro_findById(可以執(zhí)行預(yù)編譯的stmt=stmt.setInt(16);rs=stmt.executeQuery();//注意：所有調(diào) intid=Stringname=rs.getString("name");Stringgender=rs.getString("gender");}}catch(Exceptione){thrownew}finallyJdbcUtil.close(conn,stmt}} 過CALLpublicvoidtest2(){Connectionconn=null;CallableS