写Java代码连接MySQL数据库并进行简单读写

import java.sql.Connection;  

import java.sql.DriverManager;  

import java.sql.ResultSet;  

import java.sql.Statement;  

public class Test {  

    public static void main(String[] args) {  

        try {  

            Class.forName("com.mysql.jdbc.Driver").newInstance();  

            String databaseName = "phildatabase";// 已经在MySQL数据库中创建好的数据库。  

            String userName = "root";// MySQL默认的root账户名  

            String password = "";// 默认的root账户密码为空  

            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/" + databaseName, userName, password);  

            Statement stmt = conn.createStatement();  

            String sql = "CREATE TABLE person(uid varchar(32),name char(32))";  

            // 创建数据库中的表，  

            int result = stmt.executeUpdate(sql);  

            if (result != -1) {  

                System.out.println("创建数据表成功");  

                sql = "INSERT INTO person(uid,name) VALUES('1','somebody1')";  

                result = stmt.executeUpdate(sql);  

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

                result = 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();  

        } catch (Exception e) {  

            e.printStackTrace();  

        }  

    }  

}

代码运行输出结果如图：

写Java代码连接MySQL数据库并进行简单读写

浏览过的版块