网站建设知识
java使用mysql
2025-07-22 11:15  点击:0

java使用mysql---jdbc链接示例

import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;public class jdbc {    public static void main (String[] args) {        Connection conn = null;        String url = "jdbc:mysql://xx.xx.xx.xx:3306/xx?"   -------- 指定要读取的数据库地址和database                + "useUnicode=true&characterEncoding=UTF8";        try {            Class.forName("com.mysql.jdbc.Driver");            System.out.println("成功加载MySQL驱动程序");            conn = DriverManager.getConnection(url, "user", "pwd");   ------- 数据库的用户和密码            Statement stmt = conn.createStatement();            String sql = "select * from Students";     ------- 要使用的查找、插入或更新等语句            ResultSet getInfo = stmt.executeQuery(sql);            while (getInfo.next()) {                Logger.print(getInfo.getString(1) + ":" + getInfo.getString(2));  ---- 遍历读取的数据并打印            }        } catch (SQLException e) {            Logger.print("MySQL操作错误");            e.printStackTrace();        } catch (Exception e) {            e.printStackTrace();        } finally {            try {                conn.close();            } catch (SQLException e) {                e.printStackTrace();            }        }    }}