loginselect.java

此社区管理系统是我们实习期间做的一个项目

package community.login;


import java.sql.*;

import community.DBConnectionManager;
import community.dbutil;
public class loginselect {
	public void select(){
		String sql="select yhname,mima,gltype from glyxxb ";
		Connection conn=DBConnectionManager.getConnection();
		PreparedStatement pstmt=null;
		try {
			pstmt=conn.prepareStatement(sql);
			ResultSet rs=pstmt.executeQuery();
			while(rs.next()){
				System.out.println(rs.getString("name"));
			}
			dbutil.close(rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally{
			dbutil.close(pstmt);
			dbutil.close(conn);
		}
		
	}

}