⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 maplecustomquest.java.svn-base

📁 冒险岛私服Java版服务端(Odinms)源代码。学习JAVA开发的朋友
💻 SVN-BASE
📖 第 1 页 / 共 3 页
字号:
🔍
123 
			psa.executeUpdate();

			psr.close();
			psa.close();
			con.close();*/
		
		/* BOWMAN
		 int questid = 100002;

		Properties dbProps = new Properties();
		dbProps.load(new FileReader("db.properties"));
		DatabaseConnection.setProps(dbProps);
		Connection con = DatabaseConnection.getConnection();
		PreparedStatement psr = con.prepareStatement("INSERT INTO questrequirements VALUES (DEFAULT, ?, ?, ?)");
		PreparedStatement psa = con.prepareStatement("INSERT INTO questactions VALUES (DEFAULT, ?, ?, ?)");
		psr.setInt(1, questid);
		psa.setInt(1, questid);
		MapleCustomQuestData data;
		MapleCustomQuestData dataEntry;
		ByteArrayOutputStream bos = new ByteArrayOutputStream();
		ObjectOutputStream oos = new ObjectOutputStream(bos);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100001, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();
		
		questid = 100001;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100000, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 30, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, null);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -30, dataEntry));
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		questid = 100000;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("job", null, null);
		data.addChild(new MapleCustomQuestData("0", MapleJob.BOWMAN.getId(), data));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("lvmin", 30, null);
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031010, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031010, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		psr.close();
		psa.close();
		con.close();*/
		
		// WARRIOR
		/*int questid = 100005;

		Properties dbProps = new Properties();
		dbProps.load(new FileReader("db.properties"));
		DatabaseConnection.setProps(dbProps);
		Connection con = DatabaseConnection.getConnection();
		PreparedStatement psr = con.prepareStatement("INSERT INTO questrequirements VALUES (DEFAULT, ?, ?, ?)");
		PreparedStatement psa = con.prepareStatement("INSERT INTO questactions VALUES (DEFAULT, ?, ?, ?)");
		psr.setInt(1, questid);
		psa.setInt(1, questid);
		MapleCustomQuestData data;
		MapleCustomQuestData dataEntry;
		ByteArrayOutputStream bos = new ByteArrayOutputStream();
		ObjectOutputStream oos = new ObjectOutputStream(bos);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100004, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();
		
		questid = 100004;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("quest", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 100003, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("state", MapleQuestStatus.Status.COMPLETED.getId(), dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();
		
		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 30, dataEntry));
		psr.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, null);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031013, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -30, dataEntry));
		dataEntry = new MapleCustomQuestData("1", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031012, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		questid = 100003;

		psr.setInt(1, questid);
		psa.setInt(1, questid);

		data = new MapleCustomQuestData("job", null, null);
		data.addChild(new MapleCustomQuestData("0", MapleJob.WARRIOR.getId(), data));
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("lvmin", 30, null);
		psr.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psr.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psr.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031008, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", 1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.NOT_STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
		psa.executeUpdate();

		data = new MapleCustomQuestData("item", null, null);
		dataEntry = new MapleCustomQuestData("0", null, data);
		data.addChild(dataEntry);
		dataEntry.addChild(new MapleCustomQuestData("id", 4031008, dataEntry));
		dataEntry.addChild(new MapleCustomQuestData("count", -1, dataEntry));
		psa.setInt(2, MapleQuestStatus.Status.STARTED.getId());
		bos = new ByteArrayOutputStream();
		oos = new ObjectOutputStream(bos);
		oos.writeObject(data);
		oos.flush();
		psa.setBlob(3, new ByteArrayInputStream(bos.toByteArray()));
123

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -