jdbc.java

一个进销存的系统

package com.jdbcpreject;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.Statement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.DriverManager;
public class Jdbc {

	/**
	 * @param args
	 */
	public static void main(String[] args) throws SQLException{
		// TODO Auto-generated method stub
		Connection connection = null;
		PreparedStatement statement = null;//建立一个PreparedStatement对象
//		String sql = "select * from productnew";
		ResultSet rset = null;
		try{
			 connection=fetchConnection();
			 String sql = "SELECT * FROM productnew WHERE price >= ?";
			 statement = connection.prepareStatement(sql);
			 statement.setLong(1, 3);
			 rset = statement.executeQuery();
			while(rset.next())
			{
		   System.out.println("PRODUCTID   "+rset.getLong("PRODUCTID")+"\n"+"PRODUCTNAME    "+rset.getString("productname"));
			}//获取结果集中的数据

		}catch(Exception e){
			e.printStackTrace();
		}
		finally{
			rset.close();  //关闭数据库连接
			statement.close();  //关闭数据库连接
			connection.close();  //关闭数据库连接
		}
		
	}
public static Connection fetchConnection(){
	try{
		Class.forName("oracle.jdbc.driver.OracleDriver"); //载入JDBC driver
		String url="jdbc:oracle:thin:@192.168.116.17:1521:orcl"; //不同类型的JDBC driver对应不同格式的url
		String user ="9902zhlb";
		String pwb="111111";
		System.out.println("zhand"); 
		return DriverManager.getConnection(url,user,pwb);//与数据库建立连接
	}	
	catch(Exception e)
	{
		e.printStackTrace();
		System.out.println("zhangdddd"); 
		return null;
	}
}
}