jdbc 删,改,查,java高级

最新推荐文章于 2023-07-06 23:32:14 发布

lx392118613

最新推荐文章于 2023-07-06 23:32:14 发布

阅读量161

点赞数

本文链接：https://blog.csdn.net/lx392118613/article/details/52947376

版权

<pre class="java" name="code">public class 连接
{
    public static void main(String[] args) throws ClassNotFoundException, SQLException
    {
        Class.forName("com.mysql.jdbc.Driver");
        String st ="jdbc:mysql://localhost:3306/scott";
        Connection ct = DriverManager.getConnection(st, "root", "l123456");
        Statement sm=ct.createStatement();
        String stSql = "select * from emp";
        ResultSet rs =sm.executeQuery(stSql);
        while(rs.next())
        {
            Integer nEmpno = rs.getInt("empno");
            String stName =rs.getString("ename");
            String stJob = rs.getString("job");
            System.out.println(nEmpno.toString()+" "+stName+" "+stJob);
        }
        rs.close();
        sm.close();
        ct.close();
    }
}

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class 插入
{
    public static void InsertDept(int deptno, String DeptName, String Loc) throws ClassNotFoundException, SQLException
    {

        Class.forName("oracle.jdbc.driver.OracleDriver");
        String st = "jdbc:oracle:thin:@localhost:1521:orcl";
        Connection ct = DriverManager.getConnection(st, "scott", "l123456");
        Statement sm = ct.createStatement();
        String stSQL = "insert into dept values("+deptno+",'"+DeptName+"','"+Loc+ "')";
        sm.executeUpdate(stSQL);
        sm.close();
        ct.close();
    }
    public static void main(String[] args) throws SQLException, ClassNotFoundException
    {
        InsertDept(60,"ZhuanYan","JinZhou");
    }
}