testjdbc.java

来自「该压缩文件中共包含16个非常实用的java学习实例」· Java 代码 · 共 38 行

import java.sql.*;
public class TestJDBC
{
	public static void main(String args[])
	{
		
    	try
    	{
        	Class.forName("oracle.jdbc.OracleDriver");//加载数据库驱动
            //Connection con=DriverManager.getConnection("jdbc:oracle:oci8:@CY","scott","tiger");//获得连接--瘦客户端      
        	Connection con=DriverManager.getConnection("jdbc:oracle:thin:@yinhe15:1521:CY","scott","tiger");//获得连接--瘦客户端      
        	System.out.println("创建连接成功");
        	Statement st=con.createStatement();//Staement的用法
        	//int j=st.executeUpdate("create table test (a varchar(10),b number)");
        	//int i=st.executeUpdate("insert into test values ('aaa',20)");
        	PreparedStatement ps=con.prepareStatement("insert into test values(?,?)");
        	
        	for(int i=0;i<10;i++)
        	{
            	ps.setString(1,"忍者"+i+"号");
            	ps.setInt(2,i*2+15);
            	ps.executeUpdate();
            }
            
        	ResultSet rs=st.executeQuery("select * from test");
        	while(rs.next())
        	 	System.out.println(rs.getString(1)+"\t"+rs.getString(2));
        	ps.close();
        	st.close();
        	con.close();
        	
        }catch(ClassNotFoundException ce){System.out.println("加载驱动失败"+ce.getMessage());}
         catch(SQLException se){ System.out.println("连接数据库失败"+se.getMessage() );}
         
    }


}