publicword.java

一个完善的班级网站的实现

//负责公共留言的beans
package tom.jiafei;
import java.sql.*;
public class PublicWord{
String logname="",
       message="";
String backNews;
Connection con;
ResultSet rs;
Statement sql;
public PublicWord(){//加载桥接器
    try{
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       }
        catch(ClassNotFoundException e){}
}
//设置属性值、获取属性值的方法
public void setLogname(String name)
{  
	logname=name;
}
public String getLogname(String name)
{  return logname;
}
public String getMessage( )
{  
	return message;
}
public void setMessage(String m)
{  
	message=m;
}
public String getBackNews()
{  
	return backNews;
}
public void setBackNews(String s)
{   
	backNews=s;
}
//添加记录到数据库的 wordpad表中
public void addItem()
{try{
    con=DriverManager.getConnection("jdbc:odbc:friend","","");
    sql=con.createStatement();
    String s="'"+logname+"'"+"'"+"'"+message+"'";
    String condition="INSERT INTO wordpad VALUE"+"("+s+")";
    sql.executeUpdate(condition);
    backNews="添加成功了";
    con.close();
}
catch(SQLException e)
{//由于表wordpad和member表通过字段logname 做了关联,所以如果输入的logname不对，会出现异常
	backNews="你没有登陆，不能留言";
}
}
}