newsfirsttitledb3.java

来自「新闻系统的具体的一块」· Java 代码 · 共 24 行

package dao;
import java.sql.*;

public class NewsFirstTitleDB3 {
	public static void main(String[] args) {
		Connection conn=null;
		PreparedStatement pStatement=null;
		try{
			conn=ConnectionManager.getConnection();
			String sql="delete from FirstLeverTitle where TitleName=?";
			pStatement=conn.prepareStatement(sql);		
			pStatement.setString(1,"军事");
			int row=pStatement.executeUpdate();
			System.out.print("成功删除了"+row+"行数据！");
			pStatement.close();
			conn.close();
		} catch(SQLException e){
			e.printStackTrace();
		}finally{
			ConnectionManager.closeAll(null,pStatement,conn);
		}
	}
}