• java加sqlite3右键菜单版圣经，还没检查错误

    1. package i;
    2.  
    3. import java.awt.Color;
    4. import java.awt.Font;
    5. import java.awt.event.ActionEvent;
    6. import java.awt.event.ActionListener;
    7. import java.awt.event.MouseEvent;
    8. import java.awt.event.MouseListener;
    9. import java.sql.Connection;
    10. import java.sql.DriverManager;
    11. import java.sql.PreparedStatement;
    12. import java.sql.ResultSet;
    13. import java.util.ArrayList;
    14. import java.util.HashMap;
    15.  
    16. import javax.swing.JFrame;
    17. import javax.swing.JMenu;
    18. import javax.swing.JMenuBar;
    19. import javax.swing.JMenuItem;
    20. import javax.swing.JOptionPane;
    21. import javax.swing.JPopupMenu;
    22. import javax.swing.JScrollPane;
    23. import javax.swing.JTextPane;
    24. import javax.swing.plaf.FontUIResource;
    25. import javax.swing.text.Style;
    26. import javax.swing.text.StyleConstants;
    27. import javax.swing.text.StyledDocument;
    28.  
    29. public class Main extends JFrame implements ActionListener, MouseListener {
    30.  
    31. 	String[] jiuyue = { "创", "出", "利", "民", "申", "书", "士", "得", "撒上", "撒下", "王上", "王下", "代上", "代下", "拉", "尼", "斯", "伯", "诗", "箴", "传", "歌", "赛", "耶", "哀", "结", "但", "何", "珥", "摩", "俄", "拿", "弥", "鸿", "哈", "番", "该", "亚", "玛" };
    32. 	String[] xinyue = { "太", "可", "路", "约", "徒", "罗", "林前", "林后", "加", "弗", "腓", "西", "帖前", "帖后", "提前", "提后", "多", "门", "来", "雅", "彼前", "彼后", "约壹", "约贰", "约叁", "犹", "启" };
    33. 	String[] mulu = { "律法书", "历史书", "诗歌·智慧书", "先知书", "四福音", "教会历史", "书信", "对约翰的启示" };
    34. 	String[] lei = { "律法书", "历史书", "诗歌·智慧书", "先知书", "四福音", "教会历史", "书信", "对约翰的启示" };
    35. 	String[] lfs = { "创世记", "出埃及记", "利未记", "民数记", "申命记" };
    36. 	String[] lss = { "约书亚记", "士师记", "路得记", "撒母耳记上", "撒母耳记下", "列王纪上", "列王纪下", "历代志上", "历代志下", "以斯拉记", "尼希米记", "以斯帖记" };
    37. 	String[] sgzhs = { "约伯记", "诗篇", "箴言", "传道书", "雅歌" };
    38. 	String[] xzs = { "以赛亚书", "耶利米书", "耶利米哀歌", "以西结书", "但以理书", "何西阿书", "约珥书", "阿摩司书", "俄巴底亚书", "约拿书", "弥迦书", "那鸿书", "哈巴谷书", "西番雅书", "哈该书", "撒迦利亚书", "玛拉基书" };
    39. 	String[] sfy = { "马太福音", "马可福音", "路加福音", "约翰福音" };
    40. 	String[] jhls = { "使徒行传" };
    41. 	String[] sx = { "罗马书", "哥林多前书", "哥林多后书", "加拉太书", "以弗所书", "腓立比书", "歌罗西书", "帖撒罗尼迦前书", "帖撒罗尼迦后书", "提摩太前书", "提摩太后书", "提多书", "腓利门书", "希伯来书", "雅各书", "彼得前书", "彼得后书", "约翰一书", "约翰二书", "约翰三书", "犹大书" };
    42. 	String[] dyhdqs = { "启示录" };
    43. 	String[][] hb = { lfs, lss, sgzhs, xzs, sfy, jhls, sx, dyhdqs };
    44.  
    45. 	JPopupMenu jpm = new JPopupMenu();
    46. 	JMenu[] jm = new JMenu[lei.length];
    47. 	JTextPane jtp = new JTextPane();
    48. 	JScrollPane jsp = new JScrollPane(jtp);
    49. 	FontUIResource fuir = new FontUIResource("微软雅黑", Font.BOLD, 88);
    50. 	StyledDocument sd = jtp.getStyledDocument();
    51. 	Style sty = jtp.addStyle(null, null);
    52.  
    53. 	JMenuItem[] jmi = new JMenuItem[66];
    54.  
    55. 	public Main() {
    56. 		for (int i = 0; i < lei.length; i++) {
    57. 			jm[i] = new JMenu(lei[i]);
    58. 			jpm.add(jm[i]);
    59. 			JMenuItem[] jmi = new JMenuItem[hb[i].length];
    60. 			if (i == 3) {
    61. 				jpm.addSeparator();
    62. 			}
    63. 			for (int j = 0; j < hb[i].length; j++) {
    64. 				jmi[j] = new JMenuItem(hb[i][j]);
    65. 				jmi[j].addActionListener(this);
    66. 				jm[i].add(jmi[j]);
    67. 			}
    68. 		}
    69.  
    70. 		jtp.setEditable(false);
    71. 		jtp.addMouseListener(this);
    72. 		jtp.setBackground(Color.BLACK);
    73. 		jtp.setFont(fuir);
    74. 		jtp.setText("请选择菜单中的卷,再输入要查询的章节数字,中间用空格隔开.例如查询创世记第1章第1节则先选择律法书菜单里面的创世记,接下来在弹出的提示框中输入1 1(注:1 1之间中间用空格隔开)\n");
    75.  
    76. 		// this.setJMenuBar(jmb);
    77. 		this.add(jsp);
    78. 		this.setSize(1000, 700);
    79. 		this.setTitle("圣经投屏");
    80. 	}
    81.  
    82. 	public static void main(String[] args) {
    83. 		Main m = new Main();
    84. 		m.setExtendedState(MAXIMIZED_BOTH);
    85. 		m.setDefaultCloseOperation(EXIT_ON_CLOSE);
    86. 		m.setVisible(true);
    87.  
    88. 	}
    89.  
    90. 	public static ArrayList> select(String juan, String zhang, String jie) {
    91. 		ArrayList> alhmss = new ArrayList>();
    92. 		try {
    93. 			Class.forName("org.sqlite.JDBC");
    94. 			try (Connection conn = DriverManager.getConnection("jdbc:sqlite:hb.sqlite3")) {
    95. 				try (PreparedStatement ps = conn.prepareStatement("select juan, zhang, jie, jingwen from t_hb where juan = ? and zhang = ? and jie between ? and 200")) {
    96. 					ps.setString(1, juan);
    97. 					ps.setString(2, zhang);
    98. 					ps.setString(3, jie);
    99. 					try (ResultSet rs = ps.executeQuery()) {
    100. 						while (rs.next()) {
    101. 							HashMap hmss = new HashMap();
    102. 							hmss.put("juan", rs.getString("juan"));
    103. 							hmss.put("zhang", rs.getString("zhang"));
    104. 							hmss.put("jie", rs.getString("jie"));
    105. 							hmss.put("jingwen", rs.getString("jingwen"));
    106. 							alhmss.add(hmss);
    107. 						}
    108. 					}
    109. 				}
    110. 			}
    111. 		} catch (Exception e) {
    112. 			e.printStackTrace();
    113. 		}
    114. 		return alhmss;
    115. 	}
    116.  
    117. 	public void actionPerformed(ActionEvent ae) {
    118. 		String s = ae.getActionCommand();
    119. 		String shuru = JOptionPane.showInputDialog("请输入要查询的章节(例如查找所在卷1章1节到最后1节则输入:1 1(中间用空格隔开，不用输入结束的章节)):", "1 1").trim();
    120. 		if (shuru == null) {
    121. 			return;
    122. 		}
    123. 		if (shuru.equals("")) {
    124. 			return;
    125. 		}
    126. 		String[] zhangjie = shuru.split(" ");
    127. 		if (!zhangjie[0].trim().matches("^[0-9]*$") || !zhangjie[1].trim().matches("^[0-9]*$")) {
    128. 			return;
    129. 		}
    130. 		ArrayList> alhmss = this.select(s, zhangjie[0], zhangjie[1]);
    131. 		jtp.setText("");
    132.  
    133. 		for (int i = 0; i < alhmss.size(); i++) {
    134. 			String zhang = alhmss.get(i).get("zhang");
    135. 			String jie = alhmss.get(i).get("jie");
    136. 			String jingwen = alhmss.get(i).get("jingwen");
    137. 			String zhangjiejingwen = zhang + ":" + jie + jingwen + "\n";
    138. 			if (i % 3 == 0) {
    139. 				StyleConstants.setForeground(sty, Color.CYAN);
    140. 			} else if (i % 3 == 1) {
    141. 				StyleConstants.setForeground(sty, Color.MAGENTA);
    142. 			} else if (i % 3 == 2) {
    143. 				StyleConstants.setForeground(sty, Color.YELLOW);
    144. 			} else {
    145. 				StyleConstants.setForeground(sty, Color.WHITE);
    146. 			}
    147. 			try {
    148. 				sd.insertString(sd.getLength(), zhangjiejingwen, sty);
    149. 			} catch (Exception e) {
    150. 				e.printStackTrace();
    151. 			}
    152.  
    153. 			this.jtp.setCaretPosition(0);
    154. 		}
    155.  
    156. 	}
    157.  
    158. 	@Override
    159. 	public void mouseClicked(MouseEvent me) {
    160. 		// TODO Auto-generated method stub
    161.  
    162. 	}
    163.  
    164. 	@Override
    165. 	public void mouseEntered(MouseEvent me) {
    166. 		// TODO Auto-generated method stub
    167.  
    168. 	}
    169.  
    170. 	@Override
    171. 	public void mouseExited(MouseEvent me) {
    172. 		// TODO Auto-generated method stub
    173.  
    174. 	}
    175.  
    176. 	@Override
    177. 	public void mousePressed(MouseEvent me) {
    178. 		// TODO Auto-generated method stub
    179.  
    180. 	}
    181.  
    182. 	@Override
    183. 	public void mouseReleased(MouseEvent me) {
    184. 		if (me.isPopupTrigger()) {
    185. 			jpm.show(me.getComponent(), me.getX(), me.getY());
    186. 		}
    187.  
    188. 	}
    189. }
    190.  
    191. //
    192. //
    193. //
    194. // package i;
    195. //
    196. // import java.awt.*;
    197. // import java.awt.event.*;
    198. // import javax.swing.*;
    199. // import javax.swing.plaf.FontUIResource;
    200. // import javax.swing.text.Style;
    201. // import javax.swing.text.StyledDocument;
    202. //
    203.  左键弹出菜单
    204. // public class Main extends JFrame implements ActionListener, MouseListener {
    205.  
    206. //
    207.  
    208. //
    209. // public Main() {
    210. //
    211. // for (int i = 0; i < jm.length; i++) {
    212. // jm[i] = new JMenu(mulu[i]);
    213. // jpm.add(jm[i]); // 增加菜单项到菜单上
    214. // for (int j = 0; j < hb[i].length; j++) {
    215. // jmi[j] = new JMenuItem(hb[i][j]);
    216. // jm[i].add(jmi[j]);
    217. // jm[i].addActionListener(this);
    218. // }
    219. //
    220. // }
    221. // jtp.addMouseListener(this);
    222. // this.add(jsp);
    223. // getContentPane().setBackground(Color.white); // 窗口的默认背景色为白色
    224. // setSize(230, 160); // 设置窗口大小
    225. // setVisible(true); // 设置窗口为可视
    226. // setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); // 关闭窗口时退出程序
    227. // }
    228. //
    229. // public static void main(String args[]) {
    230. // new Main();
    231. // }
    232. //
    233. // public void mouseReleased(MouseEvent me) {
    234. // if (me.isPopupTrigger()) {
    235. // jpm.show(me.getComponent(), me.getX(), me.getY());
    236. // }
    237. // }
    238. //
    239. // public void mouseClicked(MouseEvent me) {
    240. // }
    241. //
    242. // public void mousePressed(MouseEvent me) {
    243. // }
    244. //
    245. // public void mouseExited(MouseEvent me) {
    246. // }
    247. //
    248. // public void mouseEntered(MouseEvent me) {
    249. // }
    250. //
    251. // @Override
    252. // public void actionPerformed(ActionEvent e) {
    253. // // TODO Auto-generated method stub
    254. //
    255. // }
    256. //
    257. // }

  • 相关阅读:
    循环登录提示“您为登录或者认证已过期，请重新登录”
    Metabase可视化BI系统部署安装及简单使用
    MySQL 45 讲 | 11 怎么给字符串字段加索引？
    机器学习之算法优化（一）
    洛谷 P3367 【模板】并查集 Java
    【成像光敏描记图提取和处理】成像-光电容积描记-提取-脉搏率-估计（Matlab代码实现）
    爬虫为什么需要 HTTP 代理 IP？
    Springboot使用定时任务scheduler详解
    渗透必备：Proxifier玩转代理
    第2-3-1章 文件存储服务系统-nginx/fastDFS/minio/阿里云oss/七牛云oss
  • 原文地址：https://blog.csdn.net/www_oracle_com/article/details/134431152