java mysql查询界面_java实现简单的数据库的增删查改，并布局交互界面

1 packageBp;2 import java.awt.*;3

4 import javax.swing.*;5

6 importjava.awt.event.ActionEvent;7 importjava.awt.event.ActionListener;8 importjava.awt.event.MouseEvent;9 importjava.awt.event.MouseListener;10 importjava.sql.Connection;11 importjava.sql.DriverManager;12 importjava.sql.ResultSet;13 importjava.sql.SQLException;14 importjava.sql.Statement;15 importjava.util.logging.Level;16 importjava.util.logging.Logger;17

18 import javax.swing.*;19 importjavax.swing.event.MouseInputListener;20

21 public classB {22

23 public static voidmain(String[] args) {24 //TODO Auto-generated method stub25 //TODO Auto-generated method stub

26 My_object1 my =newMy_object1();27

28 }29

30 }31 class My_object1 extendsJFrame{32

33 publicJTextField j3;34 publicJTextField j4;35 ImageIcon img = null;36 JPanel p;37 publicMy_object1(){38

39 img = new ImageIcon( "C:\\用户\\zhangye123\\图片\\1569976476.jpg ");40

41 setTitle("登录");42 setSize(200,150);43

44 //、、JFrame j=new JFrame();

45 JPanel p=newJPanel();46 LayoutManager icon = (LayoutManager) new ImageIcon("c:\\用户\\zhangye123\\图片\\1569976476.jpg");47

48

49 getContentPane().add(p);50

51 JLabel j1=new JLabel("密码 ");52 JLabel j2=new JLabel("用户名");53 JLabel j7=newJLabel(img);54 j3=new JTextField(10);55 j4=new JTextField(10);56 JButton j5=new JButton("确定");57 JButton j6=new JButton("取消");58 p.add(j7);59 p.add(j2);60 p.add(j3);61 p.add(j1);62 p.add(j4);63 p.add(j5);64 p.add(j6);65 j6.addActionListener(newActionListener() {66

67 @Override68 public voidactionPerformed(ActionEvent e) {69 //TODO 自动生成的方法存根

70 if(e.getActionCommand().equals("取消")){71 System.exit(0);72 }73 }74 });75 //final String userName = "abc";76 //final String passwrod = "123";

77

78 j5.addMouseListener(newMouselen());79 setLocationRelativeTo(null);80 setVisible(true);81 }82 class Mouselen implementsMouseListener{83

84 @Override85 public voidmouseClicked(MouseEvent e) {86 //TODO Auto-generated method stub

87 if(!j3.getText().equals("123456"))88 //System.out.println("用户名错误");

89 JOptionPane.showMessageDialog(null, "账号错误");90 if(!j4.getText().equals("789"))91 //System.out.println("密码错误");

92 JOptionPane.showMessageDialog(null, "密码错误");93 else //System.out.println("输入正确");94 //JOptionPane.showMessageDialog(null, "登录成功");

95 {96 //System.exit(0);

97 newguanli();98 }99 }100

101 @Override102 public voidmouseEntered(MouseEvent e) {103 //TODO Auto-generated method stub

104

105 }106

107 @Override108 public voidmouseExited(MouseEvent e) {109 //TODO Auto-generated method stub

110

111 }112

113 @Override114 public voidmousePressed(MouseEvent e) {115 //TODO Auto-generated method stub

116

117 }118

119 @Override120 public voidmouseReleased(MouseEvent e) {121 //TODO Auto-generated method stub

122

123 }124

125

126 }127

128 }129 class guanli extendsJFrame{130 JButton b1;131 JButton b2;132 publicguanli(){133 setSize(550,370);134 Toolkit tk=getToolkit();135 Dimension d1=tk.getScreenSize();136 int w=(int)d1.getWidth();137 int h=(int)d1.getHeight();138 setLocation(w/2-550/2, h/2-370/2);139 setVisible(true);140 setTitle("信息管理系统");141 //Image img1=tk.getImage("./src/jame/1-140326154313.jpg");142 //setIconImage(img1);

143 ImageIcon img2 = new ImageIcon("./src/jame/13.jpg"); //相对路径获取图片

144 JLabel imgLabel = new JLabel(img2); //创建图片标签

145 this.getLayeredPane().add(imgLabel, newInteger(Integer.MIN_VALUE));146 //为标签设置为容器最底层；getLayeredPane()作用是为容器添加深度，允许组件互相重叠；Integer.MIN_VALUE最底层

147 imgLabel.setBounds(0,0,img2.getIconWidth(), img2.getIconHeight());148 Container cp=getContentPane(); //获取顶级容器

149 ((JPanel)cp).setOpaque(false); //设置透明以使底层背景图片显示

150 cp.setLayout(null);151

152 JLabel imgLable=newJLabel();153 JLabel j2=new JLabel("***欢迎登陆学生管理系统***");154 JLabel j1=new JLabel("~~请在左侧选择所做的操作~~");155 JButton b1=new JButton("查询");156 JButton b2=new JButton("取消");157 JButton b3=new JButton("修改");158 JButton b4=new JButton("增添");159 JButton b5=new JButton("删除");160 JTextArea t3=new JTextArea(150,150);161 cp.add(j2);162 j2.setBounds(220,110,190,25);163 cp.add(j1);164 j1.setBounds(220,150,190,25);165 cp.add(b1);166 b1.setBounds(0, 70, 90, 25);167 cp.add(b2);168 b2.setBounds(250, 250, 70, 25);169 cp.add(b4);170 b4.setBounds(0,110,90,25);171 cp.add(b3);172 b3.setBounds(0,150,90,25);173 cp.add(b5);174 b5.setBounds(0,190,90,25);175 b2.addActionListener(newActionListener() {176

177 @Override178 public voidactionPerformed(ActionEvent e) {179 //TODO 自动生成的方法存根

180 if(e.getActionCommand().equals("取消")){181 System.exit(0);182 }183 }184 });185 b1.addActionListener(newActionListener() {186

187 @Override188 public voidactionPerformed(ActionEvent e) {189 //TODO 自动生成的方法存根

190 newchaxun();191

192 }193 });194 b3.addActionListener(newActionListener() {195

196 @Override197 public voidactionPerformed(ActionEvent e) {198 //TODO 自动生成的方法存根

199 newxiugai();200

201 }202 });203 b4.addActionListener(newActionListener() {204

205 @Override206 public voidactionPerformed(ActionEvent e) {207 //TODO 自动生成的方法存根

208 newzengtian();209

210 }211 });212 b5.addActionListener(newActionListener() {213

214 @Override215 public voidactionPerformed(ActionEvent e) {216 //TODO 自动生成的方法存根

217 newshanchu();218

219 }220 });221 }222 }223

