lubussinesslogicbean.java

初期制作

/*
 * Created on 2005-8-25
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package ch01;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.List;
import java.util.Vector;



/**
 * @author ddsoft
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class LuBussinessLogicBean {
	public List search() throws SQLException {

		Connection conn = null;
        List a = new Vector();
		//1. 注册或加载JDBC驱动程序
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		//2.建立连接
		String URL = "jdbc:oracle:thin:@localhost:1521:ora92";
		conn = DriverManager.getConnection(URL, "system", "ora92");
		
		String query = "select 姓名,年龄 from cjw";
		PreparedStatement  pst =conn.prepareStatement(query);
		
		
		ResultSet rs=pst.executeQuery();System.out.println("sql : " + query);
		while (rs.next())
		{
			LuJavaBean ljb = new LuJavaBean();
			ljb.setName(rs.getString("姓名"));
			ljb.setYear(rs.getString("年龄"));
			a.add(ljb);
			
		}
		conn.close();
		pst.close();
		return a;
	}

	public List insert(String sa,String sb) throws SQLException{
		Connection conn = null;
		PreparedStatement stmt =null;
        List a = new Vector();
		//1. 注册或加载JDBC驱动程序
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		//2.建立连接
		String URL = "jdbc:oracle:thin:@localhost:1521:ora92";
		conn = DriverManager.getConnection(URL, "system", "ora92");
		

		String  aaa ="insert into CJW values(?,?)";

		stmt = conn.prepareStatement(aaa);
		stmt.setString(1,sa);
		stmt.setString(2,sb);
		stmt.executeUpdate();
		conn.close();
		stmt.close();
		return a;
	}
	public List delete(String sc) throws SQLException{
		Connection conn = null;
		PreparedStatement stmt =null;
        List a = new Vector();
		//1. 注册或加载JDBC驱动程序
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		//2.建立连接
		String URL = "jdbc:oracle:thin:@localhost:1521:ora92";
		conn = DriverManager.getConnection(URL, "system", "ora92");
		

		String  aaa ="delete from cjw where 年龄=?";

		stmt = conn.prepareStatement(aaa);
		stmt.setString(1,sc);
		stmt.executeUpdate();
		conn.close();
		stmt.close();
		return a;
	}
	public List upupdate(String sd) throws SQLException{
		Connection conn = null;
		PreparedStatement stmt =null;
        List a = new Vector();
		//1. 注册或加载JDBC驱动程序
		DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
		//2.建立连接
		String URL = "jdbc:oracle:thin:@localhost:1521:ora92";
		conn = DriverManager.getConnection(URL, "system", "ora92");
		

		String  aaa ="update cjw set 姓名='win', 年龄='88' where 姓名=?";

		stmt = conn.prepareStatement(aaa);
		stmt.setString(1,sd);
		stmt.executeUpdate();
		conn.close();
		stmt.close();
		return a;
	}
}