JDBC建立并插入数据库的基本操作

来源：互联网发布：ipad如何安装淘宝app 编辑：程序博客网时间：2024/05/16 10:30

// 新建一个数据库private void creatNewDataBase() {Connection connection;// 驱动程序名String driver = "com.mysql.jdbc.Driver";// URL指向要访问的数据库名mydataString url = "jdbc:mysql://localhost:3306/mytest";// MySQL配置时的用户名String user = "root";// MySQL配置时的密码String password = "admin";try {Class.forName(driver);connection = DriverManager.getConnection(url, user, password);Statement statement = connection.createStatement();// 建表语句String creatSql = "create table if not exists newuser1(id int primary key auto_increment,name varchar(20),age varchar(5),picture longblob);";int result = statement.executeUpdate(creatSql);// 插入语句String sql = "INSERT INTO newuser1(name,age) VALUES('赵日天','11');";int result1 = statement.executeUpdate(sql);if (result1 == 0) {System.out.println("数据库插入失败");} else {System.out.println("数据库插入成功");}//修改语句String updateSql="update newuser1 set name='Name' where name='赵日天'";int result2 = statement.executeUpdate(updateSql);if (result2 == 0) {System.out.println("数据库修改失败");} else {System.out.println("数据库修改成功");}} catch (ClassNotFoundException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.println("没有找到这个类");} catch (SQLException e) {// TODO Auto-generated catch blocke.printStackTrace();System.out.println("数据库操作异常");}}

阅读全文

0 0