d int auto_increment primary key,latitude varchar(20),longitude varchar(20),picurl varchar(20),serviceurl varchar(20))";
? eut.createTable(sql);
?
? System.out.println("建表成功");
?}
}
程序执行成功后，登陆mysql数据库，可以看到数据库中出现了刚才创建的表格
（3）利用executeUpdate方法执行插入语句
package com.jdbc;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;
public class ExecuteUpdateInsertTest
{
?public int insertData(String sql) throws Exception
?{
? Class.forName("com.mysql.jdbc.Driver");
? Connection conn = DriverManager.getConnection(
? ? "jdbc:mysql://localhost/BDYun", "root", "340621");
? Statement stmt = conn.createStatement();
? {
? ?return stmt.executeUpdate(sql);
? }
?}
?public static void main(String[] args) throws Exception
?{
?
? ExecuteUpdateInsertTest ed = new ExecuteUpdateInsertTest();
? String sql = "insert into poi values(null,120.5333,34.6555,null,null)";
? int result = ed.insertData(sql);
? System.out.println("数据库表中共有"+result+"条记录受影响");
?}
}