javaee/JavaEEDZY/src/org/zhichunqi/www/Dao.java

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

package org.zhichunqi.www;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.List;


public class Dao {
	//加入评论
	public void insertComment(Comments comments) {
		Connection conn = JDBCConnectionFactory.getConnection();
		String sql = "insert into comments values(null,?,?,?,?,now())";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, comments.getThingid());
			pstmt.setInt(2, comments.getUid());
			pstmt.setString(3, comments.getUname());
			pstmt.setString(4, comments.getContent());
			pstmt.executeUpdate();
		} catch(Exception e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch(SQLException e) {
				e.printStackTrace();
			}
		}
	}
	//加入大家说
	public void insertNews(News news) {
		Connection conn = JDBCConnectionFactory.getConnection();
		String sql = "insert into news values(null,?,?,?,now())";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setInt(1, news.getUid());
			pstmt.setString(2, news.getUname());
			pstmt.setString(3, news.getContent());
			pstmt.executeUpdate();
		} catch(Exception e) {
			e.printStackTrace();
		} finally {
			try {
				conn.close();
			} catch(SQLException e) {
				e.printStackTrace();
			}
		}
	}
	//注册用户
	public void insert(User user) {
		Connection conn = JDBCConnectionFactory.getConnection();
		String sql = "insert into user values(null,?,?,?,?,?,0,now())";
		try {
			PreparedStatement pstmt = conn.prepareStatement(sql);
			pstmt.setString(1, user.getName());