linkmysqlbyjdbc.java

来自「实现数据挖掘的K-means算法 使用多次迭代从」· Java 代码 · 共 42 行

import java.sql.*;


class linkMysqlByJDBC {
    public static void main(String[] args){
        try{
            String driver = "org.gjt.mm.mysql.Driver";                 //驱动类
            String url = "jdbc:mysql://localhost:3306/MyFirstDB";
            //连接字符串 其中TestDB是数据库名
            String username = "yrw";                                                //用户名
            String password = "870613";                                              //密码

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

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

            sm.execute(sql);

            String sql2 = "select * from s";
            rs = sm.executeQuery(sql2);
            while (rs.next()) {
                System.out.println(rs.getString("Name"));
            }

            con.close();
        }catch(Exception e){
            e.printStackTrace();
        }
    }
}