📄 mainframe.java
字号:
String dburl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/MobileDB.dat"; //此为NO-DSN方式
Connection conn = DriverManager.getConnection(dburl);
PreparedStatement ps = conn.prepareStatement(
"select area,t from list where num=?");
ps.setString(1, number);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
if(language.lang){
showtalk("手机号码：" + mobile + "\n 地区:" +
rs.getString(1) + "\n 号码类型:" +
rs.getString(2)
);
}else{
showtalk("Mobile No.：" + mobile + "\n Area:" +
rs.getString(1) + "\n Number Type:" +
rs.getString(2)
);
}
} else {
try {
String dbur =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection con = DriverManager.getConnection(
dbur);
PreparedStatement pss = con.prepareStatement(
"select reply from rebot where answer like ?");
pss.setString(1, jTextArea2.getText().trim());
ResultSet rss = pss.executeQuery();
if (rss.next()) {
showtalk(rss.getString(1));
} else {
if (Mainframe.errnum < 2) {
if(language.lang){
showtalk("这个问题我不会，请你教我吧^_^");
}else{
showtalk("Sorry,I don't Know,Could you help me to learn it?^_^");
}
} else {
if(language.lang){
showtalk(
"这个问题我不会，请你教我吧^_^\n需要帮助请输入“帮助”或“help”");
}else{
showtalk(
"Sorry,I don't Know,Could you help me to learn it?^_^\nIf you need Help,Please input 'Help'");
}
Mainframe.errnum = 0;
}
Mainframe.errnum++;
}
rss.close();
con.close();
} catch (SQLException es) {
es.printStackTrace();
}
}
rs.close();
conn.close();
} catch (SQLException es) {
es.printStackTrace();
}
} else if (jTextArea2.getText().trim().startsWith("问:")||jTextArea2.getText().trim().startsWith("Q:")) {
String wen = jTextArea2.getText().trim().substring(2);
try {
String dburl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection conn = DriverManager.getConnection(dburl);
PreparedStatement ps = conn.prepareStatement(
"select * from rebot where answer like ?");
ps.setString(1, wen);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
if(language.lang){
jTextArea1.setText(Mainframe.answer +
"\n小叮当: " +
format.format(new Date()) +
"\n 你已经教过我这句了,想让我重新记忆么?那就输入回答吧!^_^\n\n");
jTextArea2.setText("答:");
}else{
jTextArea1.setText(Mainframe.answer +
"\nXdd: " +
format.format(new Date()) +
"\n You has already to teach this quesstion to me,Do you want to remember again?Please input the Answer!^_^\n\n");
jTextArea2.setText("A:");
}
Mainframe.answer = jTextArea1.getText();
Mainframe.question = jTextArea2.getText();
Mainframe.teachnum = 3;
Mainframe.teach = wen;
} else {
Mainframe.teach = wen;
if(language.lang){
jTextArea2.setText("答:");
}else{
jTextArea2.setText("A:");
}
Mainframe.answer = jTextArea1.getText();
Mainframe.question = jTextArea2.getText();
Mainframe.teachnum++;
}
rs.close();
conn.close();
} catch (SQLException es) {
es.printStackTrace();
}
} else if (jTextArea2.getText().trim().startsWith("答:")||jTextArea2.getText().trim().startsWith("A:")) {
String da = jTextArea2.getText().trim().substring(2);
Mainframe.get2 = da;
if (Mainframe.teachnum >= 2) {
if (Mainframe.get2.equals(Mainframe.get1)) {
try {
String dburl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection conn = DriverManager.getConnection(
dburl);
PreparedStatement ps = conn.prepareStatement(
"select * from rebot where answer like ?");
ps.setString(1, Mainframe.teach);
ResultSet rs = ps.executeQuery();
if (rs.next()) {
try {
String dbur =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection con = DriverManager.
getConnection(
dbur);
PreparedStatement pss = con.
prepareStatement(
"update rebot set reply=? where answer=?");
pss.setString(1, da);
pss.setString(2, Mainframe.teach);
int i = pss.executeUpdate();
if (i == 1) {
if(language.lang){
showtalk("记住了,考考我吧! ^_^");
}else{
showtalk("Got it!,Sir! ^_^");
}
Mainframe.teachnum = 0;
}
} catch (SQLException es) {
es.printStackTrace();
}
} else {
try {
String d =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection c = DriverManager.
getConnection(
d);
PreparedStatement p = c.
prepareStatement(
"insert into rebot(answer,reply) values(?,?)");
p.setString(1, Mainframe.teach);
p.setString(2, da);
int i = p.executeUpdate();
if (i == 1) {
if(language.lang){
showtalk("记住了,考考我吧! ^_^");
}else{
showtalk("Got it!,Sir! ^_^");
}
Mainframe.teachnum = 0;
}
c.close();
} catch (SQLException es) {
es.printStackTrace();
}
}
rs.close();
conn.close();
} catch (SQLException es) {
es.printStackTrace();
}
} else {
if(language.lang){
showtalk("答案怎么和上次不一样？重新教我吧");
}else{
showtalk("The Answer is different from the old,Please teach me again");
}
Mainframe.get1 = da;
Mainframe.teachnum = 0;
}
} else {
Mainframe.get1 = da;
if(language.lang){
showtalk("再教我一遍嘛.....我笨笨..^_^");
}else{
showtalk("Please teach again.Thank you very much! ^_^");
}
Mainframe.teachnum++;
}
} else if (jTextArea2.getText().trim().equals("帮助") ||
jTextArea2.getText().trim().toLowerCase().equals(
"help")) {
Mainframe.help = true;
if(language.lang){
showtalk(" 1.教我知识\n 2.查询手机归属地\n 3.查询IP地址");
}else{
showtalk(" 1.Teaching\n 2.Find Mobile\n 3.Find IP address");
}
} else if (jTextArea2.getText().trim().equals("我是谁") ||
jTextArea2.getText().trim().equals("我叫什么")||jTextArea2.getText().trim().equals("Who am I")){
if (Application.name == "用户"||Application.name == "User")
{
if(language.lang){
showtalk("你又没告诉过我,我怎么能知道???");
}else{
showtalk("You had never tell me,How can I get it???");
}
} else {
if(language.lang){
showtalk("你叫" + Application.name);
}else{
showtalk("Your name is " + Application.name+", is there something wrong ?");
}
}
} else if (jTextArea2.getText().trim().equals("时间") ||
jTextArea2.getText().toLowerCase().equals("time") ||
jTextArea2.getText().trim().equals("现在几点?") ||
jTextArea2.getText().trim().equals("现在几点") ||
jTextArea2.getText().trim().equals("现在时间")) {
showtalk(Application.fulltime);
} else {
if (Mainframe.help) {
if(language.lang){
if (jTextArea2.getText().trim().
equals("1")) {
showtalk(
"请按如下格式输入您的问题和想要的答案\n 问:\"您的问题\" 点击OK\n 答:\"想要的回答\" 点击OK");
Mainframe.help = false;
} else if (jTextArea2.getText().trim().equals("2")) {
showtalk(" 直接输入手机号码即可\n暂时不支持15开头手机号码查询");
Mainframe.help = false;
} else if (jTextArea2.getText().trim().equals("3")) {
showtalk(" 直接输入IP地址即可 本功能尚未开发完毕,敬请期待");
Mainframe.help = false;
}
}else{
if (jTextArea2.getText().trim().
equals("1")) {
showtalk(
"Please input you qesstion and answer like this:\n Q:\"Your Quesstion\" Click OK\n A:\"Your Answer\" Click OK");
Mainframe.help = false;
} else if (jTextArea2.getText().trim().equals("2")) {
showtalk(" Input the Mobile number \nNot Suppost the number begin with '15'");
Mainframe.help = false;
} else if (jTextArea2.getText().trim().equals("3")) {
showtalk(" Input the Ip Address \nThe Ip searching is has something wrong,I'll change it as soon as possible");
Mainframe.help = false;
}
}
} else {
try {
String dburl =
"jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=data/rebot.dat"; //此为NO-DSN方式
Connection conn = DriverManager.getConnection(dburl);
PreparedStatement ps = conn.prepareStatement(
"select reply from rebot where answer like ?");
ps.setString(1, jTextArea2.getText().trim());
ResultSet rs = ps.executeQuery();
if (rs.next()) {
showtalk(rs.getString(1));
} else {
if (Mainframe.errnum < 2) {
if(language.lang){
showtalk("这个问题我不会，请你教我吧^_^");
}else{
showtalk("Sorry,I don't Know,Could you help me to learn it?^_^");
}
} else {
if(language.lang){
showtalk(
"这个问题我不会，请你教我吧^_^\n需要帮助请输入“帮助”或“help”");
}else{
showtalk(
"Sorry,I don't Know,Could you help me to learn it?^_^\nIf you need Help,Please input 'Help'");
}
Mainframe.errnum = 0;
}
Mainframe.errnum++;
}
rs.close();
conn.close();
} catch (SQLException es) {
es.printStackTrace();
}
}
}
}
} else {
if(language.lang){
showtalk("你究竟想要说些什么呢？？@_@");
}else{
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -