response1.java

mysql+stuts jdbc连接数据库 BBS论坛

package j2eebbs;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
//import java.util.*;
public class Response1 {
	public Connection con = null;
	public PreparedStatement ps = null;

	public Statement stmt = null;

	public ResultSet rs = null;
	public Response1() {
		try {
			Class.forName("com.mysql.jdbc.Driver")
					.newInstance();
			String url = "jdbc:mysql://localhost:3306/bbs";
			String user = "root";
			String password = "bai";
			con = DriverManager.getConnection(url, user, password);
		} catch (Exception e) {
			
		}
	}
		
		
	public int deleteResponse(String id){
		int rst=0;
		try {
			int ids=Integer.parseInt(id);
			stmt=con.createStatement();
			//String sql1= "select from topic where ";
			String sql="delete  from response where topicid="+ids;
			rst=stmt.executeUpdate(sql);
		} catch (SQLException e) {
			
			e.printStackTrace();
		}finally{
			try {
				stmt.close();
			} catch (Exception e) {
				
				System.out.println(e);
			}
		}
		return rst;
	}	

}