低手勿进
首先我没有藐视低手的意思,因为本人也是个低手,只希望此标题能引起更多人的人来帮我,谢谢大家了!
一个简单的学生信息管理系统,纯JDK编辑的,(数据库连接SQL2000)为什么删除和添加功能可以用,查询和修改功能用不了,总是异常的信息?大家帮我改改啊
//查找功能的实现(表是Coolboy)
if(e.getSource()==subMenu2[0]||e.getSource()==toolBarButton[0])
{
String idid = JOptionPane.showInputDialog( "请输入要查找的学生学号 ");
if(idid.trim()!= " ")
{
String strSQL = "select * from Coolboy where id = ' " + idid + " ' ";
try
{
// rs = st.executeQuery( "select * from Coolboy where id = '2006010123 ' ");
rs = st.executeQuery(strSQL);
int count = 0;
while(rs.next())
{
id = rs.getString( "id ");
name = rs.getString( "name ");
department = rs.getString( "department ");
sex = rs.getString( "sex ");
birthday = rs.getString( "birthday ");
nation = rs.getString( "nation ");
++count;
}
if(count==0)
JOptionPane.showMessageDialog(null, "对不起,没有您要查找的学生! ");
else
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
nationT.setText(nation);
departmentT.setText(department);
birthdayT.setText(birthday);
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, "抱歉,程序出现异常! ");
}
}
}
////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu1[4])
{
closeDB();
System.exit(0);
}
/////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[1] || e.getSource()==toolBarButton[1])
{
JOptionPane.showMessageDialog(null, "请输入要添加的学生信息 ");
idT.setEnabled(true);
idT.setText( " ");
nameT.setText( " ");
sexT.setText( " ");
birthdayT.setText( " ");
nationT.setText( " ");
departmentT.setText( " ");
}
//////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==toolBarButton[5] || e.getSource()==subMenu2[5])
{
if((idT.getText().trim()).equals( " ") || (nameT.getText().trim()).equals( " ") || (sexT.getText().trim()).equals( " ") || (birthdayT.getText().trim()).equals( " ") ||(nationT.getText().trim()).equals( " ") || (departmentT.getText().trim()).equals( " "))
JOptionPane.showMessageDialog(null, "请输入信息再点击提交添加! ");
else
{
id = idT.getText();
name = nameT.getText();
sex = sexT.getText();
birthday = birthdayT.getText();
nation = nationT.getText();
department = departmentT.getText();
String strSQL = "insert into Coolboy(id,name,sex,birthday,nation,department) values( ' " + id + " ', ' " + name + " ', ' " + sex + " ', ' " + birthday + " ', ' " + nation + " ', ' " + department + " ') ";
try
{
st.executeUpdate(strSQL);
}
catch(Exception exx)
{
JOptionPane.showMessageDialog(null, "数据库中已经存在您要添加的学生的学号! ");
/*idT.setText( " ");
nameT.setText( " ");
sexT.setText( " ");
birthdayT.setText( " ");
nationT.setText( " ");
departmentT.setText( " ");*/
return;
}
JOptionPane.showMessageDialog(null, "恭喜您,添加成功了! ");
}
}
////////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[4] || e.getSource()==toolBarButton[4])
{
if((idT.getText().trim()).equals( " ") || (nameT.getText().trim()).equals( " ") || (sexT.getText().trim()).equals( " ") || (birthdayT.getText().trim()).equals( " ") ||(nationT.getText().trim()).equals( " ") || (departmentT.getText().trim()).equals( " "))
{
JOptionPane.showMessageDialog(null, "请输入信息再点击修改! ");
return;
}
else
{
id = idT.getText();
name = nameT.getText();
sex = sexT.getText();
birthday = birthdayT.getText();
nation = nationT.getText();
department = departmentT.getText();
String strSQL = "update Coolboy set name= ' "+name+ " ',sex= ' "+sex+ " ',birthday= ' "+birthday+ " ',nation= ' "+nation+ " ',department= ' "+department+ " ' "+ "where id= ' "+id+ " ' ";
try
{
st.executeUpdate(strSQL);
}
catch(Exception exx)
{
JOptionPane.showMessageDialog(null, "数据库中已经存在您要修改的学生记录! ");
/*idT.setText( " ");
nameT.setText( " ");
sexT.setText( " ");
birthdayT.setText( " ");
nationT.setText( " ");
departmentT.setText( " ");*/
return;
}
JOptionPane.showMessageDialog(null, "恭喜您,修改成功了! ");
}
}
//////////////////////////////////////////////////////////////////////////////////////////
if(e.getSource()==subMenu2[3]||e.getSource()==toolBarButton[3])
{
String idid = JOptionPane.showInputDialog( "请输入要修改的学生学号 ");
if(idid.trim()!= " ")
{
String strSQL = "select * from Coolboy where id = ' " + idid + " ' ";
try
{
//rs = st.executeQuery( "select * from Coolboy where id = '2006010123 ' ");
rs = st.executeQuery(strSQL);
int count = 0;
while(rs.next())
{
id = rs.getString( "id ");
name = rs.getString( "name ");
department = rs.getString( "department ");
sex = rs.getString( "sex ");
birthday = rs.getString( "birthday ");
nation = rs.getString( "nation ");
++count;
}
if(count==0)
JOptionPane.showMessageDialog(null, "对不起,没有您要修改的学生信息! ");
else
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
birthdayT.setText(birthday);
nationT.setText(nation);
departmentT.setText(department);
idT.setEnabled(false);
}
}
catch(Exception ex)
{
JOptionPane.showMessageDialog(null, "抱歉,程序出现异常! ");
}
}
}
以上一实现查询和修改功能总是显示-抱歉,程序出现异常!怎么改?
[解决办法]
低手飘过.....
[解决办法]
代码长看的头晕,
低手飘过...
[解决办法]
关注中
[解决办法]
你把异常信息输出来看看具体是什么
[解决办法]
在执行SQL之前,把它打出来,看看是不是SQL本身有问题.
[解决办法]
出错的堆栈信息打印出来啊!
看看在哪里异常了!
------解决方案--------------------
你把异常贴出来看一下
[解决办法]
您捕捉下异常 把异常信息贴出来行吗?就这么个问题还低手勿进, 害得我想了半天是不是要进来学习下..............
[解决办法]
貌似这段程序不是楼主写的,都不知道怎么把异常输出....
[解决办法]
david2083说的对,你把异常信息贴出来,大家才能给你看问题在哪啊
[解决办法]
垃圾人写垃圾代码,加垃圾提问方式,很般配。
[解决办法]
在你贴上的代码的第4行:if(idid.trim()!= " ") 改成 if(!idid.trim().equals( " "))
至于其他的问题,代码又没有缩进,读起来很累的,你最好把 catch 块中的代码换成 exx.printStackTrace(); 再把控制台上的错误信息贴上来,否则根本没办法看。
[解决办法]
汗,我对不起楼主,我不小心进来了
[解决办法]
程序编译的过么? 如果过了 估计是SQL语句的问题
[解决办法]
把else
{
idT.setText(id);
nameT.setText(name);
sexT.setText(sex);
nationT.setText(nation);
departmentT.setText(department);
birthdayT.setText(birthday);
}
改成 else
{
idT.setText(id);
nameT.setText(name);
departmentT.setText(department);
sexT.setText(sex);
birthdayT.setText(birthday);
nationT.setText(nation);
idT.setEnabled(false);
}看看
[解决办法]
学习
[解决办法]
我是低手,我偏偏进来
[解决办法]
低手
[解决办法]
DatabaseName=Coolboy
你的数据库名也叫Coolboy 吗???
还有,你的sp3或者sp4服务安了吗???????
[解决办法]
要把SqlServer的sp4服务安装,再把JDBC的3个包加进去就可以了.
[解决办法]
板砖
[解决办法]
在每个 判断下面输出个东西
看哪个没执行
再去找错误