📄 addnewuser.java
字号:
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
import javax.swing.*;
//添加新用户信息
public class addNewUser extends JFrame implements ActionListener{
Connection con=null;
ResultSet rs=null;
Statement st=null;
String uId=new String();
String uName=new String();
String uSex=new String();
String uBirth=new String();
String uTel=new String();
String uAddr=new String();
String uCardNum=new String();
String uIDCard=new String();
String command=null;
private boolean flag=true;
private JLabel userInfo=new JLabel("客户信息:");
private JLabel userIDLabel=new JLabel("客户ID:");
private JTextField userID=new JTextField(8);
private JLabel userNameLabel=new JLabel("姓 名:");
private JTextField userName=new JTextField(8);
private JLabel birthdayLabel=new JLabel("出生日期:");
private JLabel birthdayTypeLabel=new JLabel("(yyyy-mm-dd)");
private JTextField birthday=new JTextField(10);
private JLabel telLabel=new JLabel("电 话:");
private JTextField tel=new JTextField(11);
private JLabel addrLabel=new JLabel("地 址:");
private JTextField addr=new JTextField(30);
private JLabel sexLabel=new JLabel("性 别:");
private JTextField sex=new JTextField(6);
private JLabel userCardNumLabel=new JLabel("用户卡号:");
private JTextField userCardNum=new JTextField(18);
private JLabel userIDCardLabel=new JLabel("身份证");
private JTextField userIDCard=new JTextField(18);
private JButton addConfirm=new JButton("确定添加");
private JButton reEnter=new JButton("重新输入");
private JButton exit=new JButton("退 出");
private JLabel resultLabel=new JLabel("操作结果");
private JTextArea resultArea=new JTextArea(10,200);
//无参构造方法
public addNewUser(){
setup(); //初始化面板
}
//有参构造方法
public addNewUser(String card){
setup(); //初始化面板
userCardNum.setText(card);
}
//初始化面板
public void setup(){
setTitle("添加新用户");
setSize(600,500);
setLocation(300,250);
setResizable(false);
addWindowListener(new WindowAdapter(){
public void windowClosing(WindowEvent e){
addNewUser.this.hide();
}
});
resultArea.setEditable(true);
resultArea.setLineWrap(true);
Container c=getContentPane();
c.setLayout(null);
c.add(userInfo);
userInfo.setBounds(10,10,80,30);
c.add(userIDLabel);
userIDLabel.setBounds(30,40,60,30);
c.add(userID);
userID.setBounds(90,40,250,30);
c.add(userNameLabel);
userNameLabel.setBounds(350,40,60,30);
c.add(userName);
userName.setBounds(400,40,160,30);
c.add(birthdayLabel);
birthdayLabel.setBounds(30,80,60,30);
c.add(birthday);
birthday.setBounds(90,80,160,30);
c.add(birthdayTypeLabel);
birthdayTypeLabel.setBounds(260,80,100,30);
c.add(sexLabel);
sexLabel.setBounds(350,80,60,30);
c.add(sex);
sex.setBounds(400,80,160,30);
c.add(addrLabel);
addrLabel.setBounds(30,120,60,30);
c.add(addr);
addr.setBounds(90,120,250,30);
c.add(telLabel);
telLabel.setBounds(350,120,60,30);
c.add(tel);
tel.setBounds(400,120,160,30);
c.add(userCardNumLabel);
userCardNumLabel.setBounds(30,160,60,30);
c.add(userCardNum);
userCardNum.setBounds(90,160,250,30);
c.add(addConfirm);
c.add(userIDCardLabel);
userIDCardLabel.setBounds(350,160,60,30);
c.add(userIDCard);
userIDCard.setBounds(400,160,160,30);
addConfirm.setBounds(90,200,100,35);
addConfirm.addActionListener(this);
c.add(reEnter);
reEnter.setBounds(220,200,100,35);
reEnter.addActionListener(this);
c.add(exit);
exit.setBounds(340,200,100,35);
exit.addActionListener(this);
c.add(resultLabel);
resultLabel.setFont(new Font("宋体",Font.BOLD,16));
resultLabel.setBounds(240,240,100,45);
JScrollPane scrollpane=new JScrollPane(resultArea);
c.add(scrollpane);
scrollpane.setBounds(30,270,540,180);
show();
//st=connectDB.conDB();
}
//事件监听
public void actionPerformed(ActionEvent ae){
if(ae.getSource()==exit){
closeDB.closeDB(st,con);
confirmDialog exitDialog=new confirmDialog(this,"退出程序","真的要退出程序吗?");
if(exitDialog.isOkay){
addNewUser.this.hide();
}
}
else if(ae.getSource()==addConfirm){
flag=true;
if((userID.getText().trim()).equals("")||(userIDCard.getText().trim()).equals("")||(userName.getText().trim()).equals("")||(sex.getText().trim()).equals(""))
JOptionPane.showMessageDialog(null,"请输入信息再点击提交添加！");
else
{
uId=userID.getText().trim();
uName=userName.getText().trim();
uSex=sex.getText().trim();
uBirth=birthday.getText().trim();
uTel=tel.getText().trim();
uAddr=addr.getText().trim();
uIDCard=userIDCard.getText().trim();
uCardNum=userCardNum.getText().trim();
command="select * from usertable where userID='"+uId+"'";
try{
st=connectDB.conDB();//连接数据库
con=DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=BSMS","sa","5201314");
rs=st.executeQuery(command);
if(rs.next()){
JOptionPane.showMessageDialog(null,"用户已存在!");
flag=false;
}
}catch(SQLException ex){
while(ex!=null){
JOptionPane.showMessageDialog(null,ex);
ex.getNextException();
return;
}
}
command="select * from cardTable where userCardNum='"+uCardNum+"'";
try{
rs=st.executeQuery(command);
if(!rs.next()){
JOptionPane.showMessageDialog(null,"要添加的用户的卡号不存在!");
flag=false;
}
}catch(SQLException ex){
while(ex!=null){
JOptionPane.showMessageDialog(null,ex);
ex.getNextException();
return;
}
}
try{
command="insert into userTable(userID,userName,birthday,tel,addr,sex,userCardNum,userIDCard) values('"+uId+"','"+uName+"','"+uBirth+"','"+uTel+"','"+uAddr+"','"+uSex+"','"+uCardNum+"','"+uIDCard+"')";
if(flag){
st.executeUpdate(command);
JOptionPane.showMessageDialog(null,"添加新用户信息成功!");
resultArea.append("用户ID:"+uId+"\n");
resultArea.append("用户姓名:"+uName+"\n");
resultArea.append("性别:"+uSex+"\n");
resultArea.append("出生日期:"+uBirth+"\n");
resultArea.append("用户电话:"+uTel+"\n");
resultArea.append("用户地址:"+uAddr+"\n");
resultArea.append("用户卡号:"+uCardNum+"\n");
resultArea.append("用户身份证:"+uIDCard+"\n");
}
}
catch(Exception exx)
{
while(exx!=null){
JOptionPane.showMessageDialog(null,exx);
return;
}
}
}
closeDB.closeDB(st,con);
}
else if(ae.getSource()==reEnter){ //清空,重新输入
userID.setText("");
userName.setText("");
sex.setText("");
birthday.setText("");
tel.setText("");
addr.setText("");
userIDCard.setText("");
userCardNum.setText("");
flag=true;
}
}
public static void main(String args[]){
addNewUser addUser=new addNewUser();
}
}⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -