java中字符串不为空_Java,检查字符串是否不为空并且不为空?

在我的网络应用程序,我有一个搜索字段,我得到一些字符串和组合框。所以,我发送两个参数到远程函数。

我想检查用户输入不为null并且不为空。所以,我可以构造一个有效的查询。

public ArrayList findEmployees(String str, int dep)

throws ClassNotFoundException, SQLException{

System.out.println("List IN");

ArrayList list = new ArrayList();

java.sql.Statement stmt;

java.sql.ResultSet rs;

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost:3306/general";

java.sql.Connection con = DriverManager.getConnection(url, "root", "1234");

System.out.println("URL: " + url);

System.out.println("Connection: " + con);

stmt = con.createStatement();

stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,

ResultSet.CONCUR_READ_ONLY);

String qry = "SELECT * FROM PERSON ";

String werstr = "WHERE";

if(str!= null && str != "**here i want to check the 'str' is empty or not." )

{

qry += werstr + " NAME LIKE '%"+str+"%'";

System.out.println(qry);

werstr = "AND";

}

if(dep != 0)

{

qry += werstr + "dept="+dep;

}

qry += ";";

System.out.println(qry);

rs = stmt.executeQuery(qry);

while (rs.next()) {

Employee employee = new Employee();

String name = rs.getString(2);

employee.setName(name);

int id = rs.getInt(1);

employee.setId(id);

int dept = rs.getInt(4);

employee.setDept(dept);

int age = rs.getInt(3);

employee.setAge(age);

list.add(employee);

}

System.out.println("List Out");

return list;

}

什么是最好的方法呢?

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值