补充DAOpackage com.Caboodle;import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;import com.goldgrid.Lian_ku;public class CaboodleDao { public List Caboodlequery(String username){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql="select * from HZ_MYCABOODLE where username='"+username+"' order by id DESC";
//System.out.println(sql);
ResultSet rs;
rs=caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
CaboodleBeen ca = new CaboodleBeen();
ca.setId(Integer.parseInt(rs.getString("id")));
ca.setGroup(rs.getString("groupp"));
ca.setName(rs.getString("namee"));
ca.setMobile(rs.getString("mobile"));
ca.setUsername(rs.getString("username"));
list.add(ca);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List CaboodleTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select * from HZ_MYTABLE";
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
CaboodleBeen_table cabeen = new CaboodleBeen_table();
cabeen.setId(Integer.parseInt(rs.getString("id")));
cabeen.setCaboodle(rs.getString("caboodle"));
list.add(cabeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List ManagerTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select ID,NAME,MOBILE,DEPARTMENTID,DEPARTMENT,PRI_P from HZ_MANAGETABLE";
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
ManagerBeen mabeen = new ManagerBeen();
mabeen.setId(Integer.parseInt(rs.getString("id")));
mabeen.setName(rs.getString("name"));
mabeen.setDepartmentid(rs.getString("departmentid"));
mabeen.setDepartment(rs.getString("department"));
mabeen.setMobile(rs.getString("mobile"));
mabeen.setPri_p(rs.getString("pri_p"));
list.add(mabeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List DepartmentTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select * from HZ_DEPARTMENT";
//System.out.println("DepartmentTable ::::"+sql);
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
DepartmentBeen debeen = new DepartmentBeen();
debeen.setDepart_id(Integer.parseInt(rs.getString("depart_id")));
System.out.println("aaaa==="+Integer.parseInt(rs.getString("depart_id")));
System.out.println("bbb=="+rs.getString("department"));
System.out.println("ccc="+Integer.parseInt(rs.getString("depart_p")));
debeen.setDepartment(rs.getString("department"));
debeen.setDepart_p(Integer.parseInt(rs.getString("depart_p")));
list.add(debeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
}
错误指向 public List DepartmentTable()
请各位高手帮忙....为啥上别人机器就出问题自己机器不问题 实在找不到了
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;import com.goldgrid.Lian_ku;public class CaboodleDao { public List Caboodlequery(String username){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql="select * from HZ_MYCABOODLE where username='"+username+"' order by id DESC";
//System.out.println(sql);
ResultSet rs;
rs=caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
CaboodleBeen ca = new CaboodleBeen();
ca.setId(Integer.parseInt(rs.getString("id")));
ca.setGroup(rs.getString("groupp"));
ca.setName(rs.getString("namee"));
ca.setMobile(rs.getString("mobile"));
ca.setUsername(rs.getString("username"));
list.add(ca);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List CaboodleTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select * from HZ_MYTABLE";
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
CaboodleBeen_table cabeen = new CaboodleBeen_table();
cabeen.setId(Integer.parseInt(rs.getString("id")));
cabeen.setCaboodle(rs.getString("caboodle"));
list.add(cabeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List ManagerTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select ID,NAME,MOBILE,DEPARTMENTID,DEPARTMENT,PRI_P from HZ_MANAGETABLE";
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
ManagerBeen mabeen = new ManagerBeen();
mabeen.setId(Integer.parseInt(rs.getString("id")));
mabeen.setName(rs.getString("name"));
mabeen.setDepartmentid(rs.getString("departmentid"));
mabeen.setDepartment(rs.getString("department"));
mabeen.setMobile(rs.getString("mobile"));
mabeen.setPri_p(rs.getString("pri_p"));
list.add(mabeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
public List DepartmentTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select * from HZ_DEPARTMENT";
//System.out.println("DepartmentTable ::::"+sql);
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
DepartmentBeen debeen = new DepartmentBeen();
debeen.setDepart_id(Integer.parseInt(rs.getString("depart_id")));
System.out.println("aaaa==="+Integer.parseInt(rs.getString("depart_id")));
System.out.println("bbb=="+rs.getString("department"));
System.out.println("ccc="+Integer.parseInt(rs.getString("depart_p")));
debeen.setDepartment(rs.getString("department"));
debeen.setDepart_p(Integer.parseInt(rs.getString("depart_p")));
list.add(debeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
}
错误指向 public List DepartmentTable()
请各位高手帮忙....为啥上别人机器就出问题自己机器不问题 实在找不到了
解决方案 »
- 使用highchart绘制图片,然后通过servlet跳转却不能导出图片
- 数据库面试题:求解
- JSP+SQLSERVE 登陆模块源码 在线等
- 用 structs 在 jsp 里面如何将 bean 的值写入 hidden 的 input ?
- 不能 更新
- 如何读取<a href=ff.jsp?name=英雄>点击</a>中name的值?
- 大家有看过Jdon框架的吗
- 问一个连接sqlserver的问题
- 在页面提交之后下一个页面出现之前,如何在这段时间里显示一个“操作正在进行,请稍等”的提示页面?
- 我的tomcat以前很好用,近来可让我头大了!
- ENCTYPE="multipart/form-data的问题!?急
- 关于dwr框架返回值
异常说的是数字类型的format错误,请去检查org.apache.jsp.myCaboodle.insert_jsp._jspService(insert_jsp.java:71)
这个java是你那个jsp编译之后的文件,71行那里出的问题,该文件所在目录一般是tomcat/work/……
另外,请检查你本机和别人机器上的JDK版本,版本不同也会造成程序运行差异
自己看下是不是格式有问题
主要是在我机器上没有错误
而这个程序得给客户安啊 安装他们那里就出现上面所说的错误了
错误主要出现在
org.apache.jsp.myCaboodle.insert_jsp._jspService(insert_jsp.java:71)
就是
List department = cadao.DepartmentTable();---------------------------------------------------------
错误
java.lang.Integer.parseInt(Integer.java:415)
java.lang.Integer.parseInt(Integer.java:497)
com.Caboodle.CaboodleDao.DepartmentTable(CaboodleDao.java:100)
就是DAO里面的public List DepartmentTable(){
List list = new ArrayList();
Lian_ku caboodleDBC = new Lian_ku();
String sql = "select * from HZ_DEPARTMENT";
//System.out.println("DepartmentTable ::::"+sql);
ResultSet rs = null;
rs = caboodleDBC.executeQuery(sql);
try {
while(rs.next()){
DepartmentBeen debeen = new DepartmentBeen();
debeen.setDepart_id(Integer.parseInt(rs.getString("depart_id")));
debeen.setDepartment(rs.getString("department"));
debeen.setDepart_p(Integer.parseInt(rs.getString("depart_p")));
list.add(debeen);
}
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
finally{
caboodleDBC.close();
}
return list;
}
}
所说的行是debeen.setDepart_p(Integer.parseInt(rs.getString("depart_p")));
但依然没有弄明白那里错了 在我机器上和我同事的机器上还是没有错误 但在他们那里还是我说的这个错误
但我想应该不是这个问题吧?今天早上我下载了一个 TOMCAT 5.0.25 放到我的机器上运行 短信程序 结果还是一个错误都没有
所以我盲目了..请各位高手帮帮