java连接数据库demo

java连接mysql代码

需要提前安装jar包 mysql-connector-java-8.0.29.jar

import java.sql.*;

public class test_mysql {
    public static void main(String[] args) throws SQLException {
        String databaseName = "nb"; //数据库名 （需要提前创建好数据库
        String userName = "root";  //用户名  （一般都叫root
        String password = "123456";  //密码
        Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + databaseName, userName, password);
        Statement stmt = conn.createStatement();

        String sql;
        sql = "drop table person";
        stmt.executeUpdate(sql);

        sql = "CREATE TABLE person(uid varchar(32),name char(32))";
        stmt.executeUpdate(sql);

        sql = "INSERT INTO person(uid,name) VALUES(" + "'" + "1" + "','" + "whpsb\nnao\ncan\n" + "')";
        stmt.executeUpdate(sql);

        sql = "INSERT INTO person(uid,name) VALUES('2','somebody2')";
        stmt.executeUpdate(sql);


        // 查询
        sql = "SELECT * FROM person";

        ResultSet rs = stmt.executeQuery(sql);
        System.out.println("uid\t姓名");

        while (rs.next()) {
            System.out.println(rs.getString(1) + "\t" + rs.getString(2));
        }

        conn.close();
    }
}