jdbc链接数据库操作

最新推荐文章于 2024-01-05 20:21:58 发布

置顶我就是你的小星星

最新推荐文章于 2024-01-05 20:21:58 发布

阅读量233

点赞数

分类专栏：原创文章标签： jdbc 防止sql注入

本文链接：https://blog.csdn.net/qq_34321070/article/details/51597872

版权

原创专栏收录该内容

24 篇文章 0 订阅

订阅专栏

package com.zhu.jdbc;
import java.sql.*;
/**
 * Created by idea on 2016/6/6.
 * 我就是你们的小星星
 */
public class Demo01 {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            String driverClassName = "com.mysql.jdbc.Driver";
            Class.forName(driverClassName);
            String url = "jdbc:mysql://127.0.0.1:3306/mybatis?user=root&password=root";
            conn = DriverManager.getConnection(url);
            ps = conn.prepareStatement("SELECT * FROM USER WHERE id = ?");
            ps.setObject(1 , 1);
            rs = ps.executeQuery();
            while (rs.next()) {
                System.out.println(rs.getObject(1)+" : "+ rs.getObject(2)+" : "+rs.getObject(3));
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        } catch (SQLException e) {
            e.printStackTrace();
        }finally {
            try {
                if (rs != null) {
                    rs.close();
                    rs = null;
                }
                if (ps != null) {
                    ps.close();
                    ps = null;
                }
                if (conn != null) {
                    conn.close();
                    conn = null;
                }
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }
}