dbcontentwrite.java

一个小型的BBS系统

package bean.dbwrite;
import java.sql.*;
import bean.condb.*;
public class DBContentWrite {
	Statement stmt;
	ResultSet rs;
	Connection con;
	String id = "-1";
	public DBContentWrite(){
		Condb condb = new Condb();
		this.con = condb.con();
	}
	
	public void DBCW(String url,String author,String title,int floor,String content,String state,String time){
		String sql="insert into formcontent values('"
					+url+"','"
					+author+"','"
					+title+"',"
					+floor+",'"
					+content+"','"
					+state+"',"
					+"0,0,'" 
					+time+"')";
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	
	//更新编辑的帖子
	public void UpdatePost(String id,String floor,String content){
		String sql="update formcontent set [content] ='"+content+"' where floor ="+floor+" and url='"+id+"'";
		
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	
	//更新image字段
	public void UpdateImage(String id,String floor){
		String sql="update formcontent set [image] =[image]+1 where floor ="+floor+" and url='"+id+"'";
		
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			stmt.executeUpdate(sql);
			stmt.close();
		
		}catch(SQLException s){
			System.out.println(s.toString());
		}
	}
	//查找本帖当前楼号
	public int FindFloor(String id){
		String sql="select floor from formcontent where url='"+id+"'";
		int floor=0;
		try{
			stmt=con.createStatement(java.sql.ResultSet.TYPE_SCROLL_INSENSITIVE,java.sql.ResultSet.CONCUR_READ_ONLY);
			rs = stmt.executeQuery(sql);
			while(rs.next()){
				floor = rs.getInt(1);
			}
			
			stmt.close();
			return floor;
		}catch(SQLException s){
			System.out.println(s.toString());
		}
		return floor;
	}
}