JSP+SQL2000精品课程网站

package aaa; import java.sql.*; public class DBOperate_wenti { Statement st; Connection con; ResultSet rs; public void connection() throws Exception { Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver"); con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=db_net", "qyadmin","166424"); st=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); } public ResultSet ListWenti() throws Exception//问题列表 { connection(); rs=st.executeQuery("select * from tb_question,tb_userinformation where tb_question.q_id=tb_userinformation.id order by tb_question.q_id DESC"); return rs; } public ResultSet viewWenti(int id) throws Exception//查看问题 { connection(); rs=st.executeQuery("select * from tb_question,tb_userinformation where tb_question.q_id=tb_userinformation.id and tb_question.q_id="+id); return rs; } public ResultSet viewHuifu(int id) throws Exception//查看回复 { connection(); rs=st.executeQuery("select * from tb_answer,tb_userinformation where tb_answer.a_id=tb_userinformation.id and tb_answer.a_id="+id); return rs; } public ResultSet ListHuifu(int id) throws Exception//回复列表 { connection(); rs=st.executeQuery("select * from tb_answer,tb_userinformation where tb_answer.a_id=tb_userinformation.id and tb_question.q_id="+id+" order by tb_answer.a_id ASC");//DESC return rs; } public void AddNewWenti(String title,String content) throws Exception//提出新问题 { String date=new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new java.util.Date()); connection(); st.executeUpdate("insert into tb_question (title,content,createtime) values("+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 tb_answer (q_id,user_id,content,createtime) 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 tb_answer set content='"+content+"',createtime='"+date+"' where q_id="+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 tb_question set title='"+title+"' , content='"+content+"',createtime='"+date+"' where q_id="+wentiID); } public void DeleteWenti(int wentiID) throws Exception//删除问题 { connection(); st.executeUpdate("delete from tb_question where q_id="+wentiID); st.executeUpdate("delete from tb_answer where q_id="+wentiID); } public void DeleteHuifu(int huifuID) throws Exception//删除回复 { connection(); st.executeUpdate("delete from tb_answer where a_id="+huifuID); } public void closeCon() throws Exception { con.close(); } public static void main(String[] args) throws SQLException, Exception{ DBOperate_wenti d = new DBOperate_wenti(); ResultSet rs=d.ListWenti(); System.out.println(rs); rs.close(); } }