jdbctest.java

java与数据库相连接的原程序

package main;

import java.sql.*;
 
public class JdbcTest {

	//private static final String SAL = null;
	//private static final String SAL2 = null;

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		String url = "jdbc:oracle:thin:@127.0.0.1:1521:xiaoran";
		String driver = "oracle.jdbc.driver.OracleDriver";
		String user = "scott";
		String password = "tiger";
		String sql = "select sysdate from dual";
		 
		//String sql2="select SAL from EMP"; 
		
		try {
		 //oracle.jdbc.driver.OracleDriver orcldriv =new oracle.jdbc.driver.OracleDriver();

			//Class.forName("main.JdbcTest2");

			Class.forName(driver);

			/*
			 * 保证相应的Driver类已经被加载到 jvm中，并且完成了类的初始化工作就行了，而具体是怎样实现这个功能却是没有讲究的。
			 */
			//获取连接
			Connection conn = DriverManager.getConnection(url, user, password);

			java.sql.Statement stmt = conn.createStatement();
			//执行查询
			java.sql.ResultSet rs = stmt.executeQuery(sql);
			
			if (rs.next()) {
				System.out.println(rs.getDate("sysdate"));
				
			}
			//stmt.close();
			//执行操作
			sql = "insert into EMP(EMPNO,ENAME,JOB) values('299','yuming','89')";
		    stmt.executeUpdate(sql);
//		    sql2="select SAL from EMP";
//		    stmt.executeUpdate(sql2);
 //  java.sql.Statement stmt= conn.createStatement();
//		    
////           // psUpdate = conn.prepareStatement(updateSql);\
//		   
//              while(rs.next())
//              { 
//
//    			if (rs.next()) {
//    				System.out.println(rs.getDate("SAL"));
//    			}
            	  
//             {
//               String DNAME = (String)rs.getString("sql2");
//              // String DNAME2 = (String)rs.getString("SAL2");
//               System.out.println("SAL "+SAL);
//               //String id = (String)rs.getString("id");
//               //String dicValueSpell = CnToSpell.getFirstSpell(dicValue);
//               //后台打出汉字和拼音(用********分割)
//               //System.out.println(dicValue + "********"+ CnToSpell.getFirstSpell(dicValue));
//              // psUpdate.setString(1,dicValueSpell);
//               //psUpdate.setString(2,id);
//               //psUpdate.addBatch();
//		    
	//	} 
             
          //   stmt.executeUpdate(sql2);
 		    stmt.close();
 		    }
             catch (Exception e)
             {
			System.out.println(e);
		}

	 }
}