deliverdata.java

联通的SGIP协议Java实现

package test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class DeliverData {
	ResultSet result = null;
	Connection con = null;
	Statement state = null;

	public ResultSet getResult() {

		try {
			String driver = "oracle.jdbc.driver.OracleDriver";
			Class.forName(driver);
			con = DriverManager.getConnection(
					"jdbc:oracle:thin:@localhost:1521:oracle", "SGIP", "SGIP");
			state = con.createStatement();
			String sql = "select * from driver_violation_info where DVI_ID=8732535";
			result = state.executeQuery(sql);
			System.out.print(result);

		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return result;
	}

	public String data() {
		StringBuffer sb = new StringBuffer();
		result = getResult();
		try {
			while (result.next()) {
				sb.append("编号=" + result.getInt(1) + "\n");
				sb.append("车牌=" + result.getString(2) + "\n");
				sb.append("车辆类型=" + result.getString(3) + "\n ");
				sb.append("车主=" + result.getString(4) + " \n");
				sb.append("地址=" + result.getString(4) + "\n ");
				sb.append("违章地区=" + result.getString(5) + "\n");
			}
			if (result != null)
				result.close();
			if (state != null)
				state.close();
			if (con != null)
				con.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
		return sb.toString();
//		 System.out.println(sb.toString());
	}

//	public static void main(String[] agrs) {
//		new DeliverData().data();
//	}

}