liuyan.java

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

package tom.jiafei;
import java.sql.*;
public class liuyan
{
	String logname,
	       message="";
	       String backNews;
	       Connection con;
	       Statement sql;
         ResultSet rs;
         public liuyan()
         {
         	try
         	{
         		Class.forName("sun.jdbc.odbc.JdbcOdbcDrivers");
         	}
         	catch(ClassNotFoundException e){}
        }
        public void setLogname(String name)
        {
        	logname=name;
        }
        public String getLogname()
        {
        	return logname;
        }
        public String getMessage()
        {
        	return logname;
        }
        public void setMessage(String m)
        {
        	message=m;
        }
        public String getBackNews()
        {
        	return backNews;
        }
        public void setBackNews(String s)
        {
        	backNews=s;
        }
        public void addItem()
        {
        	try
        	{
        		con=DriverManager.getConnection("jdbc:odbc:xfriend","","");
        		sql=con.createStatement();
        		String s="'"+logname+"'"+"'"+"'"+message+"'";
        		String condition="insert into wordpad values="+"("+s+")";
        		sql.executeUpdate(condition);
        		backNews="留言成功 ";
        		con.close();
        	}
        	catch(SQLException e)
        	{
        		backNews="该昵称已存在,请重新输入昵称!";
        	}
        }
      }