拉sjhaliluya的数据库代码

最新推荐文章于 2024-09-15 19:32:11 发布
最新推荐文章于 2024-09-15 19:32:11 发布
阅读量117 收藏
点赞数 2
文章标签： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/www_oracle_com/article/details/140073870
版权 
package a;

import java.io.BufferedReader;
import java.io.File;
import java.io.FileWriter;
import java.io.InputStreamReader;
import java.net.URL;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

public class Main {
	private static String[] s66 = { "创世记", "出埃及记", "利未记", "民数记", "申命记", "约书亚记", "士师记", "路得记", "撒母耳记上", "撒母耳记下", "列王纪上",
			"列王纪下", "历代志上", "历代志下", "以斯拉记", "尼希米记", "以斯帖记", "约伯记", "诗篇", "箴言", "传道书", "雅歌", "以赛亚书", "耶利米书", "耶利米哀歌",
			"以西结书", "但以理书", "何西阿书", "约珥书", "阿摩司书", "俄巴底亚书", "约拿书", "弥迦书", "那鸿书", "哈巴谷书", "西番雅书", "哈该书", "撒迦利亚书", "玛拉基书",
			"马太福音", "马可福音", "路加福音", "约翰福音", "使徒行传", "罗马书", "哥林多前书", "哥林多后书", "加拉太书", "以弗所书", "腓立比书", "歌罗西书", "帖撒罗尼迦前书",
			"帖撒罗尼迦后书", "提摩太前书", "提摩太后书", "提多书", "腓利门书", "希伯来书", "雅各书", "彼得前书", "彼得后书", "约翰壹书", "约翰贰书", "约翰叁书", "犹大书",
			"启示录" };

