欢迎访问悦橙教程(wld5.com),关注java教程。悦橙教程  java问答|  每日更新
页面导航 : > > 文章正文

java,

来源: javaer 分享于  点击 34180 次 点评:53

java,


package com.company;

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

/**
 * Created by ttc on 16-10-27.
 */
public class 更新
{
    public static void UpdateDept(int deptno, String DeptName) 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 = "update  dept set dname='"+DeptName+"' where deptno="+deptno;
        sm.executeUpdate(stSQL);
        sm.close();
        ct.close();
    }
    public static void main(String[] args) throws SQLException, ClassNotFoundException
    {
        UpdateDept(90,"dssda");
    }
}



相关文章

    暂无相关文章
相关栏目:

用户点评