关于jdbc中处理sql语句的引号问题笔记

今天在学习jdbc的时候，发现java中定义的sql语句有时候会有些引号上的问题

所以进行研究。

package com.nd.jdbc;

import java.sql.*;
import java.util.Scanner;

public class biji {
    public static void main(String[] args) {
        Connection conn = null;
        PreparedStatement ps = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/hardgo","root","77625");//gets the databese connection object
            String sql = "select * from ?";
            ps = conn.prepareStatement(sql);
            ps.setString(1,"smith");
            rs = ps.executeQuery();
            while(rs.next()){
                System.out.println("eno:" + rs.getString("empno") + " ename:" + rs.getString("ename"));
            }
        } catch (Excep