mysql.java

来自「一个使用JDBC连接MySql的例子」· Java 代码 · 共 33 行

import java.sql.*;
class mysql {
    public static void main(String[] args){
        try{
            String driver = "com.mysql.jdbc.Driver";                 //驱动类
            String url = "jdbc:mysql://localhost:3306/pwy";
            String username = "root";                                                //用户名
            String password = "pwy";                                              //密码

            Connection con = null;
            Statement sm = null;
            ResultSet rs = null;
            
            Class.forName(driver);
            
            con = DriverManager.getConnection(url, username, password);

            String sql = "insert into s values('1')";
            sm = con.createStatement();

            sm.execute(sql);

            String sql2 = "select * from s";
                        rs = sm.executeQuery(sql2);
            while (rs.next()){
                System.out.println(rs.getString("i"));
            }
            con.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}