Java学习源代码

package com.huawei.globe;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
public class CrossConectionContextSheet
{
 CrossCalition cc = new CrossCalition();
 private final static String driver = "com.mysql.jdbc.Driver";
 private final static String url = "jdbc:mysql://localhost:3306/test";
 private final static String name = "root";
 private final static String password = "123456";
 static Connection conn = null;
 Statement st = null;
 ResultSet rs = null;
 private void pack() throws Exception
 {
  String sql = "select * from globe_sdh_snc_tmp where cName=" + "'TAS'";
  Class.forName(driver);
  conn = DriverManager.getConnection(url, name, password);
  st = conn.createStatement();
  rs = st.executeQuery(sql);
  ArrayList<CrossCalition> list = new ArrayList<CrossCalition>();
  CrossCalition cross = null;
  while (rs.next())
  {
   cross = new CrossCalition();
   cross.setId(rs.getInt("id"));
   cross.setCname(rs.getString("cName"));
   cross.setCsquence(rs.getString("cSquence"));
   cross.setCrossType(rs.getString("cross_type"));
   cross.setSrcNe(rs.getString("src_ne"));
   cross.setSrcSlot(rs.getString("src_slot"));
   cross.setSrcPort(rs.getString("src_port"));
   cross.setSnkNe(rs.getString("snk_ne"));
   cross.setSnkSlot(rs.getString("snk_slot"));
   cross.setSnkPort(rs.getString("snk_port"));
   System.out.println(rs.getInt(1) + "\t" + rs.getString(2) + "\t"
     + rs.getString(3) + "\t" + rs.getString(4) + "\t"
     + rs.g