请教!!高手指点!
nmywg 2004-03-19 04:33:16 看看这个程序有什么错误啊.一编译就提示错误.提示如下:
"Register.java:75: 'class' or 'interface' expected
public void addItem()
^
1 error"
错误行我以标出了.请高手指点.为什么啊?
====================
package tom.jiafei;
import java.sql.*;
public class Register
{ String logname="",
password="",
sex="",age="",
email="",
phone="",
address="",
message="";
String backNews;//用来返回注册是否成功.
Connection con;
Statement sql;
ResultSet sql;
ResultSet rs;
public Register()
{ try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//加载桥接器.
}
catch(ClassNotFoundException e){}
}
//设置属性值、获取属性值的方法。
public void setLogname(String name)
{ logname=name;
}
public String setLogname()
{return logname;
}
public void setAge(String n)
{age=n;
}
public String getAge()
{return age;
}
public void setSex(String s)
{ sex=s;
}
public String getSex()
{ return sex;
}
public void setPassword(String pw)
{password=pw;
}
public String getPassword()
{ return password;
}
public void setEmail(String em)
{email=em;
}
public String getEmil()
{return email;
}
public void setPhone(String ph)
{phone=ph;
}
public String getPhone()
{return phone;
}
public void setAddress(String ad)
{address=ad;
}
public String getAddress()
{return message;
}
public void setMessage(String m)
{message=m;
}
public String getBackNews()
{return backNews;
}
public void setBackNews(String s)
{backNews=s;
}
}
//添加记录到数据库的member表。
=====================================================提示发生的错误行
public void addItem()
{try{
con=DriverManager.getConnection("jdbc:odbc:friend","","");
sql=con.createStatement();
if (phone.length()==0) //如果用户没有提供电话。
{phone="无";
}
if (email.length()==0)
{email="无";
}
if (address.length()==0)
{address="无";
}
if (message.length()==0)
{message="无";
}
String s=
"'"+logname+"'"+","+"'"+password+"'"+","+"'"+sex+"'"+","+"'"+age+"'"+","+
"'"+phone+"'"+","+"'"+email+"'"+","+"'"+address+"'"+","+"'"+message+"'";
String condition="INSERT INTO member VALUES"+"("+s+")";
sql.executeUpdate(condition);
backNews="注册成功了";
con.close();
}
catch(SQLException e)
{// 如果用户使用member表中已经存在的名字,或使用了空字段值,就会发生SQL异常。
backNews="你还没有注册,或该用户已经存在,请你更换一个名字";
}
}