Ho使用Netbeans生成报告 [英] Ho to generate report using Netbeans
本文介绍了Ho使用Netbeans生成报告的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
import java.util.regex.*;
import java.sql.*;
public class Telecom {
public Telecom(){
connect();
}
public void connect(){
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String db= "jdbc:odbc:Driver={Microsoft Access Driver " + "(*.mdb, *.accdb)};DBQ=D:\\TelecomeDatabase.mdb";
Connection con = DriverManager.getConnection(db);
Statement st = con.createStatement();
String sql = "select * from CustomerInfo";
ResultSet rs = st.executeQuery(sql);
while (rs.next())
{
String record = rs.getString("RecordNo");
String file = rs.getString("FileNo");
String Deposit = rs.getString("Deposite");
// Deposit
String pattern1="UiRCcOs74Q3oiro9v6oSfw==";
String pattern2="0iMNFDYVBEEO3GpeehM2CA==";
boolean patternMatched1 = Pattern.matches(pattern1, Deposit);
boolean patternMatched2 = Pattern.matches(pattern2, Deposit);
if(!(patternMatched1||patternMatched2))
{
System.out.println(file+ "..."+record+"...Deposit");
}
// Balance
String Balance = rs.getString("Balance");
String pattern3="DFRnh7oBC9LDv0C92bHbGg==";
String pattern4="PncOzpz3N\\+RmEODQoQGPxg==";
boolean patternMatched3 = Pattern.matches(pattern3, Balance);
boolean patternMatched4 = Pattern.matches(pattern4, Balance);
if(!(patternMatched3||patternMatched4))
{
System.out.println(file+ "..."+record+"...Balance");
}
String CreditRate = rs.getString("CreditRate");
String pattern5="OiTWdthYeBQoIuEWrqPCtg==";
String pattern6="kuYahrq16NK1HikHf\\+YuMg==";
String pattern7="tmpM9sJUbcf08DoWzE2ldA==";
String pattern8="ieWCqWGkCXeaudyQDzgYGA==";
boolean patternMatched5 = Pattern.matches(pattern5, CreditRate);
boolean patternMatched6 = Pattern.matches(pattern6, CreditRate);
boolean patternMatched7 = Pattern.matches(pattern7, CreditRate);
boolean patternMatched8 = Pattern.matches(pattern8, CreditRate);
if(!(patternMatched5||patternMatched6||patternMatched7||patternMatched8))
{
System.out.println(file+ "..."+record+"...Credit Rate");
}
}
} catch(Exception ex){
}
}
public static void main(String[] args) {
new Telecom();
}
}
推荐答案
你没解决您的真实问题 [ ^ ] - 请先进行。
当你忽略它时,它不会变得更好。
You did not solve your real problem[^] - please go for that first.
It does''t get better when you ignore it.
这篇关于Ho使用Netbeans生成报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文