81,092
社区成员
发帖
与我相关
我的任务
分享
public class Test {
public static void main(String[] args) throws Exception{
JdbcUtil util=new JdbcUtil();
Connection conn = null;
PreparedStatement ps =null;
ResultSet rs=null;
String name="生活";
String sql="select * from devSortInfo where sortName like ?";
conn=util.getConnection();
ps=conn.prepareStatement(sql);
// ps.setString(1, "%"+name+"%");
ps.setString(1, "%"+name);
rs = ps.executeQuery();
while(rs.next()){
System.out.println(rs.getString("sortName"));
}
}
}