netnotemanager.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.sncs;

/**
 * <p>Title: wap II</p>
 * <p>Description:添加，删除，修改网络节点的管理类 </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: sxit</p>
 * @author not attributable
 * @version 1.0
 */
import java.util.Vector;
import java.sql.*;

public class NetNoteManager {
	public NetNoteManager () {
	}

	public Vector getNetNotes () {
		Vector notes = new Vector ();
		Connection conn = com.sxit.wap.dacs.DBManager.getConnection ();
		Statement statement = null;
		if ( conn == null )
			return null;
		try {
			statement = conn.createStatement ();
			ResultSet result = statement.executeQuery (
				"select MACH_ID,MACH_NAME,MACH_DESCRIBE,MACH_IP,MACH_PORT from SXIT_WAP_NETSTAT" );
			while ( result.next () ) {
				NetNote netNote = new NetNote ();
				netNote.setMachineID ( result.getString ( 1 ) );
				netNote.setMachineDescribe ( result.getString ( 2 ) );
				netNote.setMachineIP ( result.getString ( 3 ) );
				netNote.setMachineName ( result.getString ( 4 ) );
				netNote.setMacinePort ( result.getString ( 5 ) );
				notes.addElement ( netNote );
			}
		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		} finally {
			com.sxit.wap.dacs.DBManager.freeConnection ( conn, statement );
		}
		return notes;

	}

	public void addNetNotes ( String id, String desc, String ip, String name, String port ) {
		String sql =
			"insert into SXIT_WAP_NETSTAT (MACH_ID,MACH_NAME,MACH_DESCRIBE,MACH_IP,MACH_PORT)values(?,?,?,?,?)";
		Connection conn = com.sxit.wap.dacs.DBManager.getConnection ();
		PreparedStatement statement = null;
		if ( conn == null )
			return;
		try {
			statement = conn.prepareStatement ( sql );
			statement.setString ( 1, id );
			statement.setString ( 2, desc );
			statement.setString ( 3, ip );
			statement.setString ( 4, name );
			statement.setString ( 5, port );
			int res = statement.executeUpdate ();

		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		}
		try {
			statement.close ();
		} catch ( SQLException e2 ) {
			e2.printStackTrace ();
		}
		//javax.swing.UIManager.setLookAndFeel();
	}

	public void delNetNotes ( String id) { //具体根据什么删除还需要讨论
		String sql =
			"delete from SXIT_WAP_NETSTAT where MACH_ID=?";
		Connection conn = com.sxit.wap.dacs.DBManager.getConnection ();
		PreparedStatement statement = null;
		if ( conn == null )
			return;
		try {
			statement = conn.prepareStatement ( sql );
			statement.setString ( 1, id );
			int res = statement.executeUpdate ();

		} catch ( SQLException e1 ) {
			e1.printStackTrace ();
		}
		try {
			statement.close ();
		} catch ( SQLException e2 ) {
			e2.printStackTrace ();
		}
		//javax.swing.UIManager.setLookAndFeel();

	}
	//edit没有关键字段，怎么操作???

}