能源管理系统源代码Word格式文档下载.docx
《能源管理系统源代码Word格式文档下载.docx》由会员分享,可在线阅读,更多相关《能源管理系统源代码Word格式文档下载.docx(32页珍藏版)》请在冰豆网上搜索。
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("
驱动程序已装载"
即将连接数据库"
con=DriverManager.getConnection(url,"
sa"
"
123456"
loadok"
stmt=con.createStatement();
}catch(Exceptionex){
System.out.println(ex.getMessage());
}
}
publicvoidactionPerformed(ActionEventevt){
Stringuid=id.getText().trim();
Stringupwd=pwd.getText();
Stringc1="
like'
"
+uid+"
'
"
Stringc2="
+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{
ID或者密码错误"
警告"
JOptionPane.ERROR_MESSAGE);
}
}else{
JOptionPane.showMessageDialog(commit,"
ID或者密码不能为空"
JOptionPane.ERROR_MESSAGE);
publicstaticvoidmain(Stringargs[]){
JFramemyframe=newlogin();
myframe.setVisible(true);
}
操作界面源代码
packagemainmenu;
importjava.awt.Container;
importjava.awt.event.InputEvent;
importjava.awt.event.KeyEvent;
importjavax.swing.JMenu;
importjavax.swing.JMenuBar;
importjavax.swing.JMenuItem;
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(){
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,
about.setAccelerator(KeyStroke.getKeyStroke(KeyEvent.VK_A,
logout.addActionListener(newActionListener(){
@Override
publicvoidactionPerformed(ActionEvente){
mainframe.setVisible(false);
loginmyframe=newlogin();
myframe.setVisible(true);
}//TODOAuto-generatedmethodstub
exit.addActionListener(newActionListener(){
//TODOAuto-generatedmethodstub
about.addActionListener(newActionListener(){
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(){
JFramemyframe=newinsert_user_information();
//TODOAuto-generatedmethodstub
l2.addActionListener(newActionListener(){
JFramemyframe=newqueryprice();
l3.addActionListener(newActionListener(){
JFramemyframe=newupdateprice();
l4.addActionListener(newActionListener(){
JFramemyframe=newinsert_user_record();
l5.addActionListener(newActionListener(){
JFramemyframe=newQueryconsume();
l6.addActionListener(newActionListener(){
JFramemFrame=newuser_info_delete();
mFrame.setVisible(true);
//TODOAuto-generatedmethodstub
mainFramemf=newmainFrame();
mf.showf();
各个操作的源代码:
(1)录入用户基本信息:
packageuser_info_insert;
importjavax.swing.SwingConstants;
publicclassinsert_user_informationextendsJFrameimplementsActionListener{
privateJLabelTitle=newJLabel("
请输入新用户的信息"
SwingConstants.CENTER);
用户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);
提交"
publicinsert_user_information(){
用户