preparedstatmenttest.java

本程序为Java软件开发中

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


public class preparedStatmentTest {
	public static void main(String[] args) throws SQLException {
	preparedStatmentTest p = new preparedStatmentTest();
	Connection conn = p.getOracleConn();
	conn.setAutoCommit(false);
	p.SelectSQL(conn);
	}
	


public static void outPutStu(List inputStu) {
		BufferedWriter write = null;
		Student stu =null;
		try {
			write = new BufferedWriter(new FileWriter("student.txt"));
			for (int i = 0; i < inputStu.size(); i++) {
				stu = (Student) inputStu.get(i);
				write.write(stu.toString() + "\n");
			}
		} catch (IOException e) {
			e.printStackTrace();
		} finally {
			try {
				write.close();
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
	}

	
	public void SelectSQL(Connection conn, String stuNo) throws SQLException {
		PreparedStatement sta = null;
		ResultSet res = null;
		List resList = new ArrayList();
		try {
			String sql = "SELECT FROM STUNO,stuName,stuSex,STUBIRTHDAY,stuAddress from STUDENTINFO ";
			sta = conn.prepareStatement(sql);
			
			res = sta.executeQuery();
			
			while (res.next()) {
				resList.add(new student((String)res.getString("stuNo"),(String)res.getString("stuName"),(String)res.getString("stuSex"),(String)res.getString("stuBirthDay"),(String)res.getString("stuAddress"));
			outPutStu(resList);	
			}
			System.out.println(">>>>>>" + resList.size());
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		} finally {
			if (sta != null)
				try {
					sta.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
			if (conn != null)
				try {
					conn.close();
				} catch (SQLException e) {
					e.printStackTrace();
				}
		}



	}
	
	public Connection getOracleConn() {
    	try {
        	Class.forName("oracle.jdbc.driver.OracleDriver");
        	Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.194:1521:training",
                	"train3","train");
        	conn.setAutoCommit(false);
        	return conn;
        } catch (Exception e) {
        	e.printStackTrace();
        	return null;
        }
    }

}
class student {
	 String stuNo;

	 String stuName;

	 String stuSex;

	 String stuBirthDay;
         String stuAddress;

	public student(String stuNo, String stuName, String stuSex, String stuBirthDay,String stuAddress) {
		this.stuNo = stuNo;
		this.stuName = stuName;
		this.stuSex = stuSex;
		this.stuBirthDay= stuBirthDay;
                this.stuAddress=stuAddress;

	}

	public String toString() {
		return stuNo + ":" + stuName + ":" + stuSex + ":" + stuBirthDay+":"+stuAddress;

	}


public String getstuNo(){
return stuNo;}

public String getstuName(){
return stuName;}

public String getstuSex(){
return stuSex;}



public String stuBirthDay(){
return stuBirthDay;}

public String stuAddress(){
return stuAddress;}
 }