jdbc编程之数据查询

来源：互联网发布：儿童散光数据编辑：程序博客网时间：2024/06/05 05:42

先把jar包下载好，并倒入工程

package com.bupt.jdbc;import java.sql.Connection;import java.sql.DriverManager;import java.sql.ResultSet;import java.sql.Statement;public class JDBCTest {public static void main(String[] args) {String sql = "SELECT * FROM tbl_user";Connection conn = null;//数据库连接Statement st = null;//用于执行查询ResultSet rs = null;//结果集合try {Class.forName("com.mysql.jdbc.Driver");//加载驱动conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/jsp_db?useSSL=false", "root", "19930614");//打开连接st = conn.createStatement();//执行查询rs = st.executeQuery(sql);while(rs.next()){//处理结果System.out.print(rs.getInt("id")+" ");System.out.print(rs.getString("name")+" ");System.out.print(rs.getString("password")+" ");System.out.print(rs.getString("email")+" ");System.out.println();}} catch (Exception e) {e.printStackTrace();}finally{try {//清理环境rs.close();} catch (Exception e2) {e2.printStackTrace();}try {st.close();} catch (Exception e3) {e3.printStackTrace();}try {conn.close();} catch (Exception e4) {e4.printStackTrace();}}}}

0 0