import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement;
/** * @author ljk * @完成DML操作 */ public class Jdbc_DML { public static void main(String[] args) { Statement state=null; Connection conn=null; String dirver="jdbc:oracle:thin:@localhost:1521:orcl"; String url="bjsxt"; String pwd="bjsxt"; //导入jar包 try { //2加载驱动 Class.forName("oracle.jdbc.driver.OracleDriver"); //3创建连接 conn= DriverManager.getConnection(dirver,url,pwd); //4创建命令发送器(执行sql语句) state=conn.createStatement(); //5根据命令发送器执行sql语句并接受结果集 //添加一行元素操作 //String str="INSERT INTO T_STUDENT VALUES(2001,'隔壁老李',22,'男',18,SYSDATE,305,00)"; //修改字段内部内容的操作 //String str="UPDATE T_STUDENT SET SNAME='小黑' WHE