JDBC数据库查询的代码怎么使用之前输入的字符？

Question

import java.sql.*;
import javax.swing.*;
public class stmt {

public static void main(String[] args) {
    String s;
    s=JOptionPane.showInputDialog("请输入s：");
    //这里的输入的s我希望在下面的SQL查询语句用到
        select();
    }
static void select(){
    Connection Conn = DBUtil.open();
    String sql = "SELECT * FROM person where Deptno='s'";
    //Deptno='s' 的s我希望是上面输入的值
    try {
        Statement stmt = Conn.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        while(rs.next()){
          String Pno=rs.getString("Pno");
          System.out.println(Pno);}
    } catch (SQLException e) {
        e.printStackTrace();
    }finally{
        DBUtil.close(Conn);
    }

}

问题写在注释里了，求大神帮忙！

Answer 1

public static void main(String[] args) {
    String s;
    s=JOptionPane.showInputDialog("请输入s：");
    //这里的输入的s我希望在下面的SQL查询语句用到
        select(s);
    }
static void select(String s){
    Connection Conn = DBUtil.open();
    String sql = "SELECT * FROM person where Deptno='"+s+"'";
    //Deptno='s' 的s我希望是上面输入的值
    try {
        Statement stmt = Conn.createStatement();
        ResultSet rs = stmt.executeQuery(sql);
        while(rs.next()){
          String Pno=rs.getString("Pno");
          System.out.println(Pno);}
    } catch (SQLException e) {
        e.printStackTrace();
    }finally{
        DBUtil.close(Conn);
    }

}