Java—JDBC——Java操作数据库实现查询信息的功能

package jbdc;

import java.sql.*;

import tools.DBUtil;

public class _5_6_find {
		public static void main(String[] args) {
			Connection conn = DBUtil.getConn();
			PreparedStatement psmt = null ;
			
			
			//----------------------------------------  查找  ----------------------------------------------------
			
			String sql = "select * from user";
			try {
				psmt = conn.prepareStatement(sql);
				ResultSet rs = psmt.executeQuery();
				while(rs.next()) {
					/*
					//获取数据库表中的内容的方式1————————————通过位置进行获取，位置从1开始的 
						String id = rs.getString(1);
						String name = rs.getString(2);
						String password = rs.getString(3);
						String role = rs.getString(4);
						System.out.println(id+" "+name+" "+password+" "+role);
					*/
					//获取数据库表中的内容的方式2————————————通过表中的列名进行获取
						String id = rs.getString("id");
						String  password= rs.getString("pwd");
						String name = rs.getString("xm");
						String role = rs.getString("role");
						System.out.println(id+" "+password+" "+name+" "+role);
					}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}
		}
}