package?dao;

import?java.sql.Connection;
import?java.sql.DriverManager;
import?java.sql.PreparedStatement;
import?java.sql.ResultSet;
import?java.sql.SQLException;
import?java.util.ArrayList;
import?java.sql.Date;
import?java.util.List;

import?javabean.journalism;
import?javabean.product;
import?javabean.user;




public?class?journalism_method?{
	Connection?con;
	PreparedStatement?pre;
	ResultSet?rs;
	public?journalism_method（）
	{
		try?{
			Class.forName（“com.mysql.jdbc.Driver“）;
		}?catch?（ClassNotFoundException?e）?{
			e.printStackTrace（）;
		}
		try?{
			con=DriverManager.getConnection（“jdbc:mysql://127.0.0.1:3306/enterprise?useUnicode=true&characterEncoding=utf8““root““1244148128“）;
		}?catch?（SQLException?e）?{
			e.printStackTrace（）;
		}
	}
	
	/**
	?*?@author?help
	?*?
	?*顯示所有記錄
	?*?@return?
	?*/
	public?List?getSearch（String?sql）
	{
		List?list?=?new?ArrayList（）;
		
		//獲取prepareStatement對象
		try?{
			pre?=?con.prepareStatement（sql）;
			rs?=pre.executeQuery（）;
			
			while（rs.next（））
			{
				journalism?journalism?=new?journalism（）;
				journalism.setJournalism_id（rs.getInt（“journalism_id“））;
				journalism.setUserid（rs.getInt（“userid“））;
				journalism.settitle（rs.getString（“title“））;
				journalism.setPicture（rs.getString（“picture“））;
				journalism.setContent（rs.getString（“content“））;
				journalism.setDate（rs.getDate（“date“））;
				list.add（journalism）;
			}
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		
		finally
		{
			try?{
				pre.close（）;
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		return?list;
	}
	
	/**
	?*?@author?help
	?*?
	?*更新某一條記錄
	?*?@return?
	?*/
	public?int?getUpdate（String?sqljournalism?journalism）
	{??
		int?count?=0;
		try?{
			pre?=?con.prepareStatement（sql）;
			pre.setInt（6journalism.getJournalism_id（））;
			pre.setInt（1journalism.getUserid（））;
			pre.setString（2journalism.gettitle（））;
			pre.setString（3journalism.getPicture（））;
			pre.setString（4journalism.getContent（））;
			pre.setDate（5new?Date（journalism.getDate（）.getTime（）））;
			count?=?pre.executeUpdate（）;
		}?catch?（SQLException?e）?{
			//?TODO?Auto-generated?catch?block
			e.printStackTrace（）;
		}
		finally
		{
			try?{
				pre.close（）;
				con.close（）;
			}?catch?（SQLException?e）?{
				//?TODO?Auto-generated?catch?block
				e.printStackTrace（）;
			}
		}
		return?count;
	}
	
	
	
	
	/**
	?*?@author?help
	?*?
	?*插入新的一條記錄
	?*?@return?
	?*/
	public?int?getInsert（String?sqljournalism?journalism）
	{
		int?count?=0;
		try?{
			pre?=?con.prepareStatement（sql）;
			pre.setInt（1journalism.getUserid（））;
			pre.setString（2journalism.gettitle（））;
			pre.setString（3journalism.getPicture（））;
			pre.setString（4journalism.getContent（））;
			pre.setDate（5new?Date（journalism.getDate（）.getTime（）））;
			count=p

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2020-04-26?08:42??網(wǎng)上商城系統(tǒng)\
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\
?????文件????????1133??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.classpath
?????文件????????1064??2019-11-04?20:25??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.project
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\
?????文件?????????564??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\.jsdtscope
?????文件?????????364??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\org.eclipse.jdt.core.prefs
?????文件?????????501??2019-11-04?20:25??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\org.eclipse.wst.common.component
?????文件?????????398??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\org.eclipse.wst.common.project.facet.core.xml
?????文件??????????49??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\org.eclipse.wst.jsdt.ui.superType.container
?????文件???????????6??2019-10-31?15:12??網(wǎng)上商城系統(tǒng)\enterprise?1.0\.settings\org.eclipse.wst.jsdt.ui.superType.name
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\dao\
?????文件????????4453??2019-12-24?04:09??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\dao\journalism_method.java
?????文件????????2971??2019-12-22?04:36??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\dao\order_method.java
?????文件????????4530??2019-12-24?03:05??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\dao\product_method.java
?????文件????????3855??2019-12-06?10:29??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\dao\user_method.java
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\javabean\
?????文件?????????974??2019-12-24?02:16??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\javabean\journalism.java
?????文件?????????776??2019-12-17?19:16??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\javabean\order.java
?????文件????????1159??2019-11-30?19:54??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\javabean\product.java
?????文件?????????716??2019-12-14?20:07??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\javabean\user.java
?????目錄???????????0??2020-04-26?08:41??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\
?????文件????????2521??2019-12-24?02:15??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\journalism_add.java
?????文件????????1583??2019-12-24?01:46??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\journalism_delete.java
?????文件????????1914??2019-12-12?16:22??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\journalism_select.java
?????文件????????1927??2019-12-24?03:44??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\journalism_updata.java
?????文件????????2497??2019-12-24?03:58??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\journalism_updata2.java
?????文件????????1782??2019-12-20?11:09??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\order_add.java
?????文件????????1536??2019-12-24?01:46??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\order_del.java
?????文件????????2196??2019-12-14?22:35??網(wǎng)上商城系統(tǒng)\enterprise?1.0\src\servlet\order_generate.java
............此處省略220個文件信息