能源管理系统源代码.docx
- 文档编号:4423504
- 上传时间:2022-12-01
- 格式:DOCX
- 页数:32
- 大小:21.76KB
能源管理系统源代码.docx
《能源管理系统源代码.docx》由会员分享,可在线阅读,更多相关《能源管理系统源代码.docx(32页珍藏版)》请在冰豆网上搜索。
能源管理系统源代码
登陆界面的源代码
packageloginframe;
importjava.awt.BorderLayout;
importjava.awt.GridBagLayout;
importjava.awt.GridLayout;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.awt.event.WindowAdapter;
importjava.awt.event.WindowEvent;
importjava.sql.Statement;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjava.sql.ResultSet;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JOptionPane;
importjavax.swing.JPanel;
importjavax.swing.JTextField;
importjava.awt.GridBagConstraints;
importjava.awt.Insets;
importjavax.swing.JPasswordField;
importmainmenu.mainFrame;
publicclassloginextendsJFrameimplementsActionListener{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
privateConnectioncon=null;
Statementstmt=null;
privateResultSetr=null;
privateJLabelidlabel=newJLabel("ID");
privateJTextFieldid=newJTextField(10);
privateJLabelpwdlabel=newJLabel("密码");
privateJPasswordFieldpwd=newJPasswordField(10);
privateJButtoncommit=newJButton("登陆");
privateStringcommand=null;
publiclogin(){
setTitle("能源管理系统");
setSize(236,248);
addWindowListener(newWindowAdapter(){
publicvoidwindowClosing(WindowEvente){
System.exit(0);
}
});
getContentPane().setLayout(newGridBagLayout());
JPaneljp1=newJPanel();
GridBagConstraintsgbc_jp1=newGridBagConstraints();
gbc_jp1.anchor=GridBagConstraints.SOUTHEAST;
gbc_jp1.insets=newInsets(0,0,5,0);
gbc_jp1.gridx=0;
gbc_jp1.gridy=0;
getContentPane().add(jp1,gbc_jp1);
jp1.add(idlabel);
jp1.add(id);
JPaneljp2=newJPanel();
jp2.add(pwdlabel);
jp2.add(pwd);
JPaneljp9=newJPanel();
jp9.setLayout(newGridLayout(3,1));
jp9.add(jp2);
JPaneljp10=newJPanel();
jp10.setLayout(newBorderLayout());
jp10.add("West",jp9);
jp9.add(commit);
commit.addActionListener(this);
GridBagConstraintsgbc_jp10=newGridBagConstraints();
gbc_jp10.insets=newInsets(0,0,5,0);
gbc_jp10.gridx=0;
gbc_jp10.gridy=1;
getContentPane().add(jp10,gbc_jp10);
try{
Stringurl="jdbc:
sqlserver:
//localhost:
1433;databaseName=energy_management;integratedSecurity=true";
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
System.out.println("驱动程序已装载");
System.out.println("即将连接数据库");
con=DriverManager.getConnection(url,"sa","123456");
System.out.println("loadok");
stmt=con.createStatement();
}catch(Exceptionex){
System.out.println(ex.getMessage());
}
}
publicvoidactionPerformed(ActionEventevt){
try{
Stringuid=id.getText().trim();
Stringupwd=pwd.getText();
Stringc1="like'"+uid+"'";
Stringc2="like'"+upwd+"'";
command="select*"+"frommanager_info"+"whereid"
+c1+"andpassword"+c2;
r=stmt.executeQuery(command);
if(uid.length()!
=0||upwd.length()!
=0){
if(r.next()){
JOptionPane.showMessageDialog(commit,"登陆成功","提示",
JOptionPane.INFORMATION_MESSAGE);
mainFramemf=newmainFrame();
mf.showf();
setVisible(false);
}else{
JOptionPane.showMessageDialog(commit,"ID或者密码错误","警告",
JOptionPane.ERROR_MESSAGE);
}
}else{
JOptionPane.showMessageDialog(commit,"ID或者密码不能为空","警告",
JOptionPane.ERROR_MESSAGE);
}
}catch(Exceptionex){
System.out.println(ex.getMessage());
}
}
publicstaticvoidmain(Stringargs[]){
JFramemyframe=newlogin();
myframe.setVisible(true);
}
}
操作界面源代码
packagemainmenu;
importjava.awt.Container;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.awt.event.InputEvent;
importjava.awt.event.KeyEvent;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JMenu;
importjavax.swing.JMenuBar;
importjavax.swing.JMenuItem;
importjavax.swing.JOptionPane;
importjavax.swing.JToolBar;
importjavax.swing.KeyStroke;
importconsume_query.Queryconsume;
importprice_management.queryprice;
importprice_management.updateprice;
importuser_info_insert.insert_user_information;
importuser_info_insert.user_info_delete;
importuser_record_insert.insert_user_record;
importloginframe.login;
publicclassmainFrameextendsJFrame{
publicmainFrame(){
}
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
publicstaticfinalinth=200;
publicstaticfinalintw=370;
JFramemainframe;
publicvoidshowf(){
mainframe=newJFrame();
mainframe.setTitle("管理员操作");
mainframe.setSize(500,130);
mainframe.setResizable(true);
meaushow();
showtool();
mainframe.show();
}
publicvoidmeaushow(){
JMenuBarmeaubar=newJMenuBar();
JMenufile=newJMenu("文件");
JMenuItemlogout=newJMenuItem("注销",'L');
JMenuItemexit=newJMenuItem("退出",'E');
JMenuhelp=newJMenu("帮助");
JMenuItemabout=newJMenuItem("关于",'A');
logout.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_L,
InputEvent.CTRL_MASK));
exit.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_E,
InputEvent.CTRL_MASK));
about.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_A,
InputEvent.CTRL_MASK));
logout.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
mainframe.setVisible(false);
loginmyframe=newlogin();
myframe.setVisible(true);
}//TODOAuto-generatedmethodstub
});
exit.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
System.exit(0);//TODOAuto-generatedmethodstub
}
});
about.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JOptionPane.showMessageDialog(mainframe,"这是一个能源管理收费系统","关于",
JOptionPane.INFORMATION_MESSAGE);
};
});
meaubar.add(file);
meaubar.add(help);
file.add(logout);
file.add(exit);
help.add(about);
mainframe.setJMenuBar(meaubar);
}
publicvoidshowtool(){
JToolBartoolbar=newJToolBar();
JButtonl1=newJButton("用户信息录入");
JButtonl2=newJButton("价格查询");
JButtonl3=newJButton("价格更改");
JButtonl4=newJButton("用户记录信息录入");
JButtonl5=newJButton("收费查询");
JButtonl6=newJButton("删除用户");
toolbar.add(l1);
toolbar.add(l2);
toolbar.add(l3);
toolbar.add(l4);
toolbar.add(l5);
toolbar.add(l6);
Containercontentpane=mainframe.getContentPane();
contentpane.add(toolbar);
l1.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemyframe=newinsert_user_information();
myframe.setVisible(true);
//TODOAuto-generatedmethodstub
}
});
l2.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemyframe=newqueryprice();
myframe.setVisible(true);
//TODOAuto-generatedmethodstub
}
});
l3.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemyframe=newupdateprice();
myframe.setVisible(true);
//TODOAuto-generatedmethodstub
}
});
l4.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemyframe=newinsert_user_record();
myframe.setVisible(true);
}//TODOAuto-generatedmethodstub
});
l5.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemyframe=newQueryconsume();
myframe.setVisible(true);
}//TODOAuto-generatedmethodstub
});
l6.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
JFramemFrame=newuser_info_delete();
mFrame.setVisible(true);
//TODOAuto-generatedmethodstub
}
});
}
publicstaticvoidmain(Stringargs[]){
mainFramemf=newmainFrame();
mf.showf();
}
}
各个操作的源代码:
(1)录入用户基本信息:
packageuser_info_insert;
importjava.awt.BorderLayout;
importjava.awt.GridBagLayout;
importjava.awt.GridLayout;
importjava.awt.event.ActionEvent;
importjava.awt.event.ActionListener;
importjava.sql.Statement;
importjava.sql.Connection;
importjava.sql.DriverManager;
importjavax.swing.JButton;
importjavax.swing.JFrame;
importjavax.swing.JLabel;
importjavax.swing.JOptionPane;
importjavax.swing.JPanel;
importjavax.swing.JTextField;
importjavax.swing.SwingConstants;
publicclassinsert_user_informationextendsJFrameimplementsActionListener{
/**
*
*/
privatestaticfinallongserialVersionUID=1L;
privateConnectioncon=null;
Statementstmt=null;
privateJLabelTitle=newJLabel("请输入新用户的信息",SwingConstants.CENTER);
privateJLabelidlabel=newJLabel("用户ID");
privateJTextFieldid=newJTextField(15);
privateJLabelnamelabel=newJLabel("姓名");
privateJTextFieldname=newJTextField(15);
privateJLabelsexlabel=newJLabel("性别");
privateJTextFieldsex=newJTextField(15);
privateJLabeladdresslabel=newJLabel("家庭地址");
privateJTextFieldaddress=newJTextField(15);
privateJLabeltelephonelabel=newJLabel("电话");
privateJTextFieldtelephone=newJTextField(15);
privateJLabelworkplacelabel=newJLabel("工作地点");
privateJTextFieldworkplace=newJTextField(15);
privateJLabeldepartmentlabel=newJLabel("部门");
privateJTextFielddepartment=newJTextField(15);
privateJLabelremarklabel=newJLabel("备注");
privateJTextFieldremark=newJTextField(15);
privateJButtoncommit=newJButton("提交");
publicinsert_user_information(){
setTitle("用户
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 能源 管理 系统 源代码