dboperate_wenti.java

实现了精品课程的介绍以及上传在下功能的实现。

package aaa;
import java.sql.*;
public class DBOperate_wenti
{
	Statement st;
	Connection con;
	ResultSet rs;
	/*
	public void  connection() throws Exception
	{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:datastruct","root","");
			st=con.createStatement();
	}
	*/
	public void  connection() throws Exception
	{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con=DriverManager.getConnection("jdbc:odbc:datastruct","root","");
			//st=con.createStatement();
			st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
	}
	
	public ResultSet ListWenti() throws Exception//问题列表
	{
		connection();
		rs=st.executeQuery("select * from wenti,user_information where wenti.userID=user_information.userID order by wentiID DESC");
		return rs;
	}
	public ResultSet viewWenti(int id) throws Exception//查看问题
	{
		connection();
		rs=st.executeQuery("select * from wenti,user_information where wenti.userID=user_information.userID and wentiID="+id);
		return rs;
	}
	public ResultSet viewHuifu(int id) throws Exception//查看回复
	{
		connection();
		rs=st.executeQuery("select * from huifu,user_information where huifu.userID=user_information.userID and huifuID="+id);
		return rs;
	}
	public ResultSet ListHuifu(int id) throws Exception//回复列表
	{
		connection();
		rs=st.executeQuery("select * from huifu,user_information where huifu.userID=user_information.userID and wentiID="+id+" order by huifuID ASC");//DESC
		return rs;
	}
	public void AddNewWenti(String title,String content,int userID) throws Exception//提出新问题
	{
		String date=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date());
		connection();
		st.executeUpdate("insert into wenti (userID,wentiTitle,wentiContent,date) values("+userID+",'"+title+"','"+content+"','"+date+"')");
		
	}
	public void AddNewHuifu(int wentiID,String content,int userID) throws Exception//回复
	{
		String date=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date());
		connection();
		st.executeUpdate("insert into huifu (wentiID,userID,huifuContent,date) values("+wentiID+","+userID+",'"+content+"','"+date+"')");
		
	}
	public void UpdateHuifu(int huifuID,String content) throws Exception//修改回复
	{
		String date=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date());
		connection();
		st.executeUpdate("update huifu set huifuContent='"+content+"',editdate='"+date+"' where huifuID="+huifuID);
		
	}
	public void UpdateWenti(int wentiID,String content,String title) throws Exception//修改问题
	{
		String date=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date());
		connection();
		st.executeUpdate("update wenti set wentiTitle='"+title+"' , wentiContent='"+content+"',editdate='"+date+"' where wentiID="+wentiID);
		
	}
	public void DeleteWenti(int wentiID) throws Exception//删除问题
	{
		
		connection();
		st.executeUpdate("delete from wenti  where wentiID="+wentiID);
		st.executeUpdate("delete from huifu  where wentiID="+wentiID);
		
	}
	public void DeleteHuifu(int huifuID) throws Exception//删除回复
	{
		
		connection();		
		st.executeUpdate("delete from huifu  where huifuID="+huifuID);
		
	}
	public void closeCon() throws Exception
	{
		con.close();
	}
}