1、NewsId文本(6)TitleName文本(30)null标题名称NewsClass新闻类别Creator创建者CreateTime文本(50)创建时间4 类设计本系统设计了News、Login、FirstTitleUI、MyConnection、Listener五个类,具体说明及类图如下:(1)MyConnection类,实现与数据库的连接、数据访问操作操作。MyConnection+getConnection( ):Connection+closeConnection(dbConnection:Connection):void+ closePreparedStatement(pstat
2、:PreparedStatment):+closeResult(rs:Result):(2)News类,实现新闻管理系统主页面。JFrameNews-pan:JPanel-lb:JLabel-bar:JMenuBar-file:JMenu-help:-file_login:JMenuItem-file_exit:(3)Login类,实现用户登录功能Login-lbId:-lbPassword:-btLogin:JButton-btCancel:-txtId:JTextField-txtPass:JPasswordField-gbl:JGridBagLayout-gbc:JGridBagCons
3、traints+createPanel( ):(4)FirstTitleUI类,实现新闻管理系统信息操作主页面FirstTitleUI-panQry:-panInfo:Jpanel-panOperator:-lbIdQry:-txtIdQry:JTextFiled-lbNewsId:-lbTitleName:-lbCreator:-lbTitleClass:Jlabel-btAdd:-btDel:-btUpdate:-btQry:-btExit:-txtNewsId:-txtTitleName:-txtCreator:-txtCreateTime:-ComboTitleClass:JCombo
4、Box+createQueryUI( ):+createInfoUI( ):+createOperatorUI( ):+getQueryId( ):String+getNewsId( ):+getTitleName( ):+getCreator( ):+getTitleClass( ):+getCreateTime( ):+getBtDel( ):+getBtAdd( ):+getBtUpdate( ):+getBtExit( ):+getBtQry( )JButton+setInformation(newsid:String,titlename:String,creator:String,t
5、itleclass:String,createtime:String):(5)Listener类,实现查询、删除、新增、更改、退出系统的操作ActionListener+actionPerformed(evt:ActionEvent)Listener-UI:5 关键代码(1)登录代码public void actionPerformed(ActionEvent evt) if(evt.getSource().equals(btLogin) Connection datacon = null; PreparedStatement pstat = null; ResultSet rs = null
6、; try datacon = MyConnection.getConnection(); String str = select * from UserInfo where UserId=? and UserPass=?; pstat = datacon.prepareStatement(str); pstat.setString(1, txtId.getText(); pstat.setString(2,txtPass.getText(); rs = pstat.executeQuery(); if(rs.next() txtId.setText(); txtPass.setText( n
7、ew FirstTitleUI().setVisible(true); else JOptionPane.showMessageDialog(null,用户名或密码有错误!,Sorry,JOptionPane.PLAIN_MESSAGE); catch(Exception e) e.printStackTrace(); finally MyConnection.closePreparedStatement(pstat); MyConnection.closeResult(rs); MyConnection.closeConnection(datacon); (2)查询、删除、更新、增加、退出功
8、能代码 JButton obj = (JButton)evt.getSource(); /得到事件源 Connection datacon = null; PreparedStatement pstat = null; ResultSet rs = null; Statement stat = null; String titleid= String titlename= String creator= String createtime= String titleclass= try datacon = MyConnection.getConnection(); /执行查询操作 if(obj
9、.equals(UI.getBtQry() String strSql = select * from FirstTile where newsId=? pstat = datacon.prepareStatement(strSql); pstat.setString(1,UI.getQueryId(); /执行查询 /取出当前记录的各字段里的值 titleid = rs.getString(newsId titlename = rs.getString(TitleName titleclass = rs.getString(NewsClass creator = rs.getString(C
10、reator createtime = rs.getString(CreateTime UI.setInformation(titleid,titlename,creator,titleclass,createtime); else没有匹配的新闻!ok /执行新增操作 if(obj.equals(UI.getBtAdd()insert into FirstTile values(?,?) pstat.setString(1,UI.getNewsId(); pstat.setString(2,UI.getName(); pstat.setString(3,UI.getTitleClass();
11、pstat.setString(4,UI.getCreator(); pstat.setString(5,UI.getCreateTime(); pstat.executeUpdate(); UI.clear(); JOptionPane.showMessageDialog(null,添加成功! /执行删除操作 if(obj.equals(UI.getBtDel()delete from FirstTile where newsId=?删除成功! /执行修改操作 if(obj.equals(UI.getBtUpdate()Update FirstTile set TitleName=?,Cre
12、ator=?,NewsClass=?,CreateTime=? where newsId=? pstat.setString(1,UI.getName(); pstat.setString(2,UI.getCreator(); pstat.setString(4,UI.getCreateTime(); pstat.setString(5,UI.getQueryId();修改成功! /退出系统操作 if(obj.equals(UI.getBtExit() System.exit(0);6 系统界面(1)系统主界面(2)登录界面(Login.java)(3)新闻一级标题操作界面(FirstTitleUI.java)
copyright@ 2008-2022 冰豆网网站版权所有
经营许可证编号:鄂ICP备2022015515号-1