adddaoimp.java

来自「JAVA视频播放器 源码相当详细 功能强大」· Java 代码 · 共 44 行

package com.video.add.dao.jdbc;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import javax.sql.DataSource;

import com.video.add.dao.AddDao;

public class AddDaoImp implements AddDao {
	Connection conn = null;
	private void closeConnection() {
		try {
			conn.close();
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
	}
	@Override
	public int addSp(DataSource ds, String name, String url, String remark) {
		int rs=0;
		try {
			conn = ds.getConnection();
			PreparedStatement ps = conn
			.prepareStatement("insert into sp(url,name,remark)values(?,?,?)");			
			ps.setString(1,url);	
			ps.setString(2,name);	
			ps.setString(3,remark);	
		
			rs = ps.executeUpdate();
			System.out.println("增加成功"+rs);
		} catch (SQLException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}finally {
			closeConnection();
		}
		return rs;
	}

}