Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package database_console;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.SQLException;
- import java.sql.Statement;
- import java.sql.ResultSet;
- public class DBConnect {
- public static void main(String[] args) {
- try {
- String host = "jdbc:derby://localhost:1527/AccountProgramDB";
- String user = "cys19821982";
- String pass= " chen88566222 ";
- Connection con = DriverManager.getConnection( host, user, pass );
- Statement stmt = con.createStatement( );
- String SQL = "SELECT * FROM SHENJIWAIZI1";
- ResultSet rs = stmt.executeQuery( SQL );
- while ( rs.next( ) ) {
- String 报告文号 = rs.getString("报告文号");
- String 被审计单位名称 = rs.getString("被审计单位名称");
- String 被审计单位类型 = rs.getString("被审计单位类型");
- String 审计年度 = rs.getString("审计年度");
- String 发票日期 = rs.getString("发票日期");
- String 报告日期 = rs.getString("报告日期");
- String 签字注册会计师 = rs.getString("签字注册会计师");
- String 意见类型 = rs.getString("意见类型");
- String 已审资产总额_元 = rs.getString("已审资产总额_元");
- String 已审营业收入_元 = rs.getString("已审营业收入_元");
- String 收费金额_元 = rs.getString("收费金额_元");
- String 备注 = rs.getString("备注");
- System.out.println( 报告文号 + " " + 被审计单位名称 + " " + 被审计单位类型 +" "+ 审计年度 +" "+ 发票日期 +" "+ 报告日期 +" "+ 签字注册会计师 +" "+ 意见类型 +" "+ 已审资产总额_元 +" "+ 已审营业收入_元 +" "+ 收费金额_元 +" "+ 备注 );
- }
- }
- catch ( SQLException err ) {
- System.out.println( err.getMessage( ) );
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement