📄 paper.java
字号:
import java.io.*;
import java.awt.*;
import java.awt.event.*;
import java.util.*;
import java.util.Date;
import javax.swing.*;
import sun.audio.*;
import java.sql.*;
//import java.sql.Date;
import javax.swing.filechooser.*;
public class paper extends JFrame
{
private Connection connection;
private Statement statement;
private ResultSet resultSet;
private ResultSetMetaData rsMetaData;
//GUI变量定义
private JTable table;
private JTextArea inputQuery;
private JButton submitQuery;
JMenuBar mb1;//构建一个菜单栏组件mb1
JMenu mf1,me1,mg1,mh1,mlu,mfind,msee;
JMenuItem jmi;//中间字是相应选项英文缩写
int width,height;
Toolkit KT; //
ContinuousAudioDataStream cas,cas2;
Image im;
String picture="Logo.jpg";
//=============================================main
public static void main(String args[])
{
new paper();
}
//=======================================-初始化
public paper()
{
super("报刊管理系统--:华东交通大学软件学院 郭顺旭");
// denglu();
KT=this.getToolkit();//获得背景 简化代码
//width=KT.getScreenSize().width;
width=950;
height=713;
// height=KT.getScreenSize().height;
this.setIconImage(KT.getImage("dd.gif"));//窗体图片
this.setSize(new Dimension(width,height));
this.setContentPane(new MyTU());//
this.show();
this.setLocation(30,10) ;
this.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
System.exit(0);
}
});
}
//////////////////////////////////////////////////////////////////////////结果显示模块（OK）
public void displayResultSet( ResultSet rs )throws SQLException
{
JFrame f=new JFrame("结果显示");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
boolean moreRecords = rs.next(); //定位到达第一条记录
if ( ! moreRecords )
{ //如果没有记录，则提示一条消息
JOptionPane.showMessageDialog( this, "结果集中无记录" );
setTitle( "无记录显示" );
return;
}
Vector columnHeads = new Vector();
Vector rows = new Vector();
try { //获取字段的名称
ResultSetMetaData rsmd = rs.getMetaData();
for ( int i = 1; i <= rsmd.getColumnCount();++ i)//i=1,++i
columnHeads.addElement( rsmd.getColumnName( i ) );
do { //获取记录集
rows.addElement( getNextRow( rs, rsmd ) );
} while (rs.next());
/////////////////////
JTable table = new JTable( rows, columnHeads );//在表格中显示查询结果
//在表格中显示查询结果
JScrollPane scroller = new JScrollPane( table );
contentPane.add( scroller, BorderLayout.CENTER);
contentPane.validate(); //刷新Table
///////////////////////
table.setForeground(Color.blue);
table.setBackground(Color.yellow);
f.setLocation(20,240);
f.setSize(950,400);
//f.pack();
f.show();
}
catch ( SQLException sqlex ) {
sqlex.printStackTrace();
}
}
/////////////////////////////////////////////////////////////////
public Vector getNextRow( ResultSet rs, ResultSetMetaData rsmd )
throws SQLException
{
Vector currentRow = new Vector();
for ( int i = 1; i <=rsmd.getColumnCount(); ++i ) //i=1,++i
currentRow.addElement( rs.getString( i ) );
return currentRow; //返回一条记录
}
////////////////////////////////////////////////////////////////////////////增加数据模块
////////////////////////////////////////人员信息录入
public void personLuru()
{
final JFrame f=new JFrame("订阅人员信息录入");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
JPanel p1=new JPanel();
p1.setLayout(new GridLayout(5,2));
p1.setBorder(BorderFactory.createTitledBorder("请输入信息"));
JLabel l1=new JLabel("姓名");
final JTextField t1=new JTextField();
JLabel l2=new JLabel("地址");
final JTextField t2=new JTextField();
JLabel l3=new JLabel("电话");
final JTextField t3=new JTextField();
JLabel l4=new JLabel("性别");
final JTextField t4=new JTextField();
JButton que=new JButton("确定");
que.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("确定"))
{
dataBase();//链接数据库
String name,address,tel,sext,s="",t="";
int userNum=0;
try { //执行SQL语句自动产生订单号
String que = "select userNum from Person"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( que );
int count=0;
while(resultSet.next())
{
count++;
}
userNum=count+1;//订单号
name=t1.getText();//姓名
address=t2.getText();//地址
tel=t3.getText();//电话
sext=t4.getText(); //性别
String query = "insert into person values("+userNum+",'"+name+"','"+address+"',"+tel+",'"+sext+"')";//输入的sql语句
statement.executeUpdate( query );
JFrame pp=new JFrame("");
String title="友情提示";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="数据录入成功,你的订单号为: "+userNum;
JOptionPane.showMessageDialog(f,message,title,type);
pp.setLocation(400,400);
f.dispose();
} catch ( SQLException sqlex ) {
sqlex.printStackTrace();
JFrame pp=new JFrame("");
String title="友情提示";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="性别只能为男或女";
JOptionPane.showMessageDialog(f,message,title,type);
pp.setLocation(400,400);
}
}//if
}
}); //确定 end
JButton cal=new JButton("取消");
cal.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("取消"))
{
f.dispose();
}
}
});
p1.add(l1);//姓名
p1.add(t1);
p1.add(l2);//地址
p1.add(t2);
p1.add(l3);//电话
p1.add(t3);
p1.add(l4);//性别
p1.add(t4);
p1.add(que);//确定
p1.add(cal);//取消
contentPane.add(p1);//将面板p1加入窗体中
f.setLocation(400,300);
f.setSize(300,200); //设置窗体大小
f.show(); //显示窗口
f.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {
f.dispose();
}
});
}
////////////////////////////////////////////////////////、、、、、、、、、、、、部门信息录入
public void DepLuru()
{
final JFrame f=new JFrame("部门信息录入");
Container contentPane=f.getContentPane();
contentPane.setLayout(new BorderLayout());
////////----
JPanel p1=new JPanel();
p1.setLayout(new GridLayout(7,2));
p1.setBorder(BorderFactory.createTitledBorder("请输入信息"));
JLabel l1=new JLabel("公司代号");
final JTextField t1=new JTextField();
JLabel l2=new JLabel("公司名");
final JTextField t2=new JTextField();
JLabel l3=new JLabel("公司地址");
final JTextField t3=new JTextField();
JLabel l4=new JLabel("部门名");
final JTextField t4=new JTextField();
JLabel l5=new JLabel("部门地址");
final JTextField t5=new JTextField();
JLabel l6=new JLabel("部门电话");
final JTextField t6=new JTextField();
JButton que=new JButton("确定");
que.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("确定"))
{
dataBase();//链接数据库
String Dname,Daddress,Dtel,CompanyName,CompanyNum,booknum,comAddress,ss="",tt="";
try { //执行SQL语句自动产生订单号
String que = "select booknum from dbook"; //接受输入的sql语句
statement = connection.createStatement();
resultSet = statement.executeQuery( que );
int count=0,bookNum=0;
while(resultSet.next())
{
count++;
}
CompanyNum=t1.getText();
CompanyName=t2.getText();//
comAddress =t3.getText();
Dname=t4.getText();//部门名
Daddress=t5.getText();//部门地址
bookNum=count+1;//订单号
Dtel=t6.getText();//部门电话
String ff= "select companyNum,Dname from department";
statement = connection.createStatement();
ResultSet result = statement.executeQuery( ff );
boolean ee=true;
while(result.next()&&ee)
{
tt= result.getString("companyNum");
ss= result.getString("Dname");
if(CompanyNum.equals(tt))//当输入的姓名与文件中的相同
{
if(Dname.equals(ss))
{ ee=false;
JFrame ppp=new JFrame("");
String title="友情提示";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="录入数据已经存在";
JOptionPane.showMessageDialog(f,message,title,type);
ppp.setLocation(400,400);
}
else
{
String ru = "insert into department values("+CompanyNum+",'"+Dname+"','"+ Daddress+"',"+bookNum+","+Dtel+")";//输入的sql语句
statement.executeUpdate( ru );
JFrame pp=new JFrame("");
String title="友情提示";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="公司已经存在，将部门信息数据录入成功，订单号 ："+ bookNum;
JOptionPane.showMessageDialog(f,message,title,type);
pp.setLocation(400,400);
f.dispose();
}
}
else{
String query = "insert into company values("+CompanyNum+",'"+CompanyName+"','"+ comAddress+"')";//输入的sql语句
statement.executeUpdate( query );
String ru = "insert into department values("+CompanyNum+",'"+Dname+"','"+ Daddress+"',"+bookNum+","+Dtel+")";//输入的sql语句
statement.executeUpdate( ru );
JFrame pp=new JFrame("");
String title="友情提示";
int type=JOptionPane.PLAIN_MESSAGE;
type=JOptionPane.INFORMATION_MESSAGE;
String message="你的全部数据录入成功!订单号为："+bookNum;
JOptionPane.showMessageDialog(f,message,title,type);
pp.setLocation(400,400);
f.dispose();
}
}//while end
} catch ( SQLException sqlex ) { sqlex.printStackTrace(); }
}//if 监听
}
}); //确定 end
JButton cal=new JButton("取消");
cal.addActionListener(new ActionListener(){
public void actionPerformed(ActionEvent ev){
if((ev.getActionCommand()).equals("取消"))
{
f.dispose();
}
}
});
p1.add(l1);//公司编号
p1.add(t1);
p1.add(l2);//公司名
p1.add(t2);
p1.add(l3);//公司地址
p1.add(t3);
p1.add(l4);//部门名
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -