//javafx选用jdk8
import java.sql.*;
import java.io.*;
import java.security.acl.Group;
import javafx.application.*;
import javafx.beans.value.*;
import javafx.collections.*;
import javafx.geometry.*;
import javafx.scene.Scene;
import javafx.stage.FileChooser;
import javafx.stage.Stage;
import javafx.scene.text.*;
import javafx.scene.control.*;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.layout.*;
public class Java extends Application
{
private static TextField tf=new TextField();
private PasswordField pf=new PasswordField();
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
private static String password="123456";
@Override
public void start(Stage stage)
{
final Label username=new Label("用户名:");
final Label userpassword=new Label("密 码:");
final Button login=new Button("登录");
final Button enroll=new Button("注册");
enroll.setOnAction(e->{
Enroll enr=new Enroll();
enr.start(new Stage());
stage.hide();
});
enroll.setTranslateX(-60);
login.setTranslateX(80);
StackPane spane=new StackPane();
Text text=new Text("欢迎进入通讯录");
text.setFont(new Font("黑体",20));
text.setTranslateY(80);
spane.getChildren().add(text);
tf.setPromptText("电话/用户名");
pf.setPromptText("请输入密码");
GridPane gpane=new GridPane();
gpane.setHgap(10);
gpane.setVgap(15);
gpane.setAlignment(Pos.CENTER);
gpane.add(username, 0, 0);
gpane.add(tf, 1, 0);
gpane.add(userpassword, 0, 1);
gpane.add(pf, 1, 1);
gpane.add(login, 1, 2);
gpane.add(enroll, 2, 2);
BorderPane bpane=new BorderPane();
bpane.setTop(spane);
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("错误");
alert.setHeaderText(null);
bpane.setCenter(gpane);
login.setOnAction(e->{
if(tf.getText().equals("")||pf.getText().equals("")) {
alert.setContentText("用户和密码字段不能为空!");
alert.showAndWait();
}else {
String selectsql="select users from user;";
String selectsql1="select upassword from user where users=?";
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(selectsql);
rs=ps.executeQuery();
boolean bool=true;
while(rs.next()) {
if(tf.getText().equals(rs.getString("users"))) {
ps=conn.prepareStatement(selectsql1);
ps.setString(1, tf.getText());
rs=ps.executeQuery();
while(rs.next()) {
if(pf.getText().equals(rs.getString("upassword"))) {
Communication comm=new Communication();
comm.USER=tf.getText();
comm.start(new Stage());
tf.setText("");
stage.hide();
}else {
alert.setContentText("密码错误!");
alert.showAndWait();
pf.setText("");
break;
}
}
}else {
bool=false;
}
}
if(bool=false) {
alert.setContentText("请先注册!");
alert.showAndWait();
}
}catch(Exception ex) {
ex.toString();
}
}});
Scene scene=new Scene(bpane,500,400);
stage.setTitle("登录");
stage.setScene(scene);
stage.show();
}
}
class Communication extends Application
{
public static String USER;
@Override
public void start(Stage stage)
{
Text t=new Text(USER);
USER=t.getText();
Java java=new Java();
BorderPane bpane=new BorderPane();
final Button add=new Button("添加好友到通讯录中");
add.setOnAction(e->{
AddFriend addf=new AddFriend();
addf.username=t.getText();
addf.start(new Stage());
stage.hide();
});
final Button del=new Button("将好友从通讯录删除");
del.setOnAction(e->{
DelFriend delf=new DelFriend();
delf.User=t.getText();
delf.start(new Stage());
stage.close();
});
final Button update =new Button("修改通讯录好友信息");
update.setOnAction(e->{
UpdateFriend upf=new UpdateFriend();
upf.User=t.getText();
upf.start(new Stage());
stage.close();
});
final Button find=new Button("从通讯录中查询好友");
find.setOnAction(e->{
FindFriend findf=new FindFriend();
findf.User=t.getText();
findf.start(new Stage());
stage.close();
});
final Button output=new Button("导出通讯录好友信息");
output.setOnAction(e->{
Output op=new Output();
op.User=t.getText();
op.start(new Stage());
stage.close();
});
Label lab=new Label("用户:");
t.setTranslateX(-40);
Button manager=new Button("管理账号");
HBox hb=new HBox(50);
hb.setTranslateX(380);
manager.setTranslateX(170);
manager.setTranslateY(-40);
hb.setTranslateY(-40);
hb.getChildren().addAll(lab,t);
VBox vb=new VBox(10);
vb.setAlignment(Pos.CENTER);
Text te=new Text("请从下列选项中选择您需要的操作");
te.setFont(new Font("黑体",20));
te.setTranslateY(-30);
vb.getChildren().addAll(hb,manager,te,add,del,update,find,output);
bpane.setCenter(vb);
manager.setOnAction(e->{
Manager m=new Manager();
m.User=t.getText();
m.start(new Stage());
});
Scene scene=new Scene(bpane,500,400);
stage.setScene(scene);
stage.setTitle("通讯录");
stage.show();
}
}
class Manager extends Application
{
public static String User;
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
@Override
public void start(Stage stage)
{
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("提示");
alert.setHeaderText(null);
Label lab1=new Label("修改密码");
lab1.setFont(new Font("黑体",17));
Label lab2=new Label("原密码:");
lab2.setFont(new Font("黑体",15));
Label lab3=new Label("新密码:");
lab3.setFont(new Font("黑体",15));
Label lab4=new Label("电话更改");
lab4.setFont(new Font("黑体",17));
Label lab5=new Label("原电话:");
lab5.setFont(new Font("黑体",15));
Label lab6=new Label("新电话:");
lab6.setFont(new Font("黑体",15));
PasswordField oldpf=new PasswordField();
PasswordField newpf=new PasswordField();
TextField oldtf=new TextField();
TextField newtf=new TextField();
oldpf.setPromptText("请输入原密码");
newpf.setPromptText("请输入新密码");
oldtf.setPromptText("请输入旧的电话号码");
newtf.setPromptText("请输入新的电话号码");
Label lab7=new Label("账号管理:");
lab7.setFont(new Font("黑体",17));
Button but1=new Button("切换账号");
Button but2=new Button("退出登录");
HBox hb1=new HBox(10);
hb1.getChildren().addAll(lab2,oldpf);
HBox hb2=new HBox(10);
hb2.getChildren().addAll(lab3,newpf);
VBox vb1=new VBox(10);
vb1.getChildren().addAll(hb1,hb2);
HBox hb3=new HBox(10);
hb3.getChildren().addAll(lab5,oldtf);
HBox hb4=new HBox(10);
hb4.getChildren().addAll(lab6,newtf);
VBox vb2=new VBox(10);
vb2.getChildren().addAll(hb3,hb4);
vb1.setTranslateX(20);
vb2.setTranslateX(20);
HBox hb5=new HBox(20);
hb5.getChildren().addAll(but1,but2);
hb5.setTranslateX(-170);
Button save=new Button("保存");
Button cannel =new Button("取消");
HBox hb=new HBox(20);
hb.getChildren().addAll(save,cannel);
GridPane gpane=new GridPane();
gpane.add(lab1, 0, 0);
gpane.add(vb1, 0, 1);
gpane.add(lab4, 0, 2);
gpane.add(vb2, 0, 3);
gpane.add(lab7, 0, 4);
gpane.add(hb5, 1, 4);
gpane.add(hb, 1, 7);
gpane.setAlignment(Pos.CENTER);
gpane.setTranslateX(70);
gpane.setVgap(10);
String select="select upassword,usertelephone from user where users=?";
String updatepf="update user set upassword=? where users=?";
String updatetf="update user set usertelephone=? where users=?";
save.setOnAction(e->{
try {
Connection conn=DriverManager.getConnection(url,user,password);
PreparedStatement ps=conn.prepareStatement(select);
Class.forName(driver);
ps.setString(1, User);
ResultSet rs=ps.executeQuery();
while(rs.next()) {
String strpassword=rs.getString("upassword");
String strteltephone=rs.getString("usertelephone");
if(oldpf.getText().length()>1) {
if(oldpf.getText().equals(strpassword)) {
ps=conn.prepareStatement(updatepf);
ps.setString(1,newpf.getText());
ps.setString(2, User);
ps.executeUpdate();
alert.setContentText("密码修改成功!");
alert.showAndWait();
oldpf.setText("");
newpf.setText("");
break;
}else {
alert.setContentText("原密码错误，请重新输入!");
alert.showAndWait();
oldpf.setText("");
break;
}
}if(oldtf.getText().length()==11) {
if(oldtf.getText().equals(strteltephone)) {
ps=conn.prepareStatement(updatetf);
ps.setString(1,newtf.getText());
ps.setString(2, User);
ps.executeUpdate();
alert.setContentText("电话修改成功!");
alert.showAndWait();
oldtf.setText("");
newtf.setText("");
break;
}else {
alert.setContentText("原号码错误，请重新输入!");
alert.showAndWait();
oldpf.setText("");
break;
}
}if(oldpf.getText()==null&&newpf.getText()==null&&oldtf.getText()==null&&newtf.getText()==null) {
alert.setContentText("修改的内容不能为空!");
alert.showAndWait();
}
}
}catch(Exception ex) {
ex.printStackTrace();
}
});
cannel.setOnAction(e->{
stage.close();
});
but1.setOnAction(e->{
Java java=new Java();
java.start(new Stage());
});
but2.setOnAction(e->{
Platform.exit();
});
stage.setTitle(User);
StackPane stack=new StackPane();
stack.getChildren().add(gpane);
Scene scene=new Scene(stack,500,400);
stage.setScene(scene);
stage.show();
}
}
class AddFriend extends Application
{
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
public static String username;
private static String GroupRadioButton;
private static String GroupSex;
private static String str=" ";
@SuppressWarnings("resource")
@Override
public void start(Stage stage)
{
StackPane spane=new StackPane();
spane.setAlignment(Pos.CENTER);
spane.setPadding(new Insets(30));
Label name=new Label("姓名:");
Label group=new Label("分组:");
Label sex=new Label("性别:");
Label age=new Label("年龄:");
TextField tname=new TextField();
RadioButton familyers=new RadioButton("家人");
RadioButton colleague=new RadioButton("同事");
RadioButton schoolmate=new RadioButton("同学");
RadioButton teacher=new RadioButton("老师");
RadioButton friend=new RadioButton("朋友");
ToggleGroup toggroup=new ToggleGroup();
familyers.setToggleGroup(toggroup);
colleague.setToggleGroup(toggroup);
schoolmate.setToggleGroup(toggroup);
teacher.setToggleGroup(toggroup);
friend.setToggleGroup(toggroup);
HBox hbgroup=new HBox(10);
hbgroup.getChildren().addAll(group,familyers,colleague,schoolmate,teacher,friend);
RadioButton boy=new RadioButton("男");
RadioButton girl=new RadioButton("女");
ToggleGroup tog=new ToggleGroup();
boy.setToggleGroup(tog);
girl.setToggleGroup(tog);
HBox hbname=new HBox(10);
HBox hbsex=new HBox(10);
hbname.getChildren().addAll(name,tname);
hbsex.getChildren().addAll(sex,boy,girl);
VBox vb=new VBox(10);
Slider slider=new Slider();
Text tage=new Text("0");
slider.setMin(1);
slider.setMax(100);
slider.setShowTickLabels(true);
slider.setShowTickMarks(true);
slider.valueProperty().addListener(ov->{
double value=slider.getValue();
int valu=(int)value;
String strs=String.valueOf(valu);
tage.setText(strs);
});
slider.setPrefWidth(200);
HBox hbage=new HBox(10);
hbage.getChildren().addAll(age,slider,tage);
Label telephone=new Label("电话:");
TextField ttel=new TextField();
HBox hbtelephone=new HBox(10);
hbtelephone.getChildren().addAll(telephone,ttel);
Label mail=new Label("邮箱:");
TextField tmail=new TextField();
HBox hbmail=new HBox(10);
hbmail.getChildren().addAll(mail,tmail);
Label Lcity=new Label("现居住城市:");
ComboBox<String>cbo=new ComboBox<String>();
String[] city= {"北京市","上海市","广州市 ","深圳市","天津市","成都市","杭州市","苏州市","重庆市","武汉市","南京市","大连市","沈阳市","长沙市","郑州市","西安市","青岛市","无锡市","无锡市","宁波市","佛山市","南通市","哈尔滨市","东莞市","福州市","长春市","石家庄市","烟台市","合肥市","唐山市","常州市","太原市","昆明市","潍坊市","南昌市","泉州市","温州市","绍兴市","嘉兴市","厦门市","贵阳市","淄博市","徐州市","扬州市","呼和浩特市","鄂尔多斯市","乌鲁木齐市","金华市","台州市","镇江市","威海市","珠海市","东营市","大庆市","中山市","盐城市","包头市","保定市","济宁市","兰州市"};
ObservableList<String>items=FXCollections.observableArrayList(city);
cbo.getItems().addAll(items);
cbo.setPrefWidth(130);
cbo.setValue("请选择城市");
HBox hbcity=new HBox(10);
hbcity.getChildren().addAll(Lcity,cbo);
Label hobby=new Label("爱好:");
CheckBox cb1=new CheckBox("球类运动");
CheckBox cb2=new CheckBox("文学阅读");
CheckBox cb3=new CheckBox("文学创造");
CheckBox cb4=new CheckBox("听音乐");
CheckBox cb5=new CheckBox("看电影");
CheckBox cb6=new CheckBox("绘画");
CheckBox cb7=new CheckBox("舞蹈");
CheckBox cb8=new CheckBox("冒险");
CheckBox cb9=new CheckBox("收藏");
CheckBox cb10=new CheckBox("网络游戏");
CheckBox cb11=new CheckBox("喝茶");
CheckBox cb12=new CheckBox("探索");
VBox vb1=new VBox(10);
VBox vb2=new VBox(10);
VBox vb3=new VBox(10);
VBox vb4=new VBox(10);
vb1.getChildren().addAll(cb1,cb2,cb3);
vb2.getChildren().addAll(cb4,cb5,cb6);
vb3.getChildren().addAll(cb7,cb8,cb9);
vb4.getChildren().addAll(cb10,cb11,cb12);
HBox hb=new HBox(10);
hb.getChildren().addAll(hobby,vb1,vb2,vb3,vb4);
TextArea ta=new TextArea();
Text tevent=new Text("记录你我之间的每一份美好");
ta.setPromptText("记录你我的点滴");
ta.setPrefHeight(200);
ta.setWrapText(true);
Button save=new Button("添加");
save.setTranslateX(100);
save.setPrefWidth(300);
save.setPrefHeight(30);
save.setFont(new Font("黑体",16));
Label remark=new Label("备注:");
TextField tremark=new TextField();
HBox hbremark=new HBox(10);
hbremark.getChildren().addAll(remark,tremark);
Button exit=new Button("取消");
exit.setTranslateX(100);
exit.setPrefHeight(30);
HBox hbo=new HBox(10);
hbo.getChildren().addAll(save,exit);
exit.setOnAction(e->{
Communication comm=new Communication();
comm.start(new Stage());
stage.close();
});
vb.getChildren().addAll(hbname,hbgroup,hbsex,hbage,hbtelephone,hbmail,hbcity,hb,hbremark,tevent,ta,hbo);
spane.getChildren().add(vb);
stage.setTitle("添加好友到通讯录中");
toggroup.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (toggroup.getSelectedToggle() != null) {
RadioButton button = (RadioButton) toggroup.getSelectedToggle();
GroupRadioButton=button.getText();
}
}
});
tog.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (tog.getSelectedToggle() != null) {
RadioButton button = (RadioButton) tog.getSelectedToggle();
GroupSex=button.getText();
}
}
});
cb1.setOnAction(e->{str+=cb1.getText()+"、";});
cb2.setOnAction(e->{str+=cb2.getText()+"、";});
cb3.setOnAction(e->{str+=cb3.getText()+"、";});
cb4.setOnAction(e->{str+=cb4.getText()+"、";});
cb5.setOnAction(e->{str+=cb5.getText()+"、";});
cb6.setOnAction(e->{str+=cb6.getText()+"、";});
cb7.setOnAction(e->{str+=cb7.getText()+"、";});
cb8.setOnAction(e->{str+=cb8.getText()+"、";});
cb9.setOnAction(e->{str+=cb9.getText()+"、";});
cb10.setOnAction(e->{str+=cb10.getText()+"、";});
cb11.setOnAction(e->{str+=cb11.getText()+"、";});
cb12.setOnAction(e->{str+=cb12.getText()+"、";});
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("提示");
alert.setHeaderText(null);
save.setOnAction(e->{
Connection conn=null;
PreparedStatement ps=null;
String insertcomm="insert into Communication values(?,?,?,?,?,?,?,?,?,?);";
String insertclass="insert into Classification values(?,?,?);";
if(tname.getText()!=null&&GroupSex!=null&&tage.getText()!=null&&ttel.getText()!=null) {
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(insertcomm);
ps.setString(1, username);
ps.setString(2, tname.getText());
ps.setString(3, GroupSex);
int fage=Integer.parseInt(tage.getText());
ps.setInt(4, fage);
ps.setString(5, ttel.getText());
ps.setString(6, tmail.getText());
ps.setString(7, cbo.getValue());
ps.setString(8, str);
ps.setString(9, tremark.getText());
ps.setString(10, ta.getText());
ps.executeUpdate();
alert.setContentText("好友添加成功");
alert.showAndWait();
ps=conn.prepareStatement(insertclass);
ps.setString(1, tname.getText());
ps.setString(2, GroupRadioButton);
ps.setString(3, ttel.getText());
ps.executeUpdate();
stage.close();
Communication comm=new Communication();
comm.start(new Stage());
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(ps!=null)ps.close();
if(conn!=null)conn.close();
}catch(Exception ex) {
ex.printStackTrace();
}
}
}else {
alert.setContentText("好友信息不能为空");
alert.showAndWait();
}
});
Scene scene=new Scene(spane,600,700);
stage.setScene(scene);
stage.show();
}
}
class DelFriend extends Application
{
public static String User;
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
@Override
public void start(Stage stage)
{
Text t=new Text("请输入您要删除的好友的姓名");
t.setFont(new Font("黑体",18));
Label lab=new Label("姓名:");
TextField text=new TextField();
Button button=new Button("删除");
button.setPrefWidth(100);
Button cannel=new Button("取消");
cannel.setOnAction(e->{
Communication comm=new Communication();
comm.start(new Stage());
stage.close();
});
HBox deca=new HBox(20);
deca.getChildren().addAll(button,cannel);
deca.setTranslateY(-150);
deca.setTranslateX(20);
deca.setAlignment(Pos.CENTER);
StackPane spane=new StackPane();
spane.setPadding(new Insets(100));
spane.getChildren().add(t);
HBox hb=new HBox(10);
hb.setTranslateY(-120);
hb.setAlignment(Pos.CENTER);
hb.getChildren().addAll(lab,text);
BorderPane bpane=new BorderPane();
bpane.setTop(spane);
bpane.setCenter(hb);
bpane.setBottom(deca);
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("错误");
alert.setHeaderText(null);
button.setOnAction(e->{
String selectsql="select cName from Communication where users=?;";
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(selectsql);
ps.setString(1, User);
rs=ps.executeQuery();
if(text.getText()!=null) {
while(rs.next()) {
if(text.getText().equals(rs.getString("cName"))) {
String name=text.getText();
String deletesql="delete from Communication where cName=?;";
String delete="delete from Classification where cName=?;";
try {
ps=conn.prepareStatement(deletesql);
ps.setString(1, name);
ps.executeUpdate();
ps=conn.prepareStatement(delete);
ps.setString(1,name);
ps.executeUpdate();
alert.setContentText(name+"已从您的通讯录中成功删除！");
alert.showAndWait();
Communication comm=new Communication();
comm.start(new Stage());
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
}else {
alert.setContentText("请输入您要删除的好友的姓名！");
alert.showAndWait();
}
}catch(Exception ex) {
ex.printStackTrace();
}
});
Scene scene=new Scene(bpane,500,400);
stage.setTitle("将好友从通讯录中删除");
stage.setScene(scene);
stage.show();
}
}
class UpdateFriend extends Application
{
public static String User;
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
private static String GroupRadioButton;
private static String GroupSex;
private static String str="";
@SuppressWarnings({ "resource", "unused" })
@Override
public void start(Stage stage)
{
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("提示");
alert.setHeaderText(null);
String u=User;
Text t=new Text("请先调出您要修改的好友");
t.setFont(new Font("黑体",20));
StackPane stack=new StackPane();
TextField te=new TextField();
Label queryname=new Label("姓名:");
Button button=new Button("查询");
HBox hbox=new HBox(10);
hbox.getChildren().addAll(queryname,te,button);
hbox.setTranslateX(70);
hbox.setTranslateY(50);
stack.getChildren().addAll(t,hbox);
stack.setPadding(new Insets(40));
stack.setTranslateY(-30);
StackPane spane=new StackPane();
spane.setAlignment(Pos.CENTER);
spane.setPadding(new Insets(30));
Label name=new Label("姓名:");
Label group=new Label("分组:");
Label sex=new Label("性别:");
Label age=new Label("年龄:");
TextField tname=new TextField();
RadioButton familyers=new RadioButton("家人");
RadioButton colleague=new RadioButton("同事");
RadioButton schoolmate=new RadioButton("同学");
RadioButton teacher=new RadioButton("老师");
RadioButton friend=new RadioButton("朋友");
ToggleGroup toggroup=new ToggleGroup();
familyers.setToggleGroup(toggroup);
colleague.setToggleGroup(toggroup);
schoolmate.setToggleGroup(toggroup);
teacher.setToggleGroup(toggroup);
friend.setToggleGroup(toggroup);
HBox hbgroup=new HBox(10);
hbgroup.getChildren().addAll(group,familyers,colleague,schoolmate,teacher,friend);
RadioButton boy=new RadioButton("男");
RadioButton girl=new RadioButton("女");
ToggleGroup tog=new ToggleGroup();
boy.setToggleGroup(tog);
girl.setToggleGroup(tog);
HBox hbname=new HBox(10);
HBox hbsex=new HBox(10);
hbname.getChildren().addAll(name,tname);
hbsex.getChildren().addAll(sex,boy,girl);
VBox vb=new VBox(10);
Slider slider=new Slider();
Text tage=new Text("0");
slider.setMin(1);
slider.setMax(100);
slider.setShowTickLabels(true);
slider.setShowTickMarks(true);
slider.valueProperty().addListener(ov->{
double value=slider.getValue();
int valu=(int)value;
String strs=String.valueOf(valu);
tage.setText(strs);
});
slider.setPrefWidth(200);
HBox hbage=new HBox(10);
hbage.getChildren().addAll(age,slider,tage);
Label telephone=new Label("电话:");
TextField ttel=new TextField();
HBox hbtelephone=new HBox(10);
hbtelephone.getChildren().addAll(telephone,ttel);
Label mail=new Label("邮箱:");
TextField tmail=new TextField();
HBox hbmail=new HBox(10);
hbmail.getChildren().addAll(mail,tmail);
Label Lcity=new Label("现居住城市:");
ComboBox<String>cbo=new ComboBox<String>();
String[] city= {"北京市","上海市","广州市 ","深圳市","天津市","成都市","杭州市","苏州市","重庆市","武汉市","南京市","大连市","沈阳市","长沙市","郑州市","西安市","青岛市","无锡市","无锡市","宁波市","佛山市","南通市","哈尔滨市","东莞市","福州市","长春市","石家庄市","烟台市","合肥市","唐山市","常州市","太原市","昆明市","潍坊市","南昌市","泉州市","温州市","绍兴市","嘉兴市","厦门市","贵阳市","淄博市","徐州市","扬州市","呼和浩特市","鄂尔多斯市","乌鲁木齐市","金华市","台州市","镇江市","威海市","珠海市","东营市","大庆市","中山市","盐城市","包头市","保定市","济宁市","兰州市"};
ObservableList<String>items=FXCollections.observableArrayList(city);
cbo.getItems().addAll(items);
cbo.setPrefWidth(130);
cbo.setValue("请选择城市");
HBox hbcity=new HBox(10);
hbcity.getChildren().addAll(Lcity,cbo);
Label hobby=new Label("爱好:");
CheckBox cb1=new CheckBox("球类运动");
CheckBox cb2=new CheckBox("文学阅读");
CheckBox cb3=new CheckBox("文学创造");
CheckBox cb4=new CheckBox("听音乐");
CheckBox cb5=new CheckBox("看电影");
CheckBox cb6=new CheckBox("绘画");
CheckBox cb7=new CheckBox("舞蹈");
CheckBox cb8=new CheckBox("冒险");
CheckBox cb9=new CheckBox("收藏");
CheckBox cb10=new CheckBox("网络游戏");
CheckBox cb11=new CheckBox("喝茶");
CheckBox cb12=new CheckBox("探索");
VBox vb1=new VBox(10);
VBox vb2=new VBox(10);
VBox vb3=new VBox(10);
VBox vb4=new VBox(10);
vb1.getChildren().addAll(cb1,cb2,cb3);
vb2.getChildren().addAll(cb4,cb5,cb6);
vb3.getChildren().addAll(cb7,cb8,cb9);
vb4.getChildren().addAll(cb10,cb11,cb12);
HBox hb=new HBox(10);
hb.getChildren().addAll(hobby,vb1,vb2,vb3,vb4);
TextArea ta=new TextArea();
Text tevent=new Text("记录你我之间的每一份美好");
ta.setPromptText("记录你我的点滴");
ta.setPrefHeight(200);
ta.setWrapText(true);
Button save=new Button("保存修改");
Button cannel=new Button("取消");
cannel.setOnAction(e->{
stage.close();
Communication comm=new Communication();
comm.start(new Stage());
});
HBox hbo=new HBox(20);
hbo.setTranslateX(100);
hbo.getChildren().addAll(save,cannel);
save.setPrefWidth(300);
save.setPrefHeight(30);
cannel.setPrefHeight(30);
save.setFont(new Font("黑体",16));
Label remark=new Label("备注:");
TextField tremark=new TextField();
HBox hbremark=new HBox(10);
hbremark.getChildren().addAll(remark,tremark);
vb.getChildren().addAll(stack,hbname,hbgroup,hbsex,hbage,hbtelephone,hbmail,hbcity,hb,hbremark,tevent,ta,hbo);
spane.getChildren().add(vb);
stage.setTitle("修改通讯录好友信息");
toggroup.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (toggroup.getSelectedToggle() != null) {
RadioButton button = (RadioButton) toggroup.getSelectedToggle();
GroupRadioButton=button.getText();
}
}
});
tog.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (tog.getSelectedToggle() != null) {
RadioButton button = (RadioButton) tog.getSelectedToggle();
GroupSex=button.getText();
}
}
});
cb1.setOnAction(e->{str+=cb1.getText()+"、";});
cb2.setOnAction(e->{str+=cb2.getText()+"、";});
cb3.setOnAction(e->{str+=cb3.getText()+"、";});
cb4.setOnAction(e->{str+=cb4.getText()+"、";});
cb5.setOnAction(e->{str+=cb5.getText()+"、";});
cb6.setOnAction(e->{str+=cb6.getText()+"、";});
cb7.setOnAction(e->{str+=cb7.getText()+"、";});
cb8.setOnAction(e->{str+=cb8.getText()+"、";});
cb9.setOnAction(e->{str+=cb9.getText()+"、";});
cb10.setOnAction(e->{str+=cb10.getText()+"、";});
cb11.setOnAction(e->{str+=cb11.getText()+"、";});
cb12.setOnAction(e->{str+=cb12.getText()+"、";});
button.setOnAction(e->{
try {
Class.forName(driver);
String selectsql="select cName from Communication where users=?";
Connection con=DriverManager.getConnection(url,user,password);
PreparedStatement ps=con.prepareStatement(selectsql);
ps.setString(1, u);
ResultSet rs=ps.executeQuery();
boolean bool=true;
while(rs.next()) {
if(te.getText().equals(rs.getString("cName"))) {
String selectname=te.getText();
String select="select Communication.*,Classification.sectionalization from Communication,Classification where Communication.telephone=classification.telephone and Communication.cName=?";
ps=con.prepareStatement(select);
ps.setString(1, selectname);
rs=ps.executeQuery();
while(rs.next()) {
String sname=rs.getString("cName");
String sgroup=rs.getString("sectionalization");
String ssex=rs.getString("sex");
int iage=rs.getInt("age");
String sage=String.valueOf(iage);
String stel=rs.getString("telephone");
String smail=rs.getString("mailbox");
String scity=rs.getString("city");
String shobby=rs.getString("hobby");
String sremark=rs.getString("remark");
String sevent=rs.getString("cevent");
tname.setText(sname);
if(familyers.getText().equals(sgroup))
familyers.setSelected(true);
else if(colleague.getText().equals(sgroup))
colleague.setSelected(true);
else if(schoolmate.getText().equals(sgroup))
schoolmate.setSelected(true);
else if(teacher.getText().equals(sgroup))
teacher.setSelected(true);
else if(friend.getText().equals(sgroup))
friend.setSelected(true);
if(boy.getText().equals(ssex))
boy.setSelected(true);
else girl.setSelected(true);
tage.setText(sage);
slider.setValue(iage);
ttel.setText(stel);
tmail.setText(smail);
cbo.setValue(scity);
String[] hob=new String[12];
int n=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int j=0;j<n;j++) {
if(cb1.getText().equals(hob[j])) cb1.setSelected(true);
if(cb2.getText().equals(hob[j])) cb2.setSelected(true);
if(cb3.getText().equals(hob[j])) cb3.setSelected(true);
if(cb4.getText().equals(hob[j])) cb4.setSelected(true);
if(cb5.getText().equals(hob[j])) cb5.setSelected(true);
if(cb6.getText().equals(hob[j])) cb6.setSelected(true);
if(cb7.getText().equals(hob[j])) cb7.setSelected(true);
if(cb8.getText().equals(hob[j])) cb8.setSelected(true);
if(cb9.getText().equals(hob[j])) cb9.setSelected(true);
if(cb10.getText().equals(hob[j])) cb10.setSelected(true);
if(cb11.getText().equals(hob[j])) cb11.setSelected(true);
if(cb12.getText().equals(hob[j])) cb12.setSelected(true);
}
tremark.setText(sremark);
ta.setText(sevent);
bool=true;
break;
}
}else {
bool=false;
}
}if(bool==false) {
alert.setContentText("查无此人!");
alert.showAndWait();
}
}catch(Exception ex) {
ex.printStackTrace();
}
});
save.setOnAction(e->{
Connection conn=null;
PreparedStatement ps=null;
String uname=te.getText();
String insertcomm="update Communication set users=?,cName=?,sex=?,age=?,telephone=?,mailbox=?,city=?,hobby=?,remark=?,cevent=? where cName=?;";
String insertclass="update Classification set cName=?,sectionalization=?,telephone=? where cName=?;";
if(te.getText().equals("")) {
alert.setContentText("修改信息不能为空");
alert.showAndWait();
}
else {
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(insertcomm);
ps.setString(1, u);
ps.setString(2, tname.getText());
ps.setString(3, GroupSex);
int fage=Integer.parseInt(tage.getText());
ps.setInt(4, fage);
ps.setString(5, ttel.getText());
ps.setString(6, tmail.getText());
ps.setString(7, cbo.getValue());
ps.setString(8, str);
ps.setString(9, tremark.getText());
ps.setString(10, ta.getText());
ps.setString(11, uname);
ps.executeUpdate();
alert.setTitle("提示");
alert.setContentText(te.getText()+"的信息已修改成功!");
alert.showAndWait();
ps=conn.prepareStatement(insertclass);
ps.setString(1, tname.getText());
ps.setString(2, GroupRadioButton);
ps.setString(3, ttel.getText());
ps.setString(4, uname);
ps.executeUpdate();
stage.close();
Communication comm=new Communication();
comm.start(new Stage());
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(ps!=null)ps.close();
if(conn!=null)conn.close();
}catch(Exception ex) {
ex.printStackTrace();
}
}
}
});
Scene scene=new Scene(spane,600,800);
stage.setScene(scene);
stage.show();
}
}
class FindFriend extends Application
{
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
public static String User;
private static String GroupRadioButton;
private static String GroupSex;
private static String str="";
@Override
public void start(Stage stage)
{
StackPane spane=new StackPane();
spane.setAlignment(Pos.CENTER);
spane.setPadding(new Insets(30));
Label name=new Label("按姓名查询:");
Label group=new Label("按分组查询:");
Label sex=new Label("按性别查询:");
Label age=new Label("按年龄查询:");
TextField tname=new TextField();
RadioButton familyers=new RadioButton("家人");
RadioButton colleague=new RadioButton("同事");
RadioButton schoolmate=new RadioButton("同学");
RadioButton teacher=new RadioButton("老师");
RadioButton friend=new RadioButton("朋友");
ToggleGroup toggroup=new ToggleGroup();
familyers.setToggleGroup(toggroup);
colleague.setToggleGroup(toggroup);
schoolmate.setToggleGroup(toggroup);
teacher.setToggleGroup(toggroup);
friend.setToggleGroup(toggroup);
HBox hbgroup=new HBox(10);
hbgroup.getChildren().addAll(group,familyers,colleague,schoolmate,teacher,friend);
RadioButton boy=new RadioButton("男");
RadioButton girl=new RadioButton("女");
ToggleGroup tog=new ToggleGroup();
boy.setToggleGroup(tog);
girl.setToggleGroup(tog);
HBox hbname=new HBox(10);
HBox hbsex=new HBox(10);
Button clear=new Button("重选");
clear.setTranslateX(150);
hbname.getChildren().addAll(name,tname,clear);
hbsex.getChildren().addAll(sex,boy,girl);
VBox vb=new VBox(10);
TextField startage=new TextField();
TextField endage=new TextField();
startage.setPrefWidth(50);
endage.setPrefWidth(50);
HBox hbage=new HBox(10);
Text t=new Text("—");
hbage.getChildren().addAll(age,startage,t,endage);
Label Lcity=new Label("按城市查询:");
ComboBox<String>cbo=new ComboBox<String>();
String[] city= {"北京市","上海市","广州市 ","深圳市","天津市","成都市","杭州市","苏州市","重庆市","武汉市","南京市","大连市","沈阳市","长沙市","郑州市","西安市","青岛市","无锡市","无锡市","宁波市","佛山市","南通市","哈尔滨市","东莞市","福州市","长春市","石家庄市","烟台市","合肥市","唐山市","常州市","太原市","昆明市","潍坊市","南昌市","泉州市","温州市","绍兴市","嘉兴市","厦门市","贵阳市","淄博市","徐州市","扬州市","呼和浩特市","鄂尔多斯市","乌鲁木齐市","金华市","台州市","镇江市","威海市","珠海市","东营市","大庆市","中山市","盐城市","包头市","保定市","济宁市","兰州市"};
ObservableList<String>items=FXCollections.observableArrayList(city);
cbo.getItems().addAll(items);
cbo.setPrefWidth(130);
cbo.setValue("请选择城市");
HBox hbcity=new HBox(10);
hbcity.getChildren().addAll(Lcity,cbo);
Label hobby=new Label("相同查询:");
CheckBox cb1=new CheckBox("球类运动");
CheckBox cb2=new CheckBox("文学阅读");
CheckBox cb3=new CheckBox("文学创造");
CheckBox cb4=new CheckBox("听音乐");
CheckBox cb5=new CheckBox("看电影");
CheckBox cb6=new CheckBox("绘画");
CheckBox cb7=new CheckBox("舞蹈");
CheckBox cb8=new CheckBox("冒险");
CheckBox cb9=new CheckBox("收藏");
CheckBox cb10=new CheckBox("网络游戏");
CheckBox cb11=new CheckBox("喝茶");
CheckBox cb12=new CheckBox("探索");
VBox vb1=new VBox(10);
VBox vb2=new VBox(10);
VBox vb3=new VBox(10);
VBox vb4=new VBox(10);
vb1.getChildren().addAll(cb1,cb2,cb3);
vb2.getChildren().addAll(cb4,cb5,cb6);
vb3.getChildren().addAll(cb7,cb8,cb9);
vb4.getChildren().addAll(cb10,cb11,cb12);
HBox hb=new HBox(20);
hb.getChildren().addAll(hobby,vb1,vb2,vb3,vb4);
TextArea ta=new TextArea();
ta.setPromptText("不可编辑");
ta.setEditable(false);
ta.setPrefHeight(200);
ta.setWrapText(true);
Button save=new Button("将查询结果导出");
Label remark=new Label("备注:");
Button exit=new Button("退出");
exit.setPrefHeight(30);
HBox hbo=new HBox(10);
hbo.setAlignment(Pos.CENTER);
hbo.getChildren().addAll(save,exit);
exit.setOnAction(e->{
Communication comm=new Communication();
comm.start(new Stage());
stage.close();
});
Text te=new Text("查询结果");
Button button=new Button("查询");
button.setTranslateX(50);
button.setPrefWidth(450);
button.setPrefHeight(30);
button.setAlignment(Pos.CENTER);
vb.getChildren().addAll(hbname,hbgroup,hbsex,hbage,hbcity,hb,button,te,ta,hbo);
spane.getChildren().add(vb);
stage.setTitle("添加好友到通讯录中");
toggroup.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (toggroup.getSelectedToggle() != null) {
RadioButton button = (RadioButton) toggroup.getSelectedToggle();
GroupRadioButton=button.getText();
}
}
});
tog.selectedToggleProperty().addListener(new ChangeListener<Toggle>() {
@Override
public void changed(ObservableValue<? extends Toggle> ov, Toggle old_toggle, Toggle new_toggle) {
if (tog.getSelectedToggle() != null) {
RadioButton button = (RadioButton) tog.getSelectedToggle();
GroupSex=button.getText();
}
}
});
cb1.setOnAction(e->{str+=cb1.getText()+"、";});
cb2.setOnAction(e->{str+=cb2.getText()+"、";});
cb3.setOnAction(e->{str+=cb3.getText()+"、";});
cb4.setOnAction(e->{str+=cb4.getText()+"、";});
cb5.setOnAction(e->{str+=cb5.getText()+"、";});
cb6.setOnAction(e->{str+=cb6.getText()+"、";});
cb7.setOnAction(e->{str+=cb7.getText()+"、";});
cb8.setOnAction(e->{str+=cb8.getText()+"、";});
cb9.setOnAction(e->{str+=cb9.getText()+"、";});
cb10.setOnAction(e->{str+=cb10.getText()+"、";});
cb11.setOnAction(e->{str+=cb11.getText()+"、";});
cb12.setOnAction(e->{str+=cb12.getText()+"、";});
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("提示");
alert.setHeaderText(null);
clear.setOnAction(e->{
tname.setText("");
familyers.setSelected(false);
colleague.setSelected(false);
schoolmate.setSelected(false);
teacher.setSelected(false);
friend.setSelected(false);
cb1.setSelected(false);
cb2.setSelected(false);
cb3.setSelected(false);
cb4.setSelected(false);
cb5.setSelected(false);
cb6.setSelected(false);
cb7.setSelected(false);
cb8.setSelected(false);
cb9.setSelected(false);
cb10.setSelected(false);
cb11.setSelected(false);
cb12.setSelected(false);
boy.setSelected(false);
girl.setSelected(false);
startage.setText("");
endage.setText("");
cbo.setValue("请选择城市");
});
button.setOnAction(e->{
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
if(tname.getText().length()>=1) {
String select1="select Classification.sectionalization, Communication.* from Communication,Classification where Communication.telephone=classification.telephone and Communication.cName=? and users=?";
ps=conn.prepareStatement(select1);
ps.setString(1, tname.getText());
ps.setString(2, User);
rs=ps.executeQuery();
boolean bool=true;
while(rs.next()) {
if(tname.getText().equals(rs.getString("cName"))) {
String sname="姓名: "+rs.getString("cName");
String sgroup="关系: "+rs.getString("sectionalization");
String ssex="性别: "+rs.getString("sex");
int iage=rs.getInt("age");
String sage="年龄: "+String.valueOf(iage);
String stel="电话: "+rs.getString("telephone");
String smail="邮箱: "+rs.getString("mailbox");
String scity="城市: "+rs.getString("city");
String shobby="爱好: "+rs.getString("hobby");
String sremark="备注: "+rs.getString("remark");
String sevent="事迹: "+rs.getString("cevent");
String st="";
String subhobby=shobby.substring(0,shobby.length()-1);
st+=sname+"\n"+sgroup+"\n"+ssex+"\n"+sage+"\n"+stel+"\n"+smail+"\n"+scity+
"\n"+subhobby+"\n"+sremark+"\n"+sevent;
ta.setText(st);
bool=false;
}
}
if(bool=false) {
alert.setContentText("请选择您要查询的条件！");
alert.showAndWait();
}
}
if((GroupRadioButton!=null)&&(GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=?"
+ "and sex=? and age between ? and ? and city=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(3, start);
ps.setInt(4, end);
ps.setString(5, cbo.getValue());
ps.setString(6, sh);
ps.setString(7, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and sex=? and age between ? and ? and city=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(2, start);
ps.setInt(3, end);
ps.setString(4, cbo.getValue());
ps.setString(5, sh);
ps.setString(6, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((!startage.getText().equals(""))&&(!endage.getText().equals(""))&&(!cbo.getValue().equals("请选择城市"))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and age between ? and ? and city=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(1, start);
ps.setInt(2, end);
ps.setString(3, cbo.getValue());
ps.setString(4, sh);
ps.setString(5, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((!cbo.getValue().equals("请选择城市"))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and city=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, cbo.getValue());
ps.setString(2, sh);
ps.setString(3, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((!startage.getText().equals(""))&&(!endage.getText().equals(""))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and age between ? and ? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(1, start);
ps.setInt(2, end);
ps.setString(3, sh);
ps.setString(4, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((GroupSex!=null)&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and sex=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, GroupSex);
ps.setString(2, sh);
ps.setString(3, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((GroupRadioButton!=null)&&(GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))&&(str.length()>0)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=? and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, sh);
ps.setString(3, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
if((GroupRadioButton!=null)&&(GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=?"
+ "and sex=? and age between ? and ? and city=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(3, start);
ps.setInt(4, end);
ps.setString(5, cbo.getValue());
ps.setString(6, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if((GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and sex=? and age between ? and ? and city=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(2, start);
ps.setInt(3, end);
ps.setString(4, cbo.getValue());
ps.setString(5, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if((!startage.getText().equals(""))&&(!endage.getText().equals(""))
&&(!cbo.getValue().equals("请选择城市"))) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and age between ? and ? and city=? and users=?";
ps=conn.prepareStatement(select);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(1, start);
ps.setInt(2, end);
ps.setString(3, cbo.getValue());
ps.setString(4, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if((GroupRadioButton!=null)&&(GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=?"
+ "and sex=? and age between ? and ? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(3, start);
ps.setInt(4, end);
ps.setString(6, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if((GroupSex!=null)&&(!startage.getText().equals(""))&&(!endage.getText().equals(""))) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone"
+ "and sex=? and age between ? and ? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupSex);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(2, start);
ps.setInt(3, end);
ps.setString(6, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if((GroupRadioButton!=null)&&(GroupSex!=null)) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=?"
+ "and sex=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, GroupSex);
ps.setString(3, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if(GroupRadioButton!=null) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Classification.sectionalization=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupRadioButton);
ps.setString(2, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if(GroupSex!=null) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Communication.sex=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, GroupSex);
ps.setString(2, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if(!startage.getText().equals("")&&!endage.getText().equals("")) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Communication.age between ? and ? and users=?";
ps=conn.prepareStatement(select);
int start=Integer.parseInt(startage.getText());
int end=Integer.parseInt(endage.getText());
ps.setInt(1, start);
ps.setInt(2, end);
ps.setString(3, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
ta.setText(str1);
}
}
if(!cbo.getValue().equals("请选择城市")) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and Communication.city=? and users=?";
ps=conn.prepareStatement(select);
ps.setString(1, cbo.getValue());
ps.setString(2, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
if(str.length()>0) {
String select="select Classification.cName,Classification.telephone from Communication,Classification where Communication.telephone=classification.telephone and hobby=? and users=?";
String selecthobby="select hobby from Communication where users=?";
ps=conn.prepareStatement(selecthobby);
ps.setString(1, User);
rs=ps.executeQuery();
int num=0;
String sh;
while(rs.next()) {
String[] hob=new String[12];
String[] strhob=new String[12];
String shobby=rs.getString("hobby");
String Str=str;
int n=0,m=0;
for(int i=0;shobby.length()>1;i++) {
int index=shobby.indexOf("、");
hob[i]=shobby.substring(0,index);
n++;
shobby=shobby.replace(shobby.substring(0,index+1), "");
}
for(int i=0;Str.length()>1;i++) {
int index=Str.indexOf("、");
strhob[i]=Str.substring(0,index);
m++;
Str=Str.replace(Str.substring(0,index+1), "");
}
if(m==n) {
for(int i=0;i<m;i++) {
for(int j=0;j<n;j++) {
if(strhob[i].equals(hob[j])){
num++;
}
}
}
}
if(num==n) {
sh=rs.getString("hobby");
ps=conn.prepareStatement(select);
ps.setString(1, sh);
ps.setString(2, User);
rs=ps.executeQuery();
String st=" 姓名 电话\n",str1="";
while(rs.next()) {
String sname=rs.getString("cName")+" ";
String stel=rs.getString("telephone")+"\n";
str1+=sname+stel;
}
ta.setText(st+str1);
}
}
}
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(rs!=null) {
rs.close();
}if(ps!=null) {
ps.close();
}if(conn!=null) {
conn.close();
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
});
save.setOnAction(e->{
FileChooser fc=new FileChooser();
fc.setTitle("文件保存对话框");
fc.setInitialDirectory(new File("C:\\Java文件流"));
FileChooser.ExtensionFilter filter=new FileChooser.ExtensionFilter(".txt", "*.txt");
fc.getExtensionFilters().add(filter);//设置文件过滤器
File file=fc.showSaveDialog(stage);
if(file!=null) {
try {
FileOutputStream f=new FileOutputStream(file);
BufferedOutputStream out=new BufferedOutputStream(f);
if(ta.getText().equals("")) {
alert.setContentText("导出内容不能为空");
alert.showAndWait();
}else {
byte[]b=(ta.getText()).getBytes();
out.write(b,0,b.length);
out.close();
}
}catch(IOException ioe) {};
}
});
Scene scene=new Scene(spane,600,650);
stage.setScene(scene);
stage.show();
}
}
class Output extends Application
{
public static String User;
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
@Override
public void start(Stage stage)
{
Text t=new Text("请输入您要导出好友的姓名");
t.setFont(new Font("黑体",18));
Label lab=new Label("姓名:");
TextField text=new TextField();
Button button=new Button("查询");
StackPane spane=new StackPane();
spane.setPadding(new Insets(10));
HBox hb=new HBox(20);
hb.setTranslateY(40);
hb.setAlignment(Pos.CENTER);
hb.getChildren().addAll(lab,text,button);
BorderPane bpane=new BorderPane();
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("错误");
alert.setHeaderText(null);
Button output=new Button("导出单个好友信息");
Button outputall=new Button("导出全部好友信息");
Button cannel=new Button("退出");
cannel.setOnAction(e->{
Communication comm=new Communication();
comm.start(new Stage());
stage.close();
});
HBox oc=new HBox(20);
oc.setAlignment(Pos.CENTER);
TextArea ta=new TextArea();
ta.setWrapText(true);
ta.setPromptText("不可编辑");
ta.setEditable(false);
ta.setPrefHeight(200);
ta.setTranslateY(100);
t.setTranslateY(-80);
hb.setTranslateY(-40);
spane.getChildren().addAll(t,hb,ta);
bpane.setPadding(new Insets(20));
bpane.setTop(spane);
bpane.setBottom(oc);
oc.getChildren().addAll(output,outputall,cannel);
button.setOnAction(e->{
String selectsql="select cName from Communication where users=?;";
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(selectsql);
ps.setString(1, User);
rs=ps.executeQuery();
while(rs.next()) {
if(text.getText().equals(rs.getString("cName"))) {
String name=text.getText();
String select="select Communication.*,Classification.sectionalization from Communication,Classification"
+ " where Communication.telephone=classification.telephone and Communication.cName=?;";
try {
ps=conn.prepareStatement(select);
ps.setString(1, name);
rs=ps.executeQuery();
while(rs.next()) {
String sname="姓名: "+rs.getString("cName");
String sgroup="关系: "+rs.getString("sectionalization");
String ssex="性别: "+rs.getString("sex");
int iage=rs.getInt("age");
String sage="年龄: "+String.valueOf(iage);
String stel="电话: "+rs.getString("telephone");
String smail="邮箱: "+rs.getString("mailbox");
String scity="城市: "+rs.getString("city");
String shobby="爱好: "+rs.getString("hobby");
String sremark="备注: "+rs.getString("remark");
String sevent="事迹: "+rs.getString("cevent");
String subhobby=shobby.substring(0,shobby.length()-1);
String str=sname+"\n"+sgroup+"\n"+ssex+"\n"+sage+"\n"+stel+"\n"+smail+"\n"+scity+
"\n"+subhobby+"\n"+sremark+"\n"+sevent;
ta.setText(str);
}
}catch(Exception ex) {
ex.printStackTrace();
}
}else {
alert.setContentText("查无此人,请重新输入！");
alert.showAndWait();
}
}
}catch(Exception ex) {
ex.printStackTrace();
}
});
output.setOnAction(e->{
if(text.getText().equals("")) {
alert.setContentText("请先调出您要导出的好友");
alert.showAndWait();
}else {
FileChooser fc=new FileChooser();
fc.setTitle("文件保存对话框");
fc.setInitialDirectory(new File("C:\\Java文件流"));
FileChooser.ExtensionFilter filter=new FileChooser.ExtensionFilter(".txt", "*.txt");
fc.getExtensionFilters().add(filter);//设置文件过滤器
File file=fc.showSaveDialog(stage);
if(file!=null) {
try {
FileOutputStream f=new FileOutputStream(file);
BufferedOutputStream out=new BufferedOutputStream(f);
byte[]b=(ta.getText()).getBytes();
out.write(b,0,b.length);
out.close();
}catch(IOException ioe) {};
}
}
});
outputall.setOnAction(e->{
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
String select="select Communication.*,Classification.sectionalization from Communication,Classification"
+ " where Communication.telephone=classification.telephone and Communication.users=?;";
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(select);
ps.setString(1, User);
rs=ps.executeQuery();
String str="";
while(rs.next()) {
String sname="姓名: "+rs.getString("cName");
String sgroup="关系: "+rs.getString("sectionalization");
String ssex="性别: "+rs.getString("sex");
int iage=rs.getInt("age");
String sage="年龄: "+String.valueOf(iage);
String stel="电话: "+rs.getString("telephone");
String smail="邮箱: "+rs.getString("mailbox");
String scity="城市: "+rs.getString("city");
String shobby="爱好: "+rs.getString("hobby");
String sremark="备注: "+rs.getString("remark");
String sevent="事迹: "+rs.getString("cevent");
String subhobby=shobby.substring(0,shobby.length()-1);
str+=sname+"\n"+sgroup+"\n"+ssex+"\n"+sage+"\n"+stel+"\n"+smail+"\n"+scity+
"\n"+subhobby+"\n"+sremark+"\n"+sevent+"\n"+"\n";
}
FileChooser fc=new FileChooser();
fc.setTitle("文件保存对话框");
fc.setInitialDirectory(new File("C:\\Java文件流"));
FileChooser.ExtensionFilter filter=new FileChooser.ExtensionFilter(".txt", "*.txt");
fc.getExtensionFilters().add(filter);//设置文件过滤器
File file=fc.showSaveDialog(stage);
if(file!=null) {
try {
FileOutputStream f=new FileOutputStream(file);
BufferedOutputStream out=new BufferedOutputStream(f);
byte[]b=(str).getBytes();
out.write(b,0,b.length);
out.close();
}catch(IOException ioe) {
ioe.printStackTrace();
}
}
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(rs!=null)
rs.close();
if(ps!=null)
ps.close();
if(conn!=null)
conn.close();
}catch(Exception ex) {
ex.toString();
}
}
});
Scene scene=new Scene(bpane,500,400);
stage.setTitle("导出通讯录好友信息");
stage.setScene(scene);
stage.show();
}
}
class Enroll extends Application
{
private static String driver="com.mysql.cj.jdbc.Driver";
private static String url="jdbc:mysql://localhost:3306/test?serverTimezone=UTC";
private static String user="root";
private static String password="123456";
private Connection conn=null;
private PreparedStatement ps=null;
@Override
public void start(Stage primaryStage)
{
final TextField tf=new TextField();
final PasswordField pf=new PasswordField();
final TextField tel=new TextField();
final Label username=new Label("用户名:");
final Label telephone=new Label("号 码:");
final Label userpassword=new Label("密 码:");
final Button enroll=new Button("立即注册");
Alert alert=new Alert(AlertType.INFORMATION);
alert.setTitle("错误");
alert.setHeaderText(null);
enroll.setPrefWidth(200);
StackPane spane=new StackPane();
Text text=new Text("欢迎注册");
text.setFont(new Font("黑体",20));
text.setTranslateY(80);
spane.getChildren().add(text);
tf.setPromptText("请输入用户名");
pf.setPromptText("请输入密码");
tel.setPromptText("手机号码");
GridPane gpane=new GridPane();
gpane.setHgap(10);
gpane.setVgap(15);
gpane.setAlignment(Pos.CENTER);
gpane.add(username, 0, 0);
gpane.add(tf, 1, 0);
gpane.add(userpassword, 0, 1);
gpane.add(pf, 1, 1);
gpane.add(telephone, 0, 2);
gpane.add(tel, 1, 2);
gpane.add(enroll, 1, 3);
BorderPane bpane=new BorderPane();
bpane.setTop(spane);
bpane.setCenter(gpane);
enroll.setOnAction(e->{
if(tel.getText().length()!=11) {
alert.setContentText("电话输入错误，请重新输入");
alert.showAndWait();
tel.setText("");
}else if(pf.getText().length()<6) {
alert.setContentText("密码长度不能少于6位");
alert.showAndWait();
pf.setText("");
}else {
String select="select users from user";
try {
Class.forName(driver);
Connection co=DriverManager.getConnection(url,user,password);
Statement stmt=co.createStatement();
ResultSet rs=stmt.executeQuery(select);
while(rs.next()) {
if(tf.getText().equals(rs.getString("users"))) {
alert.setContentText("该用户已经存在，请重新输入");
alert.showAndWait();
break;
}else {
String insertsql="insert into user values(?,?,?)";
try {
Class.forName(driver);
conn=DriverManager.getConnection(url,user,password);
ps=conn.prepareStatement(insertsql);
ps.setString(1, tf.getText());
ps.setString(2, pf.getText());
ps.setString(3, tel.getText());
ps.executeUpdate();
}catch(Exception ex) {
ex.printStackTrace();
}finally {
try {
if(ps!=null)
ps.close();
if(conn!=null)
conn.close();
}catch(Exception ex) {
ex.printStackTrace();
}
}
alert.setContentText("账号已注册成功!");
alert.showAndWait();
primaryStage.hide();
Java java=new Java();
java.start(new Stage());
}
}
}catch(Exception ex) {
ex.printStackTrace();
}
}
});
Scene scene=new Scene(bpane,500,400);
primaryStage.setTitle("注册");
primaryStage.setScene(scene);
primaryStage.show();
}
}
06-21
2178
2178
06-12
“相关推荐”对你有帮助么？
-
非常没帮助 -
没帮助 -
一般 -
有帮助 -
非常有帮助
提交
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