224 class chaxun extendsJFrame{225 TextField t1;226 TextField t2;227

228 publicchaxun(){229 setTitle("查询");230 setSize(550, 370);231 JPanel p1=newJPanel();232 //getContentPane().add(p1);

233 JLabel j1=new JLabel("学号： ");234 JLabel j2=new JLabel("姓名： ");235 JLabel j3=new JLabel("专业： ");236 TextField t1=new TextField(70);237 TextField t2=new TextField(70);238 TextField t3=new TextField(70);239 JButton b=new JButton("查询");240 JButton b1=new JButton("取消");241 ImageIcon img2 = new ImageIcon("./src/1-140326154313.jpg"); //相对路径获取图片

242 JLabel imgLabel = new JLabel(img2); //创建图片标签

243 this.getLayeredPane().add(imgLabel, newInteger(Integer.MIN_VALUE));244 //为标签设置为容器最底层；getLayeredPane()作用是为容器添加深度，允许组件互相重叠；Integer.MIN_VALUE最底层

245 imgLabel.setBounds(0,0,img2.getIconWidth(), img2.getIconHeight());246 Container p11=getContentPane(); //获取顶级容器

247 ((JPanel)p11).setOpaque(false); //设置透明以使底层背景图片显示

248 p11.setLayout(null);249 p11.add(j2);250 j2.setBounds(50, 70, 70, 25);251 p11.add(t1);252 t1.setBounds(150, 70,100, 20);253 p11.add(j1);254 j1.setBounds(50, 150, 70, 25);255 p11.add(t2);256 t2.setBounds(150,150,100, 20);257 p11.add(j3);258 j3.setBounds(50,230,70, 25);259 p11.add(t3);260 t3.setBounds(150, 230,100, 20);261 p11.add(b);262 b.setBounds(400,140,90,25);263 p11.add(b1);264 b1.setBounds(400,170,90,25);265 setLocationRelativeTo(null);266 setVisible(true);267 final String url = "jdbc:mysql://localhost:3306/test";268 b1.addActionListener(newActionListener() {269

270 @Override271 public voidactionPerformed(ActionEvent e) {272 //TODO 自动生成的方法存根

273 if(e.getActionCommand().equals("取消")){274 System.exit(0);275 }276 }277 });278 b.addActionListener(newActionListener() {279

280 @Override281 public voidactionPerformed(ActionEvent arg0) {282 //TODO Auto-generated method stub

283

284

285 try (Connection conn = DriverManager.getConnection(url,"root","1234"))286 {287 Statement state =conn.createStatement();288 ResultSet result = state.executeQuery("SELECT name FROM xuesheng");289

290

291 } catch(SQLException ex) {292

293 ex.getSQLState();294 }295 }296 });297 }298 }299

300 class xiugai extendsJFrame{301 publicxiugai(){302 setTitle("修改");303 setSize(550, 370);304 JPanel p1=newJPanel();305 getContentPane().add(p1);306 setLocationRelativeTo(null);307 setVisible(true);308

309 }310 }311

312 class zengtian extendsJFrame{313 publiczengtian(){314 setTitle("增添");315 setSize(550, 370);316 JPanel p1=newJPanel();317 getContentPane().add(p1);318 setLocationRelativeTo(null);319 setVisible(true);320 }321 }322

323 class shanchu extendsJFrame{324 publicshanchu(){325 setTitle("删除");326 setSize(550, 370);327 JPanel p1=newJPanel();328 getContentPane().add(p1);329 setLocationRelativeTo(null);330 setVisible(true);331 }332 }