jdbc连接例子

来源：互联网发布：淘宝优惠券宣传海报编辑：程序博客网时间：2024/06/07 05:17
package com.b510; 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) {        String driver = "com.mysql.jdbc.Driver";        String dbName = "spring";        String passwrod = "root";        String userName = "root";        String url = "jdbc:mysql://localhost:3308/" + dbName;        String sql = "select * from users";         try {            Class.forName(driver);            Connection conn = DriverManager.getConnection(url, userName,                    passwrod);            PreparedStatement ps = conn.prepareStatement(sql);            ResultSet rs = ps.executeQuery();            while (rs.next()) {                System.out.println("id : " + rs.getInt(1) + " name : "                        + rs.getString(2) + " password : " + rs.getString(3));            }             // 关闭记录集            if (rs != null) {                try {                    rs.close();                } catch (SQLException e) {                    e.printStackTrace();                }            }             // 关闭声明            if (ps != null) {                try {                    ps.close();                } catch (SQLException e) {                    e.printStackTrace();                }            }             // 关闭链接对象            if (conn != null) {                try {                    conn.close();                } catch (SQLException e) {                    e.printStackTrace();                }            }         } catch (Exception e) {            e.printStackTrace();        }    } }
0 0