使用 jdbc 从数据库中查询数据

package jdbcTest;

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


public class JdbcTest {

	public static void main(String[]args){
		//数据库链接
		Connection Connection = null;
		//预编译的Statement，通过Statement 操作数据库
		PreparedStatement ps = null;
		//结果集
		ResultSet R = null;
		try {
			//加载数据库驱动
			Class.forName("com.mysql.jdbc.Driver");
			//通过驱动管理类，获取数据库链接
			try {
				Connection = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring","root","root");
				//定义sql 语句
				String sql = "select * from user where name=?";
				//获取预处理statement
				ps = Connection.prepareStatement(sql);
				//设置参数，第一个参数为 sql 语句中参数的序号，第二个参数为设置的参数值
				ps.setString(1, "mx");
				//向数据库发出 sql 查询，返回查询结果集
				R = ps.executeQuery();
				while(R.next()){
					System.out.println(R.getString("id")+"  "+R.getString("name")+"   "+R.getString("password"));
				}
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				e.printStackTrace();
			}finally{
				//释放资源
				if(R!=null){
					try {
						R.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
				if(ps!=null){
					try {
						ps.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
				if(Connection!=null){
					try {
						Connection.close();
					} catch (SQLException e) {
						// TODO Auto-generated catch block
						e.printStackTrace();
					}
				}
			}
			
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
}