test.java

来自「jsp+servlet实现的OCR识别系统简单功能」· Java 代码 · 共 46 行

package com.db;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class Test {

	/**
	 * @param args
	 */
	
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		PreparedStatement stmt=null;
		ResultSet rs=null;
		Connection  con=Connectionmysql.getconnection();
	    String sql="select * from consume";
	    try {
			 stmt=con.prepareStatement(sql);
			 rs=stmt.executeQuery();
			 while(rs.next()){
				 String tel=rs.getString(2);
				 System.out.println(tel);
			 }
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	    finally{
	    	try {
				rs.close();
				stmt.close();
		    	con.close();
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
	    	
	    }
	    
	}

}