String filesiteno = request.getParameter("filesiteno");
String usertruthname = request.getParameter("usertruthname");
usertruthname = new String(usertruthname.getBytes("ISO8859_1"));
System.out.println("filesiteno=" + filesiteno);
System.out.println("usertruthname=" + usertruthname);
String sql = "";
sql = "select BF_User.usertruthname,ST_POWER.SiteNO from ST_POWER,BF_User";
if (filesiteno != "") {
if (sql.indexOf("where") == -1) {
sql = sql + " where filesiteno=" + filesiteno + "";
} else {
sql = sql + " and filesiteno=" + filesiteno + " ";
}
}
if (usertruthname != "") {
if (sql.indexOf("where") == -1) {
sql = sql + " where usertruthname like '%" + usertruthname + "%' ";
} else {
sql = sql + " and usertruthname like '%" + usertruthname + "%' ";
}
}
Connect.getConnection();
Connection conn = null;
PreparedStatement pstmt = null;
System.out.println("所执行的语句为" + sql);
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
Vector vector = new Vector();
while (rs.next()) {
Info info = new Info();
info.setsiteno(rs.getString("filesiteno"));
info.setusertruthname(rs.getString("usertruthname"));
vector.add(info);
}
为什么程序走到标红处就出现NULL错误呢?急求
String usertruthname = request.getParameter("usertruthname");
usertruthname = new String(usertruthname.getBytes("ISO8859_1"));
System.out.println("filesiteno=" + filesiteno);
System.out.println("usertruthname=" + usertruthname);
String sql = "";
sql = "select BF_User.usertruthname,ST_POWER.SiteNO from ST_POWER,BF_User";
if (filesiteno != "") {
if (sql.indexOf("where") == -1) {
sql = sql + " where filesiteno=" + filesiteno + "";
} else {
sql = sql + " and filesiteno=" + filesiteno + " ";
}
}
if (usertruthname != "") {
if (sql.indexOf("where") == -1) {
sql = sql + " where usertruthname like '%" + usertruthname + "%' ";
} else {
sql = sql + " and usertruthname like '%" + usertruthname + "%' ";
}
}
Connect.getConnection();
Connection conn = null;
PreparedStatement pstmt = null;
System.out.println("所执行的语句为" + sql);
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery();
Vector vector = new Vector();
while (rs.next()) {
Info info = new Info();
info.setsiteno(rs.getString("filesiteno"));
info.setusertruthname(rs.getString("usertruthname"));
vector.add(info);
}
为什么程序走到标红处就出现NULL错误呢?急求
解决方案 »
- 严重: Exception sending context initialized event to listener instance of class
- 与lucene使用的淑珍中文分词器源码下载
- spring的AOP拦截struts2中的方法问题
- 请问EJB3中如何让EntityBean常驻内存?
- 学习Struts的源码
- sax解析xml内容出现非法xml非法字符----急啊
- 如何制作可拖动的组件
- 如何用servlet调用local接口的sessionbean
- j2ee1.3启动错误,问了好久了也没解决,实在是受不了啊,在线等待~~~
- web项目放到weblogic中 显示乱码
- java调用apache telnet 超时设置问题
- myeclipse显示问号,版本问题?
PreparedStatement pstmt = null;
System.out.println("所执行的语句为" + sql);
pstmt = conn.prepareStatement(sql);你根本就没有得到数据库连接的对象。
把
Connect.getConnection();
Connection conn = null;
写成
Connection conn = Connect.getConnection();
PreparedStatement pstmt = null;