linkdb.java

《Web程序测试实训教程（Java版）》-徐民鹰-源代码

package apply;

import java.sql.*;
import java.util.*;
import com.ConnDB1;

public class LinkDB extends ConnDB1 implements ILinkDB{
	//Connection connection;
    private ArrayList linkdb;
   
    public LinkDB ()throws Exception
    {
        //
    }

    //
      
    public Link getLink (int id)
    {
        try
        {
        	ConnDB1.initialize();	// create database connection
            PreparedStatement preparedStatement = aConnection.prepareStatement (
            "SELECT linkId, linkTitle, linkUrl FROM link " +
            "WHERE linkId = ?");
            preparedStatement.setInt (1, id);
            ResultSet resultSet = preparedStatement.executeQuery ();
            if (resultSet.next ())
            {
            	Link links = new Link
                (
                    resultSet.getInt (1), resultSet.getString (2), resultSet.getString (3)
                );
                preparedStatement.close ();
                ConnDB1.terminate();
                return links;
            }
            else
            {
                preparedStatement.close ();
                ConnDB1.terminate();
                return null;
            }
        }
        catch (SQLException e)
        {
        	ConnDB1.terminate();
            return null;
        }
    }

    public int addLink (Link links)
    {
        int rowsAffected = 0;
        try
        {
        	ConnDB1.initialize();	// create database connection
            PreparedStatement preparedStatement = aConnection.prepareStatement (
            "INSERT INTO link (linkTitle,linkUrl) VALUES (?,?)");
            preparedStatement.setString (1, links.getTitle());
            preparedStatement.setString (2, links.getUrl());
            //鍒ゆ柇鏄