articledao.java

来自「实现银行系统中某个部门的计算机设备管理、公共信息管理、权限用户管理、系统设置等,」· Java 代码 · 共 21 行

package com.isoftstone.banktearm1.dao;
import com.isoftstone.banktearm1.db.*;
import com.isoftstone.banktearm1.vo.BankTeam1ArticleVo;

import java.sql.*;
/*
 * 文章添加的DAO04作成
 * 
 */
public class ArticleDao extends DB{
	public void addArticle(BankTeam1ArticleVo myvo)throws SQLException, ClassNotFoundException{
		Connection cn=this.getConnection();
		Statement stmt=cn.createStatement();
		String sql="insert into article(art_title,art_title2,art_abstract,author_id,author_name,deliver_time,art_content) values('"+myvo.getArt_title()+"','"+myvo.getArt_title2()+"','"+
					myvo.getArt_abstract()+"','"+myvo.getAuthor_id()+"','"+myvo.getAuthor_name()+"','"+
					myvo.getDeliver_time()+"','"+myvo.getArt_content()+"')";
		stmt.execute(sql);
		this.closs(stmt, cn);
	}
}