newsfirsttitledb4.java

新闻系统的具体的一块

package dao;
import java.sql.*;

public class NewsFirstTitleDB4 {
	public static void main(String[] args) {
		Connection conn=null;
		PreparedStatement pStatement=null;
		try{
			conn=ConnectionManager.getConnection();
			String sql="update FirstLeverTitle set Creator=? where Id=?";
			pStatement=conn.prepareStatement(sql);		
			pStatement.setString(1,"编辑");
			pStatement.setInt(2,1);
			int row=pStatement.executeUpdate();
			System.out.print("成功更新了"+row+"行数据！");
		} catch(SQLException e){
			e.printStackTrace();
		}finally{
			ConnectionManager.closeAll(null,pStatement,conn);
		}
	}
}