	public static void main(String[] args) {
		try {
			for (int k = 1; k <= 50; k++) {
				URL url = new URL("http://sj.haliluya.com/Genesis_1_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[0] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");
							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);

							}
						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

		try {
			for (int k = 1; k <= 40; k++) {
				URL url = new URL("http://sj.haliluya.com/Exodus_2_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[1] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

		try {
			for (int k = 1; k <= 27; k++) {
				URL url = new URL("http://sj.haliluya.com/Leviticus_3_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[2] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 36; k++) {
				URL url = new URL("http://sj.haliluya.com/Numbers_4_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[3] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 34; k++) {
				URL url = new URL("http://sj.haliluya.com/Deuteronomy_5_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[4] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 24; k++) {
				URL url = new URL("http://sj.haliluya.com/Joshua_6_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[5] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 21; k++) {
				URL url = new URL("http://sj.haliluya.com/Judges_7_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[6] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/Ruth_8_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[7] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 31; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Samuel_9_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[8] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 24; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Samuel_10_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[9] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 22; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Kings_11_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[10] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 25; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Kings_12_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[11] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 29; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Chronicles_13_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[12] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 36; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Chromicles_14_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[13] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 10; k++) {
				URL url = new URL("http://sj.haliluya.com/Ezra_15_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[14] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 13; k++) {
				URL url = new URL("http://sj.haliluya.com/Nehemiah_16_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[15] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 10; k++) {
				URL url = new URL("http://sj.haliluya.com/Esther_17_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[16] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 42; k++) {
				URL url = new URL("http://sj.haliluya.com/Job_18_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[17] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 150; k++) {
				URL url = new URL("http://sj.haliluya.com/Pshlms_19_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[18] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 31; k++) {
				URL url = new URL("http://sj.haliluya.com/Proverbs_20_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[19] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 12; k++) {
				URL url = new URL("http://sj.haliluya.com/Ecclesiastes_21_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[20] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 8; k++) {
				URL url = new URL("http://sj.haliluya.com/Song-of-Songs_22_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[21] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 66; k++) {
				URL url = new URL("http://sj.haliluya.com/Isaiah_23_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[22] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 52; k++) {
				URL url = new URL("http://sj.haliluya.com/Jeremiah_24_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[23] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 5; k++) {
				URL url = new URL("http://sj.haliluya.com/Lamentations_25_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[24] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 48; k++) {
				URL url = new URL("http://sj.haliluya.com/Ezekiel_26_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[25] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 12; k++) {
				URL url = new URL("http://sj.haliluya.com/Daniel_27_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[26] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 14; k++) {
				URL url = new URL("http://sj.haliluya.com/Hosea_28_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[27] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/Joel_29_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[28] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 9; k++) {
				URL url = new URL("http://sj.haliluya.com/Amos_30_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[29] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 1; k++) {
				URL url = new URL("http://sj.haliluya.com/Obadiah_31_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[30] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/Jonah_32_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[31] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 7; k++) {
				URL url = new URL("http://sj.haliluya.com/Micah_33_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[32] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/Nahum_34_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[33] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/HabaKKuk_35_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[34] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/Zephaniah_36_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[35] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 2; k++) {
				URL url = new URL("http://sj.haliluya.com/Haggai_37_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[36] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 14; k++) {
				URL url = new URL("http://sj.haliluya.com/Zechariah_38_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[37] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/Malachi_39_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[38] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 28; k++) {
				URL url = new URL("http://sj.haliluya.com/Matthew_40_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[39] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 16; k++) {
				URL url = new URL("http://sj.haliluya.com/Mark_41_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[40] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 24; k++) {
				URL url = new URL("http://sj.haliluya.com/Luke_42_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[41] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 21; k++) {
				URL url = new URL("http://sj.haliluya.com/John_43_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[42] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 28; k++) {
				URL url = new URL("http://sj.haliluya.com/Acts_44_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[43] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 16; k++) {
				URL url = new URL("http://sj.haliluya.com/Romans_45_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[44] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 16; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Corinthians_46_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[45] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 13; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Corinthians_47_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[46] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 6; k++) {
				URL url = new URL("http://sj.haliluya.com/Galatians_48_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[47] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 6; k++) {
				URL url = new URL("http://sj.haliluya.com/Ephesians_49_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[48] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/Philippians_50_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[49] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/Colossians_51_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[50] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 5; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Thessalonians_52_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[51] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Thessalonians_53_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[52] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 6; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Timothy_54_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[53] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 4; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Timothy_55_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[54] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/Titus_56_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[55] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 1; k++) {
				URL url = new URL("http://sj.haliluya.com/Philemon_57_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[56] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 13; k++) {
				URL url = new URL("http://sj.haliluya.com/Hebrews_58_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[57] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 5; k++) {
				URL url = new URL("http://sj.haliluya.com/James_59_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[58] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 5; k++) {
				URL url = new URL("http://sj.haliluya.com/1-Peter_60_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[59] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 3; k++) {
				URL url = new URL("http://sj.haliluya.com/2-Peter_61_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[60] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 5; k++) {
				URL url = new URL("http://sj.haliluya.com/1-John_62_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[61] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 1; k++) {
				URL url = new URL("http://sj.haliluya.com/2-John_63_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[62] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 1; k++) {
				URL url = new URL("http://sj.haliluya.com/3-John_64_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[63] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 1; k++) {
				URL url = new URL("http://sj.haliluya.com/Jude_65_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[64] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
		try {
			for (int k = 1; k <= 22; k++) {
				URL url = new URL("http://sj.haliluya.com/Revelation_66_" + k + ".html");
				try (BufferedReader br = new BufferedReader(new InputStreamReader(url.openStream()))) {
					String s = "";
					int i = 0;
					while ((s = br.readLine()) != null) {

						if (i == 85) {
							String s2 = s.replaceAll("<ul class=\"jingRead\" id=\"song_list\">", "");
							String s3 = s2.replaceAll("</ul>", "");
							String s4 = s3.replaceAll("<li><span style='line-height:27px'>",
									"insert into t_HolyBible values ('" + s66[65] + "','" + k + "','");
							String s5 = s4.replaceAll("</li>", "");
							String s6 = s5.replaceAll("</span><p>", "','");
							String s7 = s6.replaceAll("<br/></p>", "\'\\);\n");

							try (FileWriter fw = new FileWriter("sql.txt", true)) {
								fw.write(s7);
								// System.out.println(s9);

							}

						}
						i++;
					}
				}
			}

		} catch (Exception e) {
			e.printStackTrace();
		}

	}
}

甲骨文数据库
关注
4.网络编程
weixin_45476535的博客
09-14 414
程序注册端口：1024-49151。单个协议下，端口号不能冲突。公有端口0-1023。
【学习笔记】手写 Tomcat 三
LearnTech_123的博客
09-12 1092
响应动态资源不需要写文件名了，只需要写功能的名称即可。比如登录功能，可以定义名称为 doLogin
55 mysql 的登录认证流程
970655147的专栏
09-15 607
这里我们来看一下 mysql 的认证的流程我们这里仅仅看 我们最常见的一个 认证的处理流程我们经常会登录的时候 碰到各种异常信息大概的流程是这样客户端和服务器建立连接之后, 服务器向客户端发送 salt然后 客户端根据 salt 将客户端传入的密码加密之后, 以及相关登录信息传递给服务器然后 服务器进行验证, 验证失败, 响应对应的错误信息给客户端服务器发送 salt 的信息如下客户端发送的认证请求如下服务器响应的认证失败信息如下。
PHP在现代Web开发中的高效应用与最佳实践
运维人生
09-13 986
我们将使用Laravel框架来构建一个简单的博客系统，该系统包括文章发布、编辑、查看和评论等功能。PHP作为一门成熟且强大的服务器端脚本语言，在现代Web开发中依然扮演着重要角色。通过遵循最佳实践、利用现代PHP版本的特性和成熟的框架与组件，开发者可以高效构建出稳定、安全、可扩展的Web应用。本文通过一个简单的博客系统案例，展示了PHP在实际项目中的应用方法和技巧，希望能为PHP开发者提供一些有益的参考和启发。
转行软件测试工程师经验总结
2402_84109700的博客
09-12 549
数据安全官，CCRC-DSA数据安全评估师，CCRC-DCO数据合规官，CDO首席数据官, ITSS IT服务项目经理，IT服务项目工程师，ISO27001,CISP,软考,CISAW应急服务方向,CISAW渗透测试方向,软考,CCSC网络安全能力,工信部教考中心计算机网络安全相关认证办理。在测试理论方面，要熟悉常用的测试用例设计方法，理解不同测试类型的特点，掌握测试用例的基本格式，以及测试结束的标准。最终，我如愿以偿地加入了一家互联网公司，这里的办公环境优越，薪资也较之前的工作有所提升，使我心情愉悦。
linux环境下手动安装mysql
weixin_45583482的博客
09-14 896
没想到兜兜转转这么些年，今天申请个云服务器用来搭建求生2服务器，先用mysql来测试，结果还是花了相当久的时间。基本所有单节点部署应用到linux环境，都三个流程：1 下载安装包2 解压修改配置文件3 运行启动脚本我们按这个流程来说我遇到并解决的问题 ，如果你在过程中遇到什么问题，也请先暂停你的启动流程，移步到最下面的内容，看看是否有和你遇到一样的问题，解决以后继续。
关于新版本 tidb dashboard API 调用说明
TiDB 社区干货传送门
09-11 451
作者： WalterWj 原文来源： https://tidb.net/blog/d2d669b2 ...
mycat双主高可用架构部署-水评分表-范围分片配置
龙哥·三年风水从2011年开始做IT工作，从ps画图到前端开发->后端开发->框架开发->业务架构设计及开发->业务需求整理、开发->技术经理->技术总监
09-11 1269
mycat双主高可用架构部署-水评分表-范围分片配置
OpenJDK 8 安装指南
专注于全栈开发领域
09-12 1203
在分布式系统中，Apache Kafka 是一个非常受欢迎的消息中间件。它提供了高吞吐量、低延迟的消息传递机制，非常适合处理实时数据流。本文将介绍如何在 Java 中使用 Kafka Producer 并实现单例模式，以确保资源的有效管理。Kafka 是一个分布式流处理平台，它的核心功能包括发布和订阅记录流、存储流记录、以及处理流记录。为了充分利用 Kafka 的功能，一个高效的 Kafka 生产者（Producer）是必要的。
mariadb主从配置步骤
weixin_40539956的博客
09-13 839
c) 检查主日志文件和位置是否正确。使用的值（‘mysql-bin.000001’ 和 798）可能不是最新的。b) 确保复制用户在主服务器上拥有必要的权限。注意：出于安全原因，不建议使用 ‘root’ 作为复制用户。最好为复制创建一个专用用户。c) 使用正确的信息重新配置主服务器。如果它们都是 “Yes”，则复制应该正在工作。具体路径可能因系统配置而异。
远程访问mysql
jiedianxiaobao的博客
09-14 465
mysql远程访问是一种性能很优秀的远程访问程序，能够为客户提供良好的远程访问服务，但用户想要通过mysql使用远程访问有两个不可缺少的条件，一个是能从外部访问到mysql开启的端口，另一个是使用者必须要有用户访问权限，两者齐备才能使用mysql远程访问。作为一款专为远程访问设计的软件，拥有强度的远程访问服务功能，能够轻松完成远程访问，而且能满足用户对远程访问的隐私保护的要求，除此之外，节点小宝为了能让用户无障碍的使用远程访问服务，简单易用，即使是新手用户使用起来也没有一点压力。现在极其发达的互联网时代，
通过 Docker 部署 WordPress 服务器
shelby_loo的博客
09-15 498
Docker是一个开源平台，允许开发者将应用程序及其依赖项打包成一个容器。容器便于在不同环境中快速部署，而且隔离性强，避免了“在我电脑上可以运行”的尴尬。WordPress是一个流行的内容管理系统（CMS），以其易用性和强大的插件生态闻名。结合Docker，我们可以快速搭建一个灵活且可扩展的WordPress环境。通过以上步骤，我们成功地在三丰云的免费服务器上使用Docker部署了WordPress。这样的配置不仅快速，还方便进行后续的扩展和维护。如果你也想尝试一下，别犹豫，快来体验吧！
模拟面试后端开发复盘
Java小白的博客 致力分享每一天学到的知识
09-11 1158
一般来说系统的开发和设计思路的话，就是一般现在的项目基本上都是前后端分离架构来实现的，所以在项目的设计时，要分层次结构来划定。前后端分离架构中，前端一般是有专业的前端工程师来写的，因此我们步需要过分的关注前端，可以在github上找到相关的前端项目即可。
PostgreSQL 性能优化全方位指南：深度提升数据库效率
Asuna666w的博客
09-10 1443
在现代互联网应用中，数据库性能优化是系统优化中至关重要的一环，尤其对于数据密集型和高并发的应用而言，PostgreSQL（以下简称PG）凭借其丰富的特性和强大的功能，成为很多企业的首选。然而，随着数据规模的扩展和查询复杂度的提升，PostgreSQL的性能问题逐渐显现。PostgreSQL的查询优化器会生成查询执行计划，选择最优的执行路径，但这依赖于数据库的统计信息、表结构和SQL的写法。然而，在高并发查询的场景中，适当的反规范化（如将一些查询频繁的字段冗余存储）可以减少JOIN操作，提高查询效率。
MySQL 子查询
Lzcsfg的博客
09-13 875
在 MySQL 中，子查询（或嵌套查询）是指在一个 SQL 查询中嵌套另一个查询。子查询可以用来在主查询中动态地检索数据，常用于过滤、计算和汇总数据等。子查询可以出现在SELECTWHEREFROM和HAVING子句中。
服装|基于Java+vue的服装定制系统(源码+数据库+文档)
weixin_66413741的博客
09-10 716
服装定制将是广大用户们不可忽视的一块。但是管理好服装定制又面临很多麻烦需要解决,我们可以发现服装定制方面的系统并不是相当普及,在服装定制方面的可以有许多改进。即服装定制系统慢慢的被人们关注。服装定制管理方面的任务繁琐,以至于每年都在服装定制管理这方面投入较多的精力却效果甚微,
Oracle数据恢复—Oracle数据库误删除表数据如何恢复数据？
beiya123的博客
09-11 1033
删除Oracle数据库数据一般有以下2种方式：delete、drop或truncate。下面针对这2种删除oracle数据库数据的方式探讨一下oracle数据库数据恢复方法（不考虑全库备份和利用归档日志）。
完整版订单超时自动取消功能
最新发布
qq_49979552的博客
09-15 965
前几天对实习还是继续学习技术产生了抉择，问了一个前辈，他抛给我一个问题，怎么做15分钟订单自动取消，我说然后到时间之后，自动执行这个订单关闭业务，比如把锁了的库存给解开等等操作，然后在数据库里肯定要有体现，比如抖音，查我的订单内一块，在前段应该显示已过期，把支付的按钮变灰或者取消，支付的时候不能直接对库存进行操作，应该是支付模块调用订单模块调用库存模块。然后把理论予以实现，发现需要考虑的点还是有一些的。
基于SpringBoot的医院挂号预约管理系统
计算机学姐的博客
09-11 819
【2025最新】基于Java+SpringBoot+Vue+MySQL的医院挂号预约管理系统，前后端分离。
mysql 之 information_schema
XT4625的专栏
09-11 523
information_schema 是 MySQL 中的一个特殊数据库，它提供了关于 MySQL 服务器中所有数据库、表、列、索引、存储过程、函数、触发器等对象的元数据信息。动态生成：information_schema 中的数据是动态生成的，不是物理存储的数据，而是从 MySQL 服务器内部状态中动态获取的数据视图。ROUTINES：列出数据库中的所有存储过程和函数的信息，包括过程或函数名、参数等。TABLES：列出数据库中的所有表的信息，包括表名、表类型、创建选项等。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值