1 PackageOrg.lxh.demo17.statementdemo;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 Importjava.sql.Statement;6 7 Public classInsertDemo01 {8 Private Static FinalString dbdriver = "Com.mysql.jdbc.Driver";9 Private Static FinalString Dburl = "JDBC:MYSQL://LOCALHOST:3306/MLDN";Ten Private Static FinalString DBUSER = "root"; One Private Static FinalString dbpass = "root"; A Public Static voidMain (string[] args)throwsException { -Connection conn =NULL; -Statement stmt =NULL; theString sql = "INSERT into user (Name,password,age,sex,birthday)" + -"Values (' Zhang San ', ' WWW.MLDN,CN ', 30, ' Male ', ' 2008-08-27 ')"; - Class.forName (dbdriver); -conn =drivermanager.getconnection (Dburl, DBUSER, dbpass); +stmt =conn.createstatement (); - stmt.executeupdate (SQL); + stmt.close (); A conn.close (); at } - -}
Database Insert Operations