inserdata.java

用java编写的对数据库

package project;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;
public class InserData

{   
	private String name,sex,address;
	private int age,salary;
	InserData(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;
	  
	}
	String sql="insert into jdbcExample(name,sex,address,age,salary)values(?,?,?,?,?)";
	PreparedStatement sta=null;
	Connection connection=null;
	
	try 
	{
		//加载oracle驱动程序
		Class.forName("oracle.jdbc.driver.OracleDriver");
	} 
	catch (ClassNotFoundException e) 
	{
		e.printStackTrace();
	}
	//数据库连接的字符串
	String url="jdbc:oracle:thin:@localhost:1521:ORADB";
	String userName="wq";//用户名
	String pw="wq";//密码
	try 
	{
		//创建连接
		connection=DriverManager.getConnection(url, userName, pw);
		connection.setAutoCommit(false);//将自动提交模式屏蔽掉
		//创建语句对象			
		sta=connection.prepareStatement(sql);
		sta.setString(1, name);
		sta.setString(2, sex);
		sta.setString(3, address);
		sta.setInt(2, age);
		sta.setInt(3, salary);
		
		//执行sql语句的操作并且返回执行的行数
		int a=sta.executeUpdate();
		connection.commit();//提交(控制权交给程序员)
		if(a==1)
		{
			System.out.print("成功插入一条数据");
		}
		else
		{
			System.out.print("插入数据失败");
		}
		
	} 
	catch (SQLException e1) 
	{
		// TODO Auto-generated catch block
		try 
		{
			connection.rollback();//出现问题回滚恢复成以前的状态
		} 
		catch (SQLException e1) 
		{
			e1.printStackTrace();
		}
		e.printStackTrace();
	}
	finally
	{
		try
		{
			//关闭声明语句对象
			sta.close();
			//关闭连接对象
			connection.close();
		}
		catch (SQLException e) 
		{
			e.printStackTrace();
		}
		
	}
}
}