java odbc-jdbc连接

就是简单的记录下

第一步：配置数据源

private static Connection conn = null;
	 private ResultSet rs = null; 
	 private static String drivername = "sun.jdbc.odbc.JdbcOdbcDriver"; 
	 private static String URL="jdbc:odbc:mytest";
	 
	 public static Connection getConnection()
	 {
		 try {
			Class.forName(drivername);
			try {
				DriverManager.getConnection(URL,"sa","sa");
			} catch (SQLException e) {
				// TODO Auto-generated catch block
				System.out.println("aa");
				e.printStackTrace();
			}
		} catch (ClassNotFoundException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return conn;
	 }
	 public static void main(String[] args) {
		getConnection();
	}