delete.java

用java编写的对数据库

package project;

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

import javax.management.loading.PrivateClassLoader;

import com.sun.corba.se.pept.transport.Connection;

public class Delete
{   
	
	private   String name,sex,address;
    private int age,salary;
	
    Delete(String name,String sex,String address,int age,int salary)
	{
	  this.name=name;
	  this.sex=sex;
	  this.address=address;
	  this.age=age;
	  this.salary=salary;
	  
	}
    Delete(String a,int b)
	{
	  s
	  
	}

    
	String sql="delete name,sex,address,age,salary from jdbcExample";
	Connection connection=null;
	java.sql.Statement sta=null;
	try 
	{
		//加载oracle驱动程序
		Class.forName("oracle.jdbc.driver.OracleDriver");
	} 
	catch (ClassNotFoundException e1) 
	{
		e1.printStackTrace();
	}
	//数据库连接的字符串
	String url="jdbc:oracle:thin:@localhost:1521:ORADB";
	String userName="wq";//用户名
	String pw="wq";//密码
	try 
	{
		//创建连接
		connection=(Connection) DriverManager.getConnection(url, userName, pw);
		//创建语句对象			
		sta=((java.sql.Connection) connection).createStatement();
		//执行sql语句的操作并且返回执行的行数
		int a=sta.executeUpdate(sql);
		System.out.print("删除数据成功");
		
	} 
	catch (SQLException e) 
	{
		System.out.print("删除数据失败");
		e.printStackTrace();
	}
	finally
	{
		try
		{
			//关闭声明语句对象
			sta.close();
			//关闭连接对象
			connection.close();
		}
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
	}
}
}