java连接mysql数据库实现查询功能_IDEA java连接mysql数据库，实现对数据库的增删改查...

IDEA java连接mysql数据库，实现对数据库的增删改查

2018-11-18 19:18

阅读数 89

先上代码： package Database_Demo; import java.sql.*; public class DataBase { public

static void main(String[] args) { Connection con; String

driver="com.mysql.jdbc.Driver"; //这里我的数据库是test String

url="jdbc:mysql://localhost:3306/test"; //我的mysql数据库的账户：root 密码：mysql String

user="root"; String password="mysql"; try { Class.forName(driver); con =

DriverManager.getConnection(url, user, password); if (!con.isClosed()) {

System.out.println("数据库连接成功"); } Statement statement = con.createStatement();

//tb1表中插入 tring sql = "insert into tb1 VALUES ('hhh',20,1000)"; //tb1表中删除

String sq2 = "DELETE FROM tb1 WHERE ang=13"; //查找 String sql3 = "select * from

tb1;"; ResultSet resultSet = statement.executeQuery(sql3); String name; while

(resultSet.next()) { name = resultSet.getString("username");

System.out.println("姓名：" + name); } //删除tb2表 String sq4 = "DROP TABLE IF EXISTS

tb2;"; //创建tb3表 String sq5 = "CREATE TABLE tb3(username VARCHAR(20),passward

VARCHAR(10))"; //statement.execute(sq5); //修改tb1表中数据 String sq6 = "UPDATE tb1

SET ang=1111 WHERE username='hhh'"; statement.execute(sq6);

statement.execute(sql); statement.execute(sq2); statement.execute(sq4);

con.close(); } catch (ClassNotFoundException e) {

System.out.println("数据库驱动没有安装"); } catch (SQLException e) {

System.out.println("数据库连接失败"); } } }