jdbctest2.java

来自「java与数据库相连接的原程序」· Java 代码 · 共 62 行

package main;
import java.sql.*;
import java.lang.*;
import java.util.*;

public class JdbcTest2 {

	public static void Test(){
		System.out.println("Test()");		
	}
	
	static {
		System.out.println("Init()");
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String url="jdbc:oracle:thin:@127.0.0.1:1521:orcl";
		String driver="oracle.jdbc.driver.OracleDriver";
		String user="scott";
		String password="tiger";
		String sql="SELECT * FROM  PLSQL101_TEST_2 WHERE NAME=?";		
		try
		{
			//
			oracle.jdbc.driver.OracleDriver orcldriv =new oracle.jdbc.driver.OracleDriver();
			//Class.forName(driver);					
			/*
			 * 保证相应的Driver类已经被加载到 jvm中，并且完成了类的初始化工作就行了，而具体是怎样实现这个功能却是没有讲究的。
			 */
			//获取连接
			Connection conn = DriverManager.getConnection(url, user, password);
			
			java.sql.PreparedStatement  stmt= conn.prepareStatement(sql);
			stmt.setString(1, "123");
		
			//执行查询
			java.sql.ResultSet rs= stmt.executeQuery();
			while(rs.next())
			{
				System.out.println(rs.getString(1));
			}
			stmt.close();
			//执行操作
			sql="INSERT INTO PLSQL101_TEST_2(NAME,GENDER)VALUES(?,?)";		
			stmt = conn.prepareStatement(sql);
			stmt.setString(1, "222");
			stmt.setString(2, "3");
			stmt.execute();			
			stmt.close();
		}
		catch(Exception E)
		{
			System.out.println(E);
		}

	}

